Integration and Installation
Use
To be able to use OLD DB for OLAP with SAP Business Warehouse, you need to install the required front end components and prepare the connection to the BW server via OLE DB for OLAP.
Integration
The main components in the implementation of SAP Business Warehouse OLE DB for OLAP Providers are as follows:
- SAP BW OLE DB for OLAP providers between the data provider and the third-party client as the data consumer. The OLE DB for OLAP Providers maintains and modifies data displayed by the data provider.
- OLAP-BAPIs
The graphic below shows the arrangement of components:
The SAP Business Warehouse OLE DB for OLAP setup installs a provider DLL (dynamically linked library) on the desktop on which the third-party client application is installed. This DLL is registered under the name MdrmSap in the system registry. The provider DLL uses RFC to set up a connection between the BW server and multiple function module APIs.
Prerequisites
Note that all components that are integrated on the SAP BW OLE DB for OLAP Providers and which are required by the client application must be installed by the third party application itself.
Features
To access a BW system using OLE DB for OLAP, you need to install a SAP GUI (including the SAP BEx Suite). The SAP GUI setup contains components required by the SAP BW OLE DB for OLAP Providers.
Activities
Installing SAP GUI front end setup components
Install the following components on your desktop PC:
| Component | Description |
|---|---|
|
Mdrmsap.dll |
SAP BW OLE DB for OLAP provider DLL |
|
Mdrmdlg.dll |
Service DLL to create a connection to the SAP server. |
|
Scerrlkp.dll |
Error handling DLL |
|
Mdxpars.dll |
MDX parser DLL |
|
Librfc32.dll |
SAP RFC library |
|
Wdtlog.ocx |
SAP RFC logon dialog |
|
Saplogon.ini |
SAP connection parameter file |
The SAP BW OLE DB for OLAP Providers is registered under the progID (program ID) MDrmSAP.
Establishing a connection to the BW server using OLE DB for OLAP Drivers
Set the following parameters:
| Parameter | Description |
|---|---|
|
Provider |
Technical name that the SAP components are installed under: MDrmSAP. |
|
DataSource |
System name. This name must concur with the name in the SAP logon. |
|
UserID |
User name in system |
|
Password |
User password in system |
|
SFC_CLIENT |
Number of productive client in the BW server system |
|
SFC_LANGUAGE |
Logon language |