Fix Pack 9

Configuring the data source in IBM Cognos Analytics

You can use IBM® Cognos® Analytics to configure the data source.

Ensure that one of the following situations is true:
  • The TADDM database is cataloged locally.
  • IBM Cognos Analytics is running on the server hosting the TADDM database.

If you are using a DB2® database, check that the schema name matches the DB2 instance name. The schema name specifies the DB2 database name used to authorize access to the specified database. You specified the DB2 instance name when installing TADDM. The default instance name specified in the TADDM model.xml file is DB2INST1. If required, change the name of the schema.

If you are using an Oracle database, ensure that the schema name is blank.

To configure the data source using IBM Cognos Analytics, complete the following steps:

  1. Open Cognos Analytics using web browser.
    For example, use URL http://<taddmvm180.taddmlab.com>:9300/bi in the web browser to open the Cognos Analytics.
  2. Click Manage Icon Manage icon on the left-side navigation panel and select Administration Console...

    The IBM Cognos Administration page is displayed.

  3. Open Cognos Analytics using web browser. For example, use URL http://<taddmvm180.taddmlab.com>:9300/bi
  4. Click the Configuration tab.
  5. Click the New Data Source icon.
    The New Data Source wizard is displayed.
  6. In the Name field, type CMDBTCR.
    The name CMDBTCR is referenced in the data model so you must give the new data source the same name. Click Next.
  7. From the Type menu, select the type of database you are using.
  8. Unselect Configure JDBC connection and click Next.
  9. Complete one of the following steps:
    • If your database type is DB2, in the DB2 database name field, type the TADDM database name or the alias of the cataloged TADDM database.
    • If your database type is Oracle, in the SQL*Net connect string field, type the service name of the Oracle database, for example, ORCL. You specified the Oracle database service name when configuring the Oracle Database Client. You can check the Oracle database service name in the %TNS_ADMIN%/tnsnames.ora file. Search for the following string: 
      SERVICE_NAME =
  10. In the Signon section, specify the database user name and password.
  11. To test the database connection, click Test the connection and then click Test.
    In the View the Results page of the New Data Source wizard, the status of the test is displayed. Click Close twice to close the testing results page and test page.
  12. Click Finish.