Install Oracle Database Access Components

Note: This is an optional step. Oracle Database Access Components (ODAC) is only required if you are publishing to the Oracle Database.

Complete this procedure before you add and configure the Oracle database as a publish target.

1. Install the Oracle Database Access Components software on the computer where PI Integrator for Business Analytics is installed.

   Note: Check System requirements for the specific version of the ODAC software to install.

2. Locate the tnsnames.ora file in \ODAC_install_directory\Network\Admin\Sample.

3. Edit the tnsnames.ora file and add an entry for the Oracle database.

   The syntax is as follows:

   Net_Service_Name =
   (DESCRIPTION=
   (ADDRESS=(PROTOCOL=protocol_name)(HOST=Oracle_database_host_name)(PORT=port)
   (CONNECT_DATA=
   (SERVER=service_handler_type)
   (SERVICE_NAME=(TNS_listener_service_name)

   The Net_Service_Name is the alias for the SERVICE_NAME. When you configure the Oracle publish target, you can set the Data Source parameter to the Net_Service_Name. For more information on the tnsnames.ora file, refer to your Oracle documentation.

4. Move the tnsnames.ora file to the\ODAC_install_directory\Network\Admin directory.

5. Add the location of the ODAC software to the PATH environment variable.

6. Create the TNS_ADMIN system environment variable and point it to the directory where the tnsnames.ora file is located.

7. Continue with adding the Oracle database as a publish target. For more information, see Add a publish target.