If you are using Oracle OCI, DB2 OLAP Integration Server requires that the Oracle client software must be 32-bit. Oracle 32-bit client software and the server component of DB2 OLAP Integration Server must be installed on the same computer. When using OCI direct connection, the database client software is required to make connections to RDBMS databases. For information about installing and configuring database client software, refer to the Oracle RDBMS installation documentation.
On Windows systems, environment changes needed for running the database client software should be completed automatically by the Oracle 32-bit client installation program. For information about additional configuration of the database client software, see the Oracle documentation.
On UNIX systems, you must manually configure environment variables to access database client software and libraries. The variable settings must be defined for the environment of the user account (for example, hyperion) that you use to run the server. For information on setting the UNIX environment to access a database client, see Updating the environment for the database client.
To test OCI connections, make sure that you can connect to RDBMS databases and access tables while logged on with the user account that you use to run Integration Server. Use the SQL command line utility provided with the Oracle 32-bit database client software that you are using.
With Oracle OCI, you connect to the OLAP Metadata Catalog database and Data Source database at login time in Integration Services Console. You make the connection by typing Oracle: before the data source name for the OLAP Metadata Catalog database and the data source name for the relational database. This process is described in Connecting to Integration Server and Connecting to data sources.