Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Configuring SAP BusinessObjects for the OLEDB connection type

Follow the steps in this topic to perform a one-time file modification for the OLEDB connection type for the Universe Designer.

Note

  • The file and its location differ based on the SAP BusinessObjects version.
  • The steps are valid for all versions of Microsoft SQL Server.

For SAP BusinessObjects BI 4.0

  1. Navigate to the following SAP BusinessObjects installed directory:
    <installationDirectory>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oledb
  2. In the sqlsrv.sbo file, under <DataBase Active="Yes">, change the following parameters:
    • Provider CLSID — Change the value from SQLNCLI to SQLOLEDB.
    • Enumerator CLSID — Change the value from SQLNCLI Enumerator to SQLOLEDB Enumerator.
  3. Restart the Server Intelligence Agent (SIA) from the Central Configuration Manager.
  4. Log on to the Universe Designer and create the OLEDB type connection.

For SAP BusinessObjects BI 4.1

  1. Navigate to the following SAP BusinessObjects installed directory:
    <installationDirectory>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.1\dataAccess\connectionServer\oledb
  2. In the sqlsrv.sbo file, under <DataBase Active="Yes">, change the following parameters:
    • Provider CLSID — Change the value from SQLNCLI to SQLOLEDB.
    • Enumerator CLSID — Change the value from SQLNCLI Enumerator to SQLOLEDB Enumerator.
  3. Restart the Server Intelligence Agent (SIA) from the Central Configuration Manager.
  4. Log on to the Universe Designer and create the OLEDB type connection.

 

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