If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data Sources used by a package?

Started by GSpeare, 20 Oct 2009 03:43:24 PM

Previous topic - Next topic

GSpeare

Is there any way to tell what data sources are used by a package (in Cognos 8.4)? I know that if you have the project file you can open it in Framework Manager and look, but what if the project file is not available (or if you don't know which project file a package came from)?


sir_jeroen


prikala

If you can export the package, and you
- unzip the export archive
- find data\0.dat, rename it to 0.gz,
- uncompress 0.gz with gunzip
then somewhere in the resulting file you can find something like this:
<dataSources><dataSource><name>Db name in the model</name><queryProcessing>limitedLocal</queryProcessing><cmDataSource>Db name in the contentstore</cmDataSource><schema/><type><queryType>relational</queryType><interface>OR</interface></type></dataSource></dataSources>

You can also recover the model from the package, search for "How to recover a Framework Manager model from the content store in Cognos 8" at IBM site...