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).
Set a name (e.g. ZCUSTOMER).
Set data type and length.
On the Master data/texts tab select the following options.
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).
Step 2: Create an InfoSource 3.x
Create an InfoSource 3.x (for more information refer to SAP help).
Set the option [Direct Update of Master Data] und select the InfoObject ZCUSTOMER.
Confirm the message.
Step 3: Create Transfer Rules
Now create the transfer rules (for more information refer to SAP help).
Select the Source System XTRACT01.
Confirm the message.
Click on the [Save] button.
Step 4: Create an InfoPackage
Create an InfoPackage.
Set the description, select the Destination and click on [Save].
On the tab “Schedule”, select [Start later in Background], click on [Scheduling options], then on [immediate] and on the [Save] button.
Save the InfoPackage.
Step 5: Use Xtract BW Loader component
As a source an SQL table with two columns is used defined as the following:
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.
Define the BW Loader component and map pipeline elements to the InfoObject fields.
Execute the data flow in SSIS.
Check the log in SAP.
Check the content of the InfoObject ZCUSTOMER.
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.