Skip to Content

In this document, I will try to explain how to install JDBC drivers in BusinessObjects and how to create a connection.

Step 1:

Download the jdbc drivers of the database you are trying to connect which could be Oracle, Teradata, MS SQL,and etc. In this case, I will be using Oracle JDBC drivers.

The link to download oracle drivers:

Oracle Database 11g Release 2 JDBC Driver Downloads</title><meta name="Title" content="Oracle Da…

Download the ojdbc6.jar file for this example and save it some place in your machine.

e.g. C:\JDBCDrivers

Step 2:

Go to the folder where BusinessObjects is installed.

E:\BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc

Under this folder find the oracle.sbo” file and open it with a text editor like notepad.

/wp-content/uploads/2013/12/5_336471.png

If it is desired to be connected to a database other than Oracle, then locate file with the name of the database with SBO extension like teradata.sbo.

Step 3:

After you open the file in notepad. Find the tags below and insert line below stated in red.

<ClassPath>

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

     <Path>C:\JDBCDrivers\ojdbc6.jar</Path>

</ClassPath>

/wp-content/uploads/2013/12/oracle_sbo_336406.png

Step 4:

Create a database connection in Information Design Tool.

  • New > Relational Connection
  • Give a connection name and click Next

/wp-content/uploads/2013/12/con_name_336445.png

  • Select the type of connection and click Next

/wp-content/uploads/2013/12/2_336456.png

  • Enter connection parameters as below and click “Test Connection” button.

/wp-content/uploads/2013/12/3_336461.png

/wp-content/uploads/2013/12/4_336469.png

  • Click “Finish”

For more information check Data Access Guide in the link below:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp2_data_acs_en.pdf

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Ray Khan

    Hi Zahid,

     

    I dont have dbd_jdbcwrapper.jar under my Java folder on my client PC. would you know where do i get it from to install manually ?

    (0) 

Leave a Reply