Show TOC

Integration and InstallationLocate this document in the navigation structure

Use

To be able to use OLD DB for OLAP with SAP NetWeaver Business Warehouse, you need to install the required front end components and prepare the connection to the BW server via OLE DB for OLAP.

Note

This applies for the 32 bit client version with installation by SAP GUI. SAP also provides a 64 bit version. See SAP Note 1496637 for details.

Integration

The main components in the implementation of SAP NetWeaver Business Warehouse OLE DB for OLAP Providers are as follows:

  • SAP NetWeaver 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 NetWeaver 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 NetWeaver BW OLE DB for OLAP Providers and which are required by the client application must be installed by the third party application itself.

Note

It is usually necessary to install Microsoft's Redistribution Setups for Microsoft Data Access Components (MDAC) including the OLE DB and ODBC drivers. If not delivered with the client-specific software, you can find the required components at www.microsoft.com/data/download2.htm.

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 NetWeaver 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 NetWeaver 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 NetWeaver BW OLE DB for OLAP Providers is registered under the progID (program ID) MDrmSAP.

Caution

To install these components, you need administrator rights on the desktop PC.

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

Tip

A typical example of a provider string could be:

DataSource=JXX;UserID=MyName;Password=MyPassword;Provider=MDrmSAP;SFC_CLIENT=005;SFC_LANGUAGE=DE