Adding data from Sql server

[sairaochowdary]

Hi Anybody
1.I have a report with data pulled from oracle database,is it possible to load data from sql server into same report.
2. different tables into catalog from different datasources(oracle& sql server)

Thanks
sairaochowdary

 

[GJParker]

Impromptu doesn't support multiple datasources.

The way to do this would be to link the tables from SQL Server and Oracle into an access database and use this as the datasource for your catalog.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[CognosTechUser]

A couple more options ...

1. You could create Hotfiles against one of the databases (must be a seperate catalog) and join the hotfile to your table(s). Access "may" have troubles large amounts of data.

2. Add your Oracle connection as a "Linked Server" in SQL Server and use SQL Server Views or Stored procedures for your data access.

 

[DoubleD]

I would disagree with CognosTechUser's first option. If the files are too large for Access to handle well, they will be so large that running queries against the HotFiles will be extremely slow.

Option 2 and GJParker's suggestions are both good.

Pain is stress leaving the body.

DoubleD

 

[griffindm]

Along the lines of what CognosTechUser mentioned, you can also add Oracle Generic Connectivity and create a synonym for the SQL tables from within Oracle (like the SQL Server Linked Server, but from the other direction).

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com