How to load data into a BW Infoobject with Xtract BW Loader

Content #

Xtract BW Loader is one out of the ten components of Xtract IS, the SAP Connector for the SQL Server Integration Services (SSIS) by Theobald Software.

BW Loader allows to load data to SAP BW objects using an InfoPackage (refer to SAP help to know more about InfoPackages).

In this article it is demonstrated how to use BW Loader in conjunction with an Infopackage to load data into InfoObject Texts.
You can use BW Loader in conjunction with other Infopackages too, to load data to other BW objects, like InfoObject attributes, hierarchies or InfoCubes.

In this scenario the InfoObject ZCUSTOMER is created with the following settings. If you have already an InfoObject you can skip to STEP 1: Create an RFC Destination.

InfoObject Creation #

Create an InfoObject (using transaction code RSA1). data-into-a-bw_01

Set a name (e.g. ZCUSTOMER). data-into-a-bw_02

Set data type and length. data-into-a-bw_03

On the Master data/texts tab select the following options. data-into-a-bw_04

Step-by-step explanation #

Step 1: Create an RFC Destination

Create an RFC Destination XTRACT 01 using the transaction code SM59 (for more information refer to SAP help). data-into-a-bw_05

Step 2: Create an InfoSource 3.x
Create an InfoSource 3.x (for more information refer to SAP help). data-into-a-bw_06

Set the option [Direct Update of Master Data] und select the InfoObject ZCUSTOMER. data-into-a-bw_07

Confirm the message. data-into-a-bw_08

Step 3: Create Transfer Rules

Now create the transfer rules (for more information refer to SAP help). data-into-a-bw_09

Select the Source System XTRACT01. data-into-a-bw_10

Confirm the message. data-into-a-bw_11

Click on the [Save] button. data-into-a-bw_12

Step 4: Create an InfoPackage

Create an InfoPackage. data-into-a-bw_13

Set the description, select the Destination and click on [Save]. data-into-a-bw_14

On the tab “Schedule”, select [Start later in Background], click on [Scheduling options], then on [immediate] and on the [Save] button. data-into-a-bw_15

Save the InfoPackage. data-into-a-bw_16

Step 5: Use Xtract BW Loader component
As a source an SQL table with two columns is used defined as the following: data-into-a-bw_17 data-into-a-bw_18

In SSIS create a data flow task, define the connections to the SQL database and to SAP, and add two components: an OLE DB Source for the SQL table and Xtract BW Loader. data-into-a-bw_19

Define the BW Loader component and map pipeline elements to the InfoObject fields. data-into-a-bw_20 data-into-a-bw_21

Execute the data flow in SSIS. data-into-a-bw_22

Check the log in SAP. data-into-a-bw_23

Check the content of the InfoObject ZCUSTOMER. data-into-a-bw_24

In this article it was demonstrated how to use Xtract BW Loader to load data from an SQL table into SAP BW InfoObject Texts. SSIS allows to use other Sources (e.g. FlatFiles).
BWLoader can load data to Infopackages that can be forwarded to other SAP BW objects like InfoObject attributes, hierarchies or InfoCubes.