Catalog connectivity 3

[vijayleads]

I am wondering if it is possible to take a catalog and point it or connect it to a another database. This other database is exactly the same as the first one that the catalog is connected to. THe only reason I need to do this is because the second database has only 10% of the data so it is easier or faster for my queries to run.

I do not want to create a new catalog and build all the joins and resolve the loops. I want to take an existing catalog and disconnect it from the first database and connect with the second knowing that the second database is identical to the first.

Please let me know. Any help will be deeply appreciated.

Thanks

 

[goldsmt]

Hi

You have to take the following steps

Take a copy & rename the catalog file

Create a new logical database connection pointing to you development database. Call this somthing like DBNEWCONNECT

Open the existing Catalog, but do not connect to the database

Open the Tables window. Menue = Catalog -> Table

Bottom left hand corner is a drop down list box to the databases, currently pointing to the old logical database. Use the selection to point to the new logical database connection defined above.

Verify the tables


Hope this helps

Tony Goldsmith

 

[carlosalvidrez]

Tony,
What do you mean by "Create a new logical database connection pointing to you development database. Call this somthing like DBNEWCONNECT". Is that an ODBC?

Thanks

 

[griffindm]

The 'Logical Database' Tony refers to is the construct in Impromptu, found under Catalog | Databases. This is where you create and name a connection to a database. By creating a new Logical Database pointing to a different database with an identical structure, you can change the pointer in a copy of a catalog to point to the different database without having to do any other changes. On a side note, you can also do this LOCALLY (i.e. effecting only your computer), by changing the defined database for an existing Logical Database. Then catalogs that you use that reference this same Logical Database will point to a different physical database on your computer only.This can be useful at times when you need to toggle between a production database and a testing copy.

Regards,

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

http://www.decisionsupportgroup.com

 

[carlosalvidrez]

Dave,
Thanks a lot for your response. I have a new question for you (please let me know if I should post a separate thread).

How could I create a catalog from a local Microsoft Access database? "Access" is not being shown on the "Database Definition Manager" window.

Please advise,
Carlos

 

[griffindm]

Carlos,

Use ODBC.

Regards,

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

http://www.decisionsupportgroup.com