In this document, I will try to explain how to install JDBC drivers in BusinessObjects and how to create a connection.
- Update In Odi 12c Tables
- Odi 12c Download
- Oracle Odi 12c Tutorial Pdf
- Drivers Location In Odi 12c Tutorials Pdf
Oracle EPM/BI Hyperion Essbase, Planning, PBCS, HPCM, ODI, OBIEE, FDM, FDMEE, DRM and OBIA all at one place. Oracle product 11.1.1 Oracle_DI_1 oracledi agent drivers. Register the JD Edwards EnterpriseOne Data Access Driver by way of the Server Manager. And extracts the JD Edwards EnterpriseOne Data Access Driver jar.
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:
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.
Update In Odi 12c Tables
E:BusinessObjectsSAP BusinessObjects Enterprise XI 4.0dataAccessconnectionServerjdbc
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.
Step 3:
After you open the file in notepad. Find the tags below and insert line below stated in red.
Odi 12c Download
<ClassPath>
<Path>$ROOT$/drivers/java/dbd_jdbcwrapper.jar</Path>
<Path>C:JDBCDriversojdbc6.jar</Path>
</ClassPath>
Step 4:
Create a database connection in Information Design Tool.
- New > Relational Connection
- Give a connection name and click Next
- Select the type of connection and click Next
- Enter connection parameters as below and click “Test Connection” button.
Oracle Odi 12c Tutorial Pdf
- Click “Finish”
Drivers Location In Odi 12c Tutorials Pdf
For more information check Data Access Guide in the link below: