SAP BusinessObjects Enterprise

16.15.1. SAP BusinessObjects Enterprise

This section describes to setup database connections to various database systems for SAP BusinessObjects Enterprise.

Note: The SAP BusinessObjects Enterprise install directory is referred to as <install directory>.

Microsoft SQL Server #

Note: The newest possible version of Microsoft SQL Server JDBC Driver that can be used by SAP BusinessObjects Enterprise is 6.4 because JRE 7 support was dropped in version 7.0.

Download the Microsoft JDBC Driver Version 6.4 from: Release Notes for the JDBC Driver: 6.4.

  • Copy the Microsoft SQL Server JDBC Driver mssql-jdbc-6.4.0.jre7.jar into <install directory>/win32_x86/dataAccess/connectionServer/jdbc/drivers/mssql.
  • Open <install directory>/win32_x86/dataAccess/connectionServer/jdbc/jdbc.sbo in a text editor.
  • Configure the classpath to the MS SQL Server database configurations by adding the following ClassPath element as a child element to the JDBCDriver elements.
<ClassPath>
  <Path>$ROOT$/jdbc/drivers/mssql/mssql-jdbc-6.4.0.jre7.jar</Path>
</ClassPath>

Example MS SQL Server 2014 database configuration:

<DataBase Active="Yes" Name="MS SQL Server 2014">
  <Class JARFile="dbd_jdbc,dbd_mssql">com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
  <JDBCDriver>
    <ClassPath>
      <Path>$ROOT$/jdbc/drivers/mssql/mssql-jdbc-6.4.0.jre7.jar</Path>
    </ClassPath>
    <!-- Configuration is done for SQL Server 2014 JDBC Driver (4.0)  -->
    <Parameter Name="JDBC Class">com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
    <Parameter Name="URL Format">jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
  </JDBCDriver>
  <Parameter Name="Family">Microsoft</Parameter>
  <Parameter Name="Version">mssqlserver_jdbc.setup</Parameter>
  <Parameter Name="SQL External File">sqlsrv</Parameter>
  <Parameter Name="SQL Parameter File">sqlsrv</Parameter>
  <Parameter Name="Strategies File">sqlsrv</Parameter>
  <Parameter Name="Driver Capabilities">Query,Procedures</Parameter>
  <Parameter Name="Extensions">sqlsrv2014,sqlsrv,jdbc</Parameter>
  <Parameter Name="Array Fetch Size">10</Parameter>
  <Parameter Name="Force Execute">Always</Parameter>
  <Parameter Name="Quote Identifiers">False</Parameter>
</DataBase>

OLEDB connection from Client to SQL Server (2016 and higher) #

Microsoft have changed their drivers for OLEDB connections, So need to make some adjustments in the default sqlsrv.sbo file to work with latest Mircrosoft OLEDB drivers placed at <install directory>/dataAccess/connectionServer/oledb/sqlsrv.sbo. In the default sqlsrv.sbo file, value of parameters need to be changed Provider CLSID and Enumerator CLSID from default SQLNCLI11 to MSOLEDBSQL.

<Parameter Name="Provider CLSID">MSOLEDBSQL</Parameter>
<Parameter Name="Enumerator CLSID">MSOLEDBSQL Enumerator</Parameter>

Example customized sqlsrv.sbo file for MS SQL Server 2019:

<?xml version="1.0" encoding="UTF-8"?>
<DriverConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../sbo.xsd">
  <Defaults>
    <Parameter Name="Family">Microsoft</Parameter>
    <Parameter Name="SQL External File">sqlsrv</Parameter>
    <Parameter Name="SQL Parameter File">sqlsrv</Parameter>
    <Parameter Name="Description File">sqloledb</Parameter>
    <Parameter Name="Driver Capabilities">Query,Procedures</Parameter>
    <Parameter Name="Extensions">sqlsrv,oledb</Parameter>
    <Parameter Name="Array Fetch Available">True</Parameter>
    <Parameter Name="Array Bind Available">True</Parameter>
    <Parameter Name="Query TimeOut Available">True</Parameter>
    <Parameter Name="Max Rows Available">True</Parameter>
    <Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>
  </Defaults>
  <DataBases>
    <DataBase Active="Yes" Name="Generic OLEDB Provider">
      <Parameter Name="Provider CLSID">MSOLEDBSQL</Parameter>
      <Parameter Name="Enumerator CLSID">MMSOLEDBSQL Enumerator</Parameter>
      <Parameter Name="SSO Available">False</Parameter>
    </DataBase>
    <DataBase Active="Yes" Name="MS SQL Server 2019">
      <Library>dbd_wsqloledb</Library>
      <Parameter Name="Query TimeOut Available">No</Parameter>
      <Parameter Name="Family">Microsoft</Parameter>
      <Parameter Name="Version">mssqlserver_oledb.setup</Parameter>
      <Parameter Name="Driver Capabilities">Query,Procedures,Cancel</Parameter>
      <Parameter Name="SQL External File">sqlsrv</Parameter>
      <Parameter Name="SQL Parameter File">sqlsrv</Parameter>
      <Parameter Name="Description File">sqloledb</Parameter>
      <Parameter Name="Provider CLSID">MSOLEDBSQL</Parameter>
      <Parameter Name="Enumerator CLSID">MSOLEDBSQL Enumerator</Parameter>
      <Parameter Name="Extensions">sqlsrv2019,sqlsrv,oledb</Parameter>
      <Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>
    </DataBase>
  </DataBases>
</DriverConfiguration>

Oracle #

Download the Oracle JDBC Driver from: Oracle Database 12.1.0.1 JDBC Driver & UCP Downloads.

  • Copy the Oracle JDBC Driver ojdbc6.jar into <install directory>/win32_x86/dataAccess/connectionServer/jdbc/drivers/oracle.
  • Open <install directory>/win32_x86/dataAccess/connectionServer/jdbc/jdbc.sbo in a text editor.
  • Configure the classpath to the Oracle database configurations by adding the following ClassPath element as a child element to the JDBCDriver elements:
<ClassPath>
  <Path>$ROOT$/jdbc/drivers/oracle/ojdbc6.jar</Path>
</ClassPath>

Example Oracle 12 database configuration:

<DataBase Active="Yes" Name="Oracle 12">
  <Class JARFile="dbd_jdbc,dbd_oracle">com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
  <JDBCDriver>
    <ClassPath>
      <Path>$ROOT$/jdbc/drivers/oracle/ojdbc6.jar</Path>
    </ClassPath>
    <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
    <Parameter Name="URL Format">jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
  </JDBCDriver>
  <Parameter Name="Family">Oracle</Parameter>
  <Parameter Name="Version">oracle_jdbc.setup</Parameter>
  <Parameter Name="Description File">oracle</Parameter>
  <Parameter Name="SQL External File">oracle</Parameter>
  <Parameter Name="SQL Parameter File">oracle</Parameter>
  <Parameter Name="Strategies File">oracle</Parameter>
  <Parameter Name="Driver Capabilities">Query,Procedures</Parameter>
  <Parameter Name="Extensions">oracle12,oracle,jdbc</Parameter>
  <Parameter Name="Escape Character">/</Parameter>
  <Parameter Name="Force Execute">Always</Parameter>
  <Parameter Name="Catalog Separator">.</Parameter>
</DataBase>