Configuring Oracle client

The Oracle client can be configured to establish connectivity between the Database and SAP Business Intelligence 4.0 SP4 Server or SAP BusinessObjects XI 3.1 SP3, depending on your installation.

Configuring connectivity to a SAP Business Intelligence 4.0 SP4 Server

Configuring Oracle client helps establish connectivity between the Database and SAP Business Intelligence 4.0 SP4 Server. Before configuring the Oracle client, install the Oracle Database client (64 bit) on the computer on which you have installed SAP Business Intelligence 4.0 SP4 Server.

• Business Intelligence 4.0 SP4 server components are 64 bit, hence a 64 bit Oracle Database Client installation is required on the same server.
• Business Intelligence 4.0 SP4 Client Tools components are 32 bit, hence a 32 bit Oracle Database Client installation is required on the same server.

• If you have both Business Intelligence 4.0 Server component and Client tool components on the same computer, then you must install both 32 bit and 64 bit Oracle Database Clients on the same computer. 

  Warning

  Note

  You can also establish the connectivity between the database and SAP BusinessObjects Enterprise using other methods as per your organization's specifications.

Configuring connectivity to a SAP BusinessObjects XI 3.1 SP3 Server

Configuring Oracle client helps to establish connectivity between the database and SAP BusinessObjects Enterprise. Before configuring the Oracle client, install the Oracle Database client (32 bit) on the computer on which you have installed SAP BusinessObjects Enterprise.

If you have BusinessObjects 3.1 Server component and Client tool components on separate computers, then you must install the 32 bit Oracle Database Clients on both the computers.

To configure the Oracle client

1. On the computer on which you have installed the Oracle client, open the tnsnames.ora file located in the ORACLE_HOME\Network\Admin folder.

2. Add the following entry using the values that you populated in the Planning sheet for installation and configuration. 

   Warning

   Note

   If you have both 32 bit and 64 bit Oracle Database Clients on the same machine, you need to add entries in both the tnsnames.ora files.

   
   <addressName> =
     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(Host = <hostName>)(Port = <port>))
       )
       (CONNECT_DATA =
         (SERVICE_NAME = <sid>)
       )
     )
   
3. Save the file, and close it.