Show TOC

Using the Data Mart InterfaceLocate this document in the navigation structure

Use

If you want to define an existing BW system as a source system, you use the functions of the Data Mart interface.

Procedure

1. In the source BW system

Before a BW system can request data from another BW system, it must have information about the structure of the data to be requested. For this, you have to upload the metadata from the source BW into the target BW.

You generate an export DataSource for the respective InfoProvider in the source BW. This export DataSource includes an extract structure that contains all the characteristics and key figures of the InfoProvider.

For InfoCubes/DataStore Objects: Generating Export DataSources for InfoProviders

For InfoObjects: Generating Master Data Export DataSources

2. In the target BW system

  1. Define the source System if required: Creating SAP Source Systems This is only necessary if the source system has not yet been created in the target BW.

  2. Create the InfoProvider that you want the data to be loaded into.

  3. Copy the metadata of your export DataSource from your source BW into your target BW. You can copy all the metadata in a source system using the source system tree, or you can choose to copy only the metadata of your DataSource.

    More information: Replication of DataSources.

  4. Activate the DataSource.

  5. Create an InfoPackage using the context menu of your DataSource. Your source BW system is specified as the source by default.

    More information: Creating InfoPackages

  6. Using the context menu for your DataSource, create a data transfer process with the InfoProvider into which the data is to be loaded as the target. A default transformation is created at the same time.

    More information: Creating Data Transfer Processes

    The complete data flow is displayed in the InfoProvider tree under your InfoProvider.

  7. Schedule the InfoPackage and the data transfer process. We recommend always using process chains for loading processes.

    More information: Creating Process Chains

Result

You have loaded data from one BW system into another BW system.