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

  1. Download the ojdbc14.jar file from the following URL: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html 

    Note

    This is absolute URL to third-party website. In case, this URL is not up-to-date, search the website for the JAR file.

  2. 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).
  3. 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).
    1. 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
                      &lt;ClassPath&gt;
                          &lt;Path&gt;your jar or class files directory&lt;/Path&gt;
                      &lt;/ClassPath&gt;
                       -->

                      ...
                 </JDBCDriver>
                  ...
      </DataBase>
    2. 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.

  4. Save and close the file.
  5. Restart the reporting server, which will also restart the BusinessObjects BI services (see Restarting-the-BusinessObjects-services).

Where to go from here

Setting-up-the-application-server

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*