Connecting to the Tivoli Data Warehouse using the database client over ODBC

Cognos® uses ODBC to connect to the database. It is important to first install a database client on the Tivoli® Common Reporting server and have it connect to the Tivoli Data Warehouse. If your database and the Tivoli Common Reporting server are on the same computer, no database client is needed.

• IBM® DB2®
  1. Make sure you have deployed a DB2 database client on the computer where the Cognos-based Tivoli Common Reporting engine is installed. The client should be of the same version as the database that the Tivoli Data Warehouse is using.
     If a DB2 server is installed where the Cognos-based Tivoli Common Reporting engine is installed, the DB2 client files are already available. However, you will need to copy the DB2 library file (libdb2.a) to the Cognos_8_Install_dir/bin directory to allow Cognos to successfully connect to the database server where the Tivoli Data Warehouse resides.
  2. Connect the DB2 database client to the database server by running the DB2 Configuration Assistant, configuring the local net service name configuration, and restarting your system.
  3. Note the name of the connection you have created because it is used in Tivoli Common Reporting by the report installer.
• Microsoft SQL Server
  1. Make sure you have deployed the MS SQL database client on the computer where the Cognos-based Tivoli Common Reporting engine is installed.
  2. Connect the MS SQL client to the database server by running the MS SQL Management Studio Express, configuring the local net service name configuration, and restarting your system.
  3. Note the name of the connection you have created because it is used in Tivoli Common Reporting by the report installer.
• Oracle
  1. Make sure you have deployed the Oracle database client on the computer where the Cognos-based Tivoli Common Reporting engine is installed.
  2. Connect the Oracle database client to the database server by running the Oracle Net Configuration Assistant, configuring the local net service name configuration, and restarting your system.
  3. Note the name of the connection you have created because it is used in Tivoli Common Reporting by the report installer.