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

[sonet_kebede]

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)

 

• 2521502 - How to configure JDBC connection using Extensions Parameter for Information Design Tool, U...


• 2531116 - How to setup JDBC driver in SAP BusinessObjects (the easiest way for all supported vendors...