• Article

SAP BI Destination

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

This destination has one input and one error output.

Important

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

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

  • Prepare the SAP NetWeaver BI objects
  • Connect to the SAP NetWeaver BI system
  • Configure the SAP BI destination

Preparing the SAP NetWeaver BI Objects That the Destination Requires

The SAP BI destination requires that certain objects are in the SAP NetWeaver BI 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 BI system.

Note

For additional details about these objects and these configuration steps, see the SAP NetWeaver BI 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 BI destination.

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

Connecting to the SAP NetWeaver BI System

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

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

Configuring the SAP BI Destination

You can configure the SAP BI 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 BI system.
  • Choose not to trigger the InfoPackage, but to wait for notification that the SAP NetWeaver BI system has started the loading of data.
  • Optionally, trigger another process chain after the loading of data is completed.
  • Optionally, create the SAP NetWeaver BI 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 BI connection manager that the destination will use. For more information about how to configure the SAP BI connection manager, see SAP BI 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 BI 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 BI.

Using the SSIS Designer to Configure the Destination

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

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