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.

4 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) 
  2. Satish Soni

    How can we specify the Charset used for JDBC Connection.

     

    Is it to be specified somewhere in parameters or JDBC configuration in .sbo file under URL Format parameter.

    (0) 

Leave a Reply