access multiple databases

[mksmks]

Hi,

I have to access from 3 databases in the catalog thru ODBC. I created the logical database for each of them in Impromptu.
I first created the catalog with few tables from 1st databse. Then when I wanted to include tables from other database into the catalog, I selected another corresponding db in the Tables screen. As soon as this is done, the first (original) db name changes to the new one. And hence all the tables in it are invalid.

I assume we have to proceed the same way for accessing multiple dbs. But couldnt succeed.

So how to access multiple databases? Is there any setting?
Please help me in this.

Thanks

 

[Viper6]

As far as I know impromptu can only connect to one "datasource" at a time. The only exception to this is hot files. Impromptu can connect to one datasource and many hotfiles at the same time. If you need to connect to many datasources (ie. multiple databases) then I think you have to use a datawarehousing solution such as Decision Stream.

 

[griffindm]

Viper6's comments are basically correct. There are only three ways to use data from more than one database. The traditional method is to use hotfiles (different catalogs for each database. create a hotfile from the first two databases, then use the hotfiles within the last catalog to merge data).

Another alternative is available if all three of the databases are on the same RDBMS. Oracle, for example allows you to reference remote databases using a technique known as a DBLink. Such links have a local alias that can be included in a catalog with the local database. Two such links to other Oracle databases could effectively allow an Impromptu catalog to pull data from three databases at once directly without the need for hotfiles.

The final alternative is to use a multi-database ODBC driver. A couple of vendors have these. The one I've looked at during a Cognos User Conference was by a firm named Metagon. They have a website where you can check out their product capabilities, but expect to pay a premium for this capability.

HTH,

Dave Griffin