Connecting two databases from Catalog???

[subbulu]

Hello Guys,
I have small doubt can we connect for multiple databases from catalog.
I would apprciate for ur help.
Thanx in Advance.

 

[DrSimon]

There's a cunning idea which you can find on the Cognos site in the KBS written by Koen Kuilenberg. Basically it uses Access as an interface. You create an Access database and link to the tables you want which can be from multiple database (and assuming you have the drivers) multiple database type. You then create a ODBC link to the Access database and you're off.

I assume that this won't work properly for large applications. If that's what you're after then I suppose it's down to Architect and big bucks going to Cognos.

Simon Rouse

 

[griffindm]

Check out thread401-291991, thread401-189898, and thread401-245302

HTH,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[LaoDe]

All those solutions using MS-Access to collect/link tables from SQL-Server + Oracle are good practise solutions.

For performance and stability reasons I would choose the Oracle Gateway to SQL-Server. I don't know if this Gateway could be used to link a SQL-Server-Table into the Oracle-Instance so it looks as if it is local in the Oracle-Instance and so can be shown in the Cognos-Catalog, but for sure you can use the gateway to query that SQL-Server Table on a regualry base and store it in an Oracle-materialized view.

Using this materialized view as source for Cognos-Catalog, you speed up at report-generation-time and you rely only on 1 connection to 1 Databases instead of multi-Database-connects.

Lao De

 

[subbulu]

Hello Friends,
I have a problem like I have done a report bu using SQL Query.after that Cognos GUI became disable.Actually I have to calculate each column vise for that i have written a SQL query,but I cant insert that SQL query with in that Query which i done for report.So what I did I made another report for all totals by using SQL Query.
Can I Insert that report into main report?.
Pleaz help me.
I would apprciate for ur great help.
Thanx in Advance.