Edit

SAP BW Destination

  • Article

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

The SAP BW destination is the destination component of the Microsoft Connector 1.1 for SAP BW. Thus, the SAP BW destination loads data from the data flow in an Integration Services package into an SAP Netweaver BW version 7 system.

This destination has one input and one error output.

Important

The documentation for the Microsoft Connector 1.1 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.

To use the SAP BW destination, you have to do the following tasks:

Preparing the SAP Netweaver BW Objects That the Destination Requires

The SAP BW destination requires that certain objects are in the SAP Netweaver BW system before the destination can function. If these objects do not already exist, you have to follow these steps to create and configure these objects in the SAP Netweaver BW system.

Note

For additional details about these objects and these configuration steps, see the SAP Netweaver BW documentation.

  1. Create a new Source System:

    1. Select the type, "Third Party/Staging BAPIs".

    2. For Communication Type with Target System, select Non-Unicode (Inactive MDMP Settings).

    3. Assign an appropriate Program ID.

  2. Assign the Source System to an InfoSource.

  3. Create an InfoPackage.

    The InfoPackage is the most important object that is required by the SAP BW destination.

You can also create additional InfoObjects, InfoCubes, InfoSources, and InfoPackages that are required to support loading data into the SAP Netweaver BW system.

Connecting to the SAP Netweaver BW System

To connect to the SAP Netweaver BW version 7 system, the SAP BW destination uses the SAP BW connection manager that is part of the Microsoft Connector 1.1 for SAP BW package. The SAP BW connection manager is the only Integration Services connection manager that the SAP BW destination can use.

For more information about the SAP BW connection manager, see SAP BW Connection Manager.

Configuring the SAP BW Destination

You can configure the SAP BW destination in the following ways:

  • Look up and select the InfoPackage to use to load data.

  • Map each column in the data flow to the appropriate InfoObject in the InfoPackage.

  • Specify how many rows of data will be transferred at a time by configuring the PackageSize property.

  • Choose to wait until the loading of data is completed by the SAP Netweaver BW system.

  • Choose not to trigger the InfoPackage, but to wait for notification that the SAP Netweaver BW system has started the loading of data.

  • Optionally, trigger another process chain after the loading of data is completed.

  • Optionally, create the SAP Netweaver BW objects that are required by the destination. This includes creating InfoObjects, InfoCubes, InfoSources, and InfoPackages.

  • Test the loading of data with the options that you have selected.

You can also enable logging of RFC function calls by the destination. (This logging is separate from the optional logging that you can enable on Integration Services packages.) You enable logging of RFC function calls when you configure the SAP BW connection manager that the destination will use. For more information about how to configure the SAP BW connection manager, see SAP BW Connection Manager.

If you do not know all the values that are required to configure the destination, you might have to ask your SAP administrator.

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 2008 Integration Services with SAP BI 7.0. This white paper also shows how to configure the required objects in SAP BW.

Using the SSIS Designer to Configure the Destination

For more information about the properties of the SAP BW destination that you can set in SSIS Designer, click one of the following topics:

While you are configuring the SAP BW destination, you can also use various dialog boxes to look up or to create SAP Netweaver BW objects. For more information about these dialog boxes, click one of the following topics:

See Also

Microsoft Connector for SAP BW Components