Configuring a JDBC driver

To configure Oracle database using a JDBC driver

1. Copy the ojdbc5.jar from Reports\Util\DatabaseDrivers to any temporary location. For example, D:\OracleDriver on the SAP BusinessObjects computer.
2. For SAP BusinessObjects Platform 4.0 SP4.
   • To set up the Connection Server to allow access to other databases on Windows, copy the database drivers to installationDirectory\SAP BusinessObjectsEnterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\oracle
     • For the Oracle Database, copy the ojdbc5.jar file to installationDirectory\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\oracle
   • To set up the Connection Server to allow for other database access on Unix, copy your database drivers to installationDirectory\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc\drivers\oracle

     • For the Oracle Database, copy the ojdbc5.jar file to installationDirectory\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc\drivers\oracle

       You must create a directory named oracle in the directory heirarchy under drivers.
       If you have Business Intelligence 4.0 Server component and Client tool components on separate computers, you must copy the ojdbc5.jar file on both computers.

3. For SAP BusinessObjects Enterprise XI 3.1 SP3.

   1. Edit the jdbc.sbo file located at installationDirectory\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc and enter the path of the jar file:

      <DataBase Active="Yes" Name="Oracle 11">
      <ClassJARFile="dbd_jdbc,dbd_oracle">com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
      <JDBCDriver>
      <!--  Uncomment and edit the following lines to define java classes required by JDBC driver -->
      <ClassPath>
         <Path> d:\OracleDriver\ojdbc5.jar </Path>
      </ClassPath>
      <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
      <Parameter Name="URL Format">jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
      </JDBCDriver>
      

   2. Save the file.

      If you have BusinessObjects 3.1 Server component and Client tool components on separate computers, you must edit the jdbc.sbo file on both computers.

4. Log into BMC ProactiveNet Central Monitoring console and select CMC Home from the list.
5. Click the Servers link to see available servers with details.
6. Restart connection server: <hostname>.Connectionserver.
7. Create the JDBC Connection
   1. For SAP BusinessObjects Enterprise XI 3.1 SP3, use the Designer tool.
   2. For SAP BusinessObjects Platform 4.0 SP4, use the Universe Design tool.