In this document, I will try to explain how to install JDBC drivers in BusinessObjects and how to create a connection.
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:
Download the ojdbc6.jar file for this example and save it some place in your machine.
e.g. C:\JDBCDrivers
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.
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.
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>
Create a database connection in Information Design Tool.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |