I'm using Impromptu 5.0 over the Syteline ERP. For catalogs, the then Symix folks were kind enough to create a bunch of user-friendly catalogs over one of our twelve Progress databases. I'd like to re-create those same catalogs over some of the other Progress databases. I can copy the catalog easily enough in Windows, but I think it is still pointing to the same database it was created over (or against).
Is there a way to edit the metadata in a catalog to make it point to another database? Of course, the schema in these twelve databases is exactly the same, so no worries about table/field name mismatches.
Well, I don't know much about version 5, but later versions use a DSN entry to define the database connection. If you change where the DSN is pointing to, you should be able to reuse the same catalog.
But as I said, maybe version 5 did it differently...?
Good luck!
You could modify the "Cognos.ini" file, where the database connection information is held. This file can typically be found in \\installdrive\program files\cognos\.
Firstly find which database name
There should be an entry in there for you existing catalog.
cheers,
DW
Hi
If you have the administrator version you could select catalog - tables menu option to find out what logical database your catalog is using.
NKT
That's correct. Truman..that logical DB name is a logical name in Impromptu that is pointed to an ODBC data source that connects to the Progress database.
When you copy the catalog and save it, the new catalog is still pointing to the earlier ODBC data source which is connecting to the earlier database.
You can do this:
1> Create a new ODBC data source for connecting to the 'other' database. You might have to create a diff. ODBC data souce for each of those 12 DB's.
2> Open the new catalog (which you copied from the original). Choose Catalog/Tables option. Change the logical DB name to point to the new ODBC data source.
I have done this with MFG/PRO and MXP.
Edited :For spelling mistakes.
Fantastic advise, all! I've made catalog copies for all twelve sites and data is correctly flowing from each one, through their own ODBC definition.
Thanks!