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?
- Obtain the necessary JDBC driver software for each database from the database vendor.
- Save the jdbc driver (.jar) files to your system.
- 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)
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 -
"com.ibm.db2.jcc.DB2Driver"
This is all it says. Please advise!
Thank you so much!
Hello,
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.
Thanks,
Sonet
Thank you Sonet. I resolved the error by adding the path to the jar files in the environment variables.
This is great. Does this configuration work for other connectivity types such as ODBC and OLEDB?