Settings for Data Source Connections Using Native Gateways

Learn about the environment variable settings that you must configure for Oracle Database and DB2 using native gateways.

For Oracle Database:

  • The Oracle BI Server uses the Oracle Call Interface (OCI) to connect to the database. OCI is installed by default with Oracle BI EE. You must use the bundled version to connect.

  • In the tnsnames.ora file, the Oracle Database alias, the defined entry name, must match the Data Source Name used in the repository connection pools of all physical Oracle databases.

    When connecting to an Oracle Database data source, you can include the entire connect string, or you can use the net service name defined in the tnsnames.ora file. If you choose to enter only the net service name, you must set up a tnsnames.ora file in the following location within the Oracle BI EE environment, so that the Oracle BI Server can locate the entry:


  • Edit the file to set environment variables for the database client.

For DB2, you must do the following:

  • Install the appropriate database client on the computer running the Oracle BI Server, then edit the file to set environment variables for the database client.

  • For Windows, you can set environment variables for DB2 in the file. For example, if configuring DB2 CLI, then you must modify to include the DB2 executable path.

  • You need to create a catalog associated with each database so that the client connects to the database by catalog name. To create a catalog associated with each database, enter and run the following command:

    db2 catalog tcpip node <DB2 database> remote <hostname> server <port number>;
    db2 catalog database <DB2 database> as <DB2 database> at node <DB2 database>;
    connect to <DB2 database> user db2admin using welcome1

For an example, see Sample Entries for Oracle Database and DB2 (32-Bit).