IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using Oracle > Step 2: Install and configure communications for the Warehouse Proxy Agent
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 Warehouse Proxy Agent, 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 Warehouse Proxy Agent on Windows to a local or remote Tivoli Data Warehouse.
- On the computer where the Warehouse Proxy Agent is installed, open the Control Panel.
- Click Administrative Tools → Data Sources (ODBC)
- Click Add in the System DSN tab in the ODBC Data Source Administrator window.
- 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.
- Enter ITM Warehouse in the Data Source Name field.
- Enter the TNS Service Name in the TNS Service Name field. This is the name that you specified in Step 8 (for example, WAREHOUS).
- Enter ITMUser in the User ID field.
- Click Test Connection.
- In the Oracle ODBC Driver Connect window, enter the TNS Service Name, and the user ID and password of the warehouse user.
- Click OK on the Connection successful message.
Parent topic:
Step 2: Install and configure communications for the Warehouse Proxy Agent