Configuring a JDBC driver

To configure Oracle database using a JDBC driver

1. Copy the ojdbc5.jar from \Util\DatabaseDrivers to any temporary location on your machine. For example, copy this jar file from 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

       Warning

       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. Log into SAP Business Objects Central Management Console.
4. Click the Servers link to see available servers with details.
5. Restart connection server: <hostname>.Connectionserver.
6. To create the JDBC Connection, use the Universe Design tool.