IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using Oracle > Step 5: Install and configure communications for Tivoli Performance Analyzer

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


Configure an ODBC data source for an Oracle data warehouse

An Oracle client on Windows requires an ODBC connection to the data warehouse. For the Tivoli Performance Analyzer, you must configure the ODBC connection manually.

This procedure uses default values for the data source name (ITM Warehouse), and warehouse user ID (ITMUser). (Default values are used in configuration procedures for warehousing components.) Substitute different values if you do not want to use the default values.


Complete the following procedure to set up an ODBC connection for a Tivoli Performance Analyzer on Windows to a local or remote Tivoli Data Warehouse.

  1. On the computer where the Tivoli Performance Analyzer is installed, open the Control Panel.

  2. Click Administrative Tools → Data Sources (ODBC)

  3. Click Add in the System DSN tab in the ODBC Data Source Administrator window.

  4. Select the Oracle ODBC driver:

    • For Oracle 9, the ODBC driver name is Oracle in Ora9ias_home.

    • For Oracle 10, the ODBC driver name is Oracle in OraDb10g_home1.

  5. Enter ITM Warehouse in the Data Source Name field.

  6. Enter the TNS Service Name in the TNS Service Name field. This is the name that you specified in Step 8 (for example, WAREHOUS).

  7. Enter ITMUser in the User ID field.

  8. Click Test Connection.

  9. In the Oracle ODBC Driver Connect window, enter the TNS Service Name, and the user ID and password of the warehouse user.

  10. Click OK on the Connection successful message.


Parent topic:

Step 5: Install and configure communications for Tivoli Performance Analyzer

+

Search Tips   |   Advanced Search