Skip to content

Xtract BW Loader

This page shows how to use the Xtract BWLoader component.
Unlike the other components, the Xtract BWLoader component is a data destination, not a data source.

Add an Xtract BW Loader Component

To add an Xtract BW Loader component to your SSIS package:

  1. Drag&drop the Xtract BW Loader component from the SSIS toolbox into your data flow task.
    New

  2. Double-click the component. A connection manager is automatically assigned to the component.

    Note

    If there are multiple connection managers, the window "Select Connection Manager" opens, see SAP Connection. Once a connection manager is selected, the main window of the component opens.

The main window of the component opens and you can start setting up your component.

Prerequisites

For the Xtract BWLoader component to deliver data correctly, an InfoPackage is required. Create the following InfoPackage in the SAP BW system:

  • Create a new source system of the type 3rd party / Staging BAPIs. The Xtract BWLoader component requires the program ID of the source.
    BWLoader-Configuration-01
    BWLoader-Configuration-02
  • When using a 3.x data flow, you can assign the source system to the InfoSource and create an InfoPackage.
  • When using a 7.x data flow, create a DataSource for the newly created 3rd party source system and create an InfoPackage. Xtract BWLoader loads data to the PSA of the DataSource.
    XIS_BWLoader_7.x_DS

For more information on how to create data imports in SAP BW, refer to the SAP Documentation.

Look up an InfoPackage

The Xtract IS lookup finds InfoPackages based on either 3.x or 7.x DataSources. To look up an InfoPackage, an InfoSource, or a Source System in SAP:

  1. In the main window of the component, click the search botton. The window “Look Up InfoPackage” opens.
    bwloader_main-window_add
  2. Look up the name of an InfoPackage, an Info Source or a Source System . Use wildcards (*) if needed.
    BWLoader-Configuration-10
  3. Click the search button. Search results are displayed.
  4. Select an item from the list and click [OK] to confirm.

The SAP objects is selected and the application returns to the main window.

Define the Xtract BWLoader Component

The BW Loader component offers the following settings for data loading:

  1. In the main window of the component enter values for the following fields or use the search button to look up available RFC Destinations:

    Input Field Description
    Gateway Host the network address of your BW system.
    Gateway Service usually "sapgwXX" (substitute XX with your system number).
    Program ID is the Program ID that is defined in the BW SourceSystem.

  2. Click [OK] to save your input.

  3. Pass input data to the input pipeline of the Xtract BWLoader component.
  4. Open the main window of the Xtract BWLoader component component.
  5. Map each element of the pipeline to one element of the transfer structure.
    bwloader-mapping
  6. Check the settings before running the SSIS package.
  7. Click [OK] to save your input.

The BW Loader component is configured and ready to run.

Load Data into SAP BW

There are two options on how data can be loaded into SAP BW:

  1. The InfoPackage that initiates the data load is triggered from SSIS.
  2. The InfoPackage is started from within SAP.

For the second scenario there are two options:

  • Option 1

    Set the setting No InfoPackage start (Only wait) to true. In this case the SSIS package must be started and running. Then you can start the InfoPackage in BW manually or by scheduler and the process in SSIS will continue.

  • Option 2

    Use the BI Notification Receiver. The BI Notification Receiver enables triggering multiple SSIS packages from BW without having to run the SSIS packages all the time. This application registers itself to BW as an external system and waits for notification.

Last update: June 9, 2026