IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using Oracle

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Step 3: Configure communications between the Tivoli Enterprise Portal Server and the data warehouse

Complete the tasks described in the following table, in the order listed, to configure communications between the portal server and the data warehouse.


Tasks for configuring communications between the portal server and an Oracle data warehouse

Task Procedure
(Portal server on Windows only)

Install an Oracle database client on the portal server.

See the Oracle documentation for instructions on how to install an Oracle client.
(Portal server on Windows only)

Create a TNS (Transparent Network Substrate) Service Name on the portal server.

Create a TNS Service Name
(Portal server on Linux or AIX only)

Install an Oracle JDBC Type 4 driver on the portal server.


The Oracle JDBC driver JAR file name and location after installation is as follows:oracleinstalldir/jdbc/lib/ojdbc14.jar

The ojdbc14.jar file supports JRE 1.5 or higher, the required Java Runtime Environment for IBM Tivoli Monitoring.

Configure the portal server to connect to the data warehouse.

The configuration procedure on Windows automatically configures an ODBC connection to the data warehouse.

For a portal server on Windows, see Configure a Windows portal server (ODBC connection).

For a portal server on Linux or AIX, see Configure a Linux or AIX portal server (JDBC connection).

Restart the portal server. Start the portal server
Test the connection between the portal server and the Tivoli Data Warehouse by creating a customized query in the Tivoli Enterprise Portal. Test the connection between the portal server and the Tivoli Data Warehouse


Parent topic:

Tivoli Data Warehouse solution using Oracle

+

Search Tips   |   Advanced Search