Show TOC

Creating InfoPackages for Data Transfer with SAP Data ServicesLocate this document in the navigation structure

Procedure

You are in the DataSource tree for the Data Services source system in the Data Warehousing Workbench.

  1. In the context menu for the DataSource, choose Create InfoPackage.

  2. In the next screen, enter a description for the source system and choose Save.

    The InfoPackage maintenance screen appears.

  3. Enter any relevant selections in the Data Selection tab page (for fields that have been flagged as selectable in the DataSource).

    The InfoPackage selections are included in the Data Services data flow.

  4. Go to the 3rd Party Selections tab page.

    1. Choose Refresh. The system uses the information from the source system definition and the InfoPackage ID to fill the following parameters:

      • Repository

      • Job Server

      • Job Name

      To prevent transport problems, the job name takes the InfoPackage ID and the logical BW system name as well.

    2. Specify the number of connections (given in Data Services Loader).

  5. Go to the Update tab page and select the update mode.

  6. Save the InfoPackage.

Result

The job and the data flow are created and validated in the Data Services system. Under Batch Jobs in SAP Data Services Designer, the job is displayed with the name <InfoPackage>@<BW System> together with the data flow with the same name (click on the job).

The data flow contains the following components:

  • Source table

  • Data services transformation

  • BW DataSource as a target object

The BW DataSource has been imported to the Data Services repository. The package size ( maximum size of a data package in rows) and the number of loaders specified in the BW InfoPackage under DataSource Default Setting for Data Transfer have been copied to the DataSource (the data flow's target object). A 1:1 assignment (table to DataSource) has been created in the data services transformation for all fields that have to be transferred to the DataSource. The InfoPackage selections have been copied as WHERE conditions in the data services transformation.

You can now use the InfoPackage in a process chain. It is available there as a process variant for process type Execute InfoPackage. Alternatively, you can schedule the InfoPackage in the scheduler. We recommend using process chains.

To load the data, the 7.x DataSource BAPI ( BAPI_DSOURCE_SEND) is used.

More Information

For more information on data flows, see the SAP Help Portal under Start of the navigation path http://help.sap.com/bods Next navigation step <Your Data Services Release> Next navigation step Installation, Upgrade, Deployment End of the navigation path in Designer Guide.