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
Supported components
This section illustrates the warehouse solution using Oracle for the warehouse database.
Figure 1 presents the options for a Tivoli Data Warehouse solution using Oracle for the warehouse database. The diagram summarizes the supported operating system platforms for the various warehousing components, the supported database products, and the connections between components. For more specific information about supported operating systems and database products, including product names and versions, see Hardware and software requirements.Figure 1. Tivoli Data Warehouse solution using Oracle
An asterisk (*) next to a database client indicates that you must manually install the client if it does not already exist.
In the following discussion, numbered product components correspond to the numbers on the diagram.
Tivoli Data Warehouse on Oracle
A Tivoli Data Warehouse database on Oracle can be installed on supported Windows, Linux, or any UNIX platform support by Oracle. Ensure that the Oracle listener is active in order to accept connections from an Oracle client or JDBC driver.
Warehouse Proxy Agent
A Warehouse Proxy Agent on Linux or AIX communicates with the warehouse database through a JDBC connection. Install an Oracle Type 4 JDBC driver on the computer where the Warehouse Proxy Agent is located. If the Tivoli Data Warehouse is located on a remote computer, create a TNS (Transparent Network Substrate) Service Name on the local computer where the Warehouse Proxy Agent is located.
A Warehouse Proxy Agent on Windows communicates with the warehouse database through an ODBC connection. The ODBC driver is included with the Oracle client. If the Tivoli Data Warehouse is located on a remote computer, install an Oracle client on the local computer where the Warehouse Proxy Agent is located. Also, create a TNS Service Name on the local computer.
Tivoli Enterprise Portal Server
A Tivoli Enterprise Portal Server on Windows communicates with an Oracle data warehouse through an Oracle database client using an ODBC connection. You must manually install the Oracle client on the portal server. The ODBC driver is included with the Oracle client.
A portal server on Linux or AIX communicates with the warehouse database through a JDBC connection. Install an Oracle Type 4 JDBC driver on the portal server.
Summarization and Pruning Agent
The Summarization and Pruning Agent communicates with the warehouse database through a JDBC connection from any supported operating system. Install an Oracle Type 4 JDBC driver on the computer where the Summarization and Pruning Agent is located.
Parent topic:
Tivoli Data Warehouse solution using Oracle