Configuring the BusinessObjects server JDBC drivers
Configure the JDBC drivers to ensure that the BusinessObjects BI server has access to the BMC Decision Support – Database Automation data warehouse. This topic provides instructions for configuring the JDBC drivers.
To configure the JDBC drivers
Download the ojdbc14.jar file from the following URL: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html
- Copy the JAR file to the BusinessObjects Business Intelligence (BI) server’s hard drive (for example, you might copy it under D:\Program Files\SAP Business Objects).
- Locate and edit the Oracle.sbo file and modify the settings for each database type as follows (the file should be in the BusinessObjects BI installation directory, for example D:\Program Files (x86)\SAP Business Objects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc).
Find Oracle 11, locate the <JDBCDriver> tag. If the <classpath> tag does not exist in the <JDBCDriver> tag, go to step b. A sample file without the <classpath> tag looks like the following. If the tag already exists, change the path to the one where you have copied the ojdbc14.jar file.
<DataBase Active="Yes" Name="Oracle 11">
<JDBCDriver>
<!-- Uncomment and edit the following lines
to define java classes required by JDBC driver
<ClassPath>
<Path>your jar or class files directory</Path>
</ClassPath>
-->
...
</JDBCDriver>
...
</DataBase>Replace the content in the <JDBCDriver> tag with the following content, as follows:
<DataBase Active="Yes" Name="Oracle 11">
<JDBCDriver>
<ClassPath>
<Path>
D:\program files\Business Objects\ojdbc14.jar
</Path>
</ClassPath>
</JDBCDriver>
...
</DataBase>
D:\program files\Business Objects indicates the path where you have copied the ojdbc14.jar file.
- Save and close the file.
- Restart the reporting server, which will also restart the BusinessObjects BI services (see Restarting-the-BusinessObjects-services).
Where to go from here