Idetify the datasource used in each namespace

[bluecarbon]

Hi,
I have a project having many namespaces and data sources. Please let me know how can i identify which datasource is used for which namespace or query subject.
It would be great if you elobrate the steps to identify the datasources used.

[RKMI]

Hi,

If you want to figure out your datasource just right click on the query subject -> edit definition -> query information on the bottom right there is Test Sample which will retrive cognos genrated SQL which should point you to your data source.

If you are trying to identify which are you database layer object they will be denoted with a different icon with a database symbol, other with it will be model query subjects which point to your database query subject. I hope this helps...  :)

Thanks,
RK

[bluecarbon]

Hi,
Thanks for your helpl. I have identified the database name and credentials of a Data source from Cognos Administration menu in Cognos Connection.