2.4. Configure JDBC for SAP Business Objects on Microsoft Windows

Procedure 2.1. Configure JDBC Drivers for SAP BO and Create a Connection

1. Download and save the JDBC drivers for teh database to which you wish to connect.
2. Navigate to the directory in which BusinessObjects is installed.
3. Open the [Database_Name].sbo file in your text editor for the database with which you wish to connect. For instance, if you wish to connect to an Oracle database, open oracle.sbo.
4. Find these lines in the file:

   		 
   <ClassPath>
        <Path>$ROOT$/drivers/java/dbd_jdbcwrapper.jar</Path>
   </ClassPath>			
   			

5. Modify the code so that it looks like this:

   		 
   <ClassPath>
        <Path>$ROOT$/drivers/java/dbd_jdbcwrapper.jar</Path>
              <Path>C:\JDBCDrivers\ojdbc6.jar</Path>
   </ClassPath>			
   			

6. Save the file and exit.
7. Create a database connection in the Information Design Tool. Click New->Relational Connection and then give the connection a name and click Next.
8. Select the type of connection (JDBC Drivers) and click Next.
9. Enter your connection parameters and click Test.
10. If the test is successful, click Finish.