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)?
Nope... not possible...
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...