Why can't I add tables from multi databases into 1 catalog?

[helloworld689]

I am using Impromptu 7.0. I tried to add some tables from another database (another ODBC resource) into a existing catalog, I didn't get any errors, but the "ADD" button is always greyed out. Why?

Thanks for any feedbacks!

 

[spicysudhi]

one catalog, one database (data source)... isnt it???

regards,
sudhi

 

[GJParker]

Impromptu catalogs Only allow 1 database connection.

The way around this is to use hotfiles or connect to the second database through the first one i.e. link tables from both databases into access.

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[griffindm]

A better way around this is to use database links, if your datasource supports them.

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

 

[johnherman]

You are witnessing one of the chief complaints about Impromptu. Dave Griffin's idea presents an interesting work-around.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[griffindm]

There have also been a couple of threads here that suggest you can use Access as an intermediary, by creating 'link' tables to different ODBC sources, and then adding the Access tables to an Impromptu catalog. Supposedly it allows you to use widely different datasources. I haven't tried it, and I suspected that you would still be prompted for the DSN passwords, but others here seemed to indicate that they made it work. It may be worth a try.

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

 

[rcaesar]

I had a similar problem some time ago. I had use an Access DB with a DB2. I set up an ODBC into Access for the DB2 tables. Then I used the Access db for the catalog.

Hope this helps.

Rgs

 

[drlex]

If you have a 3rd party ODBC connection, you may find it is possible to connect to 2 or more databases of the same type as part of the ODBC set up, an example being the Openlink ODBC connection to Progress DBs.


"Time flies like an arrow, but fruit flies like a banana."