How to know that a Data Source is pointing to which database in FM

[inu]

Hi Team,

Please let know , How can i know which database are being used for the particular data souce...

Because in my project , several databases have been created..

Thanks in advance..

Regards
Inam

[bdbits]

Ask your admin to tell you. It is configured within the Cognos admin functions, which you might not have access to see for yourself.

[inu]

Ask your admin to tell you. It is configured within the Cognos admin functions, which you might not have access to see for yourself.

Thanks, I have admin access as well,, I m new to this,,
So please tell me the steps to see the corresponding DB..


Regards
Inam

[bdbits]

Go into Cognos admin, click on the Configuration tab. Find the datasource, click on it to get the connection(s). Get properties on the connection, click the Connection tab. What you see there is going to vary with data source. You may have a "Connection string" entry - if so click the little pencil icon to see those details, at which point you may have Native and JDBC tabs.

[bus_pass_man]

Each data source connection in an FM model has several properties.  The most important ones for this case are Name, content manager data source, catalog, and schema. 

Name is an arbitrary value.  It is derived from the name of the content manager data source that you imported.  If you import from more than one unique combination of cm data source catalog and schema then the default behaviour is to append a number to the name to distinctly identify it.   You can rename the name property to be anything.  Giving it a name such as {content manager data source name}_{catalog}_{schema} or the like could help in troubleshooting, such as tracing sql.

Content manager data source is the name of the data source in content manager (which you can see in the data source connections tab of the configuration page of cognos administration.)

catalog and schema are values obtained from the data base and do not need to be explained in detail here I hope.

In cognos administration there's a page called configuration.  In it is a tab called data source connections.  That contains a list of the data source connections which have been set up in your portal.

If you click on a data source in cognos administration you will be brought into a new page.

There will be a breadcrumb trail just below the configuration tab with directory>cognos>{whatever your data source name is}
On the right at actions there's a box icon called set properties.
click on it and click on the connection tab.
click on the pencil icon that is to the right of the conntection string

Depending on the data base and whether you are using dqm or not you would need to inspect either the cli or jdbc tabs for the information

If the former, in many cases you will need to know the alias information which was used by the person who set up the data source connection. That information is used by the data base client to point to the data base itself.  Usually it is stored in a file (TNS names for oracle).

One additional benefit of using dqm is you don't need to futz about with data base clients and trying to track down what information is in the alias file.