Microsoft Connector for SAP BW

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

The Microsoft Connector for SAP BW consists of a set of three components that let you extract data from, or load data into, an SAP Netweaver BW version 7 system.

The Microsoft Connector for SAP BW for SQL Server 2016 is a component of the SQL Server 2016 Feature Pack. To install the Connector for SAP BW and its documentation, download and run the installer from the SQL Server 2016 Feature Pack web page.

Important

Microsoft does not anticipate providing an updated version of the Connector for SAP BW. Microsoft does not own the source code for the SAP BW components, which were developed by a third party, and as a result cannot update them. Consider purchasing the latest SAP connectivity components from a Microsoft ISV partner such as Theobald Software. Microsoft's ISV partners have adapted their SAP connectivity components for SSIS for installation in Azure.

Important

The documentation for the Microsoft Connector for SAP BW assumes familiarity with the SAP Netweaver BW environment. For more information about SAP Netweaver BW, or for information about how to configure SAP Netweaver BW objects and processes, see your SAP documentation.

Important

Extracting data from SAP Netweaver BW requires additional SAP licensing. Check with SAP to verify these requirements.

Components

The Microsoft Connector for SAP BW has the following components:

  • SAP BW Source-The SAP BW source is a data flow source component that lets you extract data from an SAP Netweaver BW version 7 system.

  • SAP BW Destination-The SAP BW destination is a data flow destination component that lets you load data into an SAP Netweaver BW version 7 system.

  • SAP BW Connection Manager-The SAP BW connection manager connects either an SAP BW source or SAP BW destination to an SAP Netweaver BW version 7 system.

For a walkthrough that demonstrates how to configure and use the SAP BW connection manager, source, and destination, see the white paper, Using SQL Server Integration Services with SAP BI 7.0. This white paper also shows how to configure the required objects in SAP BW.

Documentation

This Help file for the Microsoft Connector for SAP BW contains the following topics and sections:

Installing the Microsoft Connector for SAP BW
Describes the installation requirements for the Microsoft Connector for SAP BW.

Microsoft Connector for SAP BW Components
Describes each component of the Microsoft Connector for SAP BW.

Microsoft Connector for SAP BW F1 Help
Describes the user interface of each component of the Microsoft Connector for SAP BW.