› Data sources › Define data sources › SAP BW database type

SAP BW database type

Insight allows you to select the SAP BW database type to use the SAP business intelligence solution. To use it, install the required front-end components and have the credentials to access the BW server through OLE DB for OLAP. Also, Insight supports ADOMD and Ws for OLAP SAP BW providers.

The Insight server must have the following drivers installed beforehand:

  • Business Explorer (SAP NetWeaver 7.X)

  • OLE DB for the OLAP and ADOMD providers (not required for the Ws for OLAP provider)

For the Ws for OLAP provider, Insight requests metadata for cubes, metrics, and dimensions via the web service. In this case the SSO token received during authentication is used. Also, the data for metric components is received via the web service using the SSO token. If the SSO token is still not received, no data can be passed even if the correct credentials are provided.

Authentication for ADOMD is passed with the help of the user name/password (no token is required).

Configure this data source as any other source, but for the Server Name, use the following template: http://<hostname.fqdn>:8000/sap/bw/xml/soap?sap-client=001, where you need to insert your host.

Enable SAP SSO authentication

The SSO token is used to receive data for the SAP BW metric based on the SAP BW data source with the Ws for OLAP provider.

To get the SSO token, you need to enable the SSO authentication. To achieve this, navigate to Program Files\Kofax\Insight X.X.X\HtmlInsight and find the Web.config file. Open the file and add the following property: <add key="SAPSSO2_URL" value="{sap_sso_url}"/>.

This authentication type is possible only with the Windows authentication for Insight. All data for the authorized windows user is sent to the web portal which returns the MYSAPSSO2 parameter with the token value in cookies.