The following article shows how to use the Xtract BW Loader component with an InfoPackage to load data into InfoObject Texts.

Tip: Xtract BWLoader can load data to InfoPackages that can be forwarded to other SAP BW objects like InfoObject attributes, hierarchies or InfoCubes.

Creating an InfoObject #

In the depicted example an InfoObject ZCUSTOMER.
If you have already an InfoObject, skip to Setup in SAP.

  1. Create an InfoObject using transaction RSA1.
    data-into-a-bw_01
  2. Set a name, e.g.s ZCUSTOMER.
    data-into-a-bw_02
  3. Set data type and length.
    data-into-a-bw_03
  4. On the Master data/texts tab select the following options.
    data-into-a-bw_04

Setup in SAP #

RFC Destination

Create an RFC Destination (XTRACT 01) using transaction SM59.
data-into-a-bw_05

InfoSource

  1. Create an InfoSource 3.x.
    data-into-a-bw_06
  2. Select the option [Direct Update of Master Data] and select the InfoObject ZCUSTOMER.
    data-into-a-bw_07
  3. Create the transfer rules for ZCUSTOMER.
    data-into-a-bw_09
  4. Select the Source System XTRACT01. data-into-a-bw_10
  5. Click [Save].
    data-into-a-bw_11

InfoPackage

  1. Create an InfoPackage.
    data-into-a-bw_13
  2. Enter the description, select the Destination and click [Save]. data-into-a-bw_14
  3. In the tab “Schedule”, select [Start later in Background] and click [Scheduling options] > [immediate]. data-into-a-bw_15
  4. Click [Save].
    data-into-a-bw_16

Setup in SSIS #

  1. Create a data flow task and define an SAP connection.
  2. Optional: add an OLE DB Source for the SQL table to the workflow. The following SQL table is used as input for the InfoObject:
    data-into-a-bw_17 data-into-a-bw_18
  3. Add an Xtract BW Loader component to the workflow.
    data-into-a-bw_19
  4. Look up InfoObject ZCUSTOMER.
    data-into-a-bw_20
  5. Map pipeline elements to the InfoObject fields.
    data-into-a-bw_21
  6. Execute the data flow in SSIS.
    data-into-a-bw_22
  7. Check the log in SAP.
    data-into-a-bw_23
  8. Check the content of the InfoObject ZCUSTOMER.
    data-into-a-bw_24