Fix Pack 9

Installing and configuring the database client

If you have installed IBM® Cognos® Analytics on a computer other than the TADDM database server, you must install a database client to connect to the database. You can use either a DB2® or Oracle database client, depending on the TADDM database type. If you have installed IBM Cognos Analytics on the same server as the TADDM database, you do not need to install a database client.

To install and configure the database client, complete the following steps:

Complete one of the following tasks:
  • If you want to use the DB2 database client, complete the following steps:
    1. Install the DB2 client on the machine on which IBM Cognos Analytics is installed, using the default options presented.
    2. Ensure that the TADDM database has been cataloged. This step is necessary for IBM Cognos Analytics to successfully connect to the DB2 server, using the DB2 client.
  • If you want to use the Oracle database client, complete the following steps to install and configure it using the Oracle Universal Installer wizard and the Oracle Net Configuration Assistant wizard:
    Note: Install the Oracle 32-bit Client to run the reports and create data-source using CQM (compatible query mode) option in IBM Cognos Analytics.
    1. In the Select Installation Type page of the Oracle Universal Installer wizard, select Administrator as the installation mode.
    2. In the Specify Home Details page, specify the name of the installation and the path to the location to where you want to install the product.
    3. In the Product-Specific Prerequisite Checks page, ensure that each of the requirements for installation and configuration are met. Do not continue with the installation until each check has a status of Succeeded.
    4. In the Welcome page of the Oracle Net Configuration Assistant wizard, ensure that the Perform typical configuration check box is not selected.
    5. In the Naming Methods Configuration, Select Naming Method page, set Local Naming as the naming method.
    6. In the Net Service Name Configuration, Service Name page, type the service name of your remote Oracle database server, for example, ORCL.
    7. In the Net Service Name Configuration, Select Protocols page, select TCP as the protocol to use to connect to the database.
    8. In the Net Service Name Configuration, TCP/IP Protocol page, type the host name of the computer on which the database is running. Select Use the standard port number of 1521.
    9. In the Net Service Name Configuration, Test page, select Yes, perform a test.
      If your database user name and password are correct, the following text is displayed: 
      Connecting... Test successful.

      If a successful connection to the database is not made, you might need to change your login credentials. To change the database login credentials click Change Login and specify a valid database user name and password.

    10. In the Net Service Name Configuration, Net Service Name page, accept the default service name, which should be the service name you specified earlier.
    11. Create a Windows system variable called TNS_ADMIN and set the value to the full path of the folder containing the tnsnames.ora file. During installation the tnsnames.ora file is created in the %ORACLE_HOME%/client_1/NETWORK/ADMIN folder, for example C:/oracle/product/10.2.0/client_1/NETWORK/ADMIN.
    12. Reboot the computer to ensure that the new system variable is available.