Skip to Content
Author's profile photo Sonet Kebede

How to setup a JDBC driver using .sbo Extensions Parameter in SAP BusinessObjects server and client.

Why use the JDBC .sbo Extensions Parameter?

  • No more modifying the .sbo file.
  • Easiest and general way to distribute any supported driver
  • Used by the customers and developers
  • Big improvement from the older method
  • Easier to update the driver

How to create a JDBC connection using the .sbo Extensions Parameter for Information Design Tool, Universe Design Tool and Web intelligence?

  1. Obtain the necessary JDBC driver software for each database from the database vendor.
  2. Save the jdbc driver (.jar) files to your system.
  3. Place the jdbc jar files in the correct directory file path.

Let’s get started!

  • Navigate the jdbc folder under the installed directory:  <Installed Directory>:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\

  • Locate the corresponding database .sbo file.

  • For example, edit the db2.sbo with notepad and find the Extensions Parameter name: <Parameter Name=”Extensions”>db2v10_5,db2udb,db2,jdbc</Parameter>

  • Create a new folder using the Extensions Parameter name db2v10_5 or db2udb or db2 or jdbc under the <Installed Directory>:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers

Extensions Parameter name:

<Parameter Name=”Extensions”>db2v10_5,db2udb,db2,jdbc</Parameter>

  • Copy the jdbc driver (.jar) file from your system in the SAP BO Directory

<Installed Directory>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\ db2v10_5 or db2 or jdbc folder

  • Restart the Adaptive Processing Server which hosts the “Adaptive Connectivity Service” service.
  • Restart the Information Design Tool (IDT) or Universe Design Tool (UDT)
  • Now you are able to create a connection using the jdbc driver from Information Design Tool (IDT) or Universe Design Tool (UDT)


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Roopa Puranik
      Roopa Puranik

      Hello, Thanks for the this great article. I followed the steps you provided on my local machine. I created a relation connection in IDT and when I test the connection I get this error -


      This is all it says. Please advise!

      Thank you so much!

      Author's profile photo Sonet Kebede
      Sonet Kebede
      Blog Post Author


      Your JDBC requires you to have the java and native code.  So you need to install the DB2 client on the machine where the application (BO client ) that is making the JDBC calls runs.





      Author's profile photo Roopa Puranik
      Roopa Puranik

      Thank you Sonet. I resolved the error by adding the path to the jar files in the environment variables.

      Author's profile photo John Clark
      John Clark

      This is great.  Does this configuration work for other connectivity types such as ODBC and OLEDB?