Using the Data Mart Interface
Purpose
If you want to define an existing BI system as a source system, access the functions of the data mart.
Process Flow
1. In the Source BI
Before a BI system can request data from another BI system, it must have information about the structure of the data to be requested. To do this, you have to upload the metadata from the source BI into the target BI.
You generate an export DataSource for the respective InfoProvider in the source BI. This export DataSource includes an extraction structure, which contains all the characteristics and key figures of the InfoProvider.
For InfoCubes/DataStore objects, see: Generating the Data Target Export DataSource
For InfoObjects, see: Generating the Master Data Export DataSource
2. In the Target BI
...
1. If required, define the source system. This is only necessary if the source system has not yet been created in the target BI.
2. Create the InfoProvider for which you want to load the data.
3. Replicate the metadata of your export DataSource from your source BI into your target BI. Using the source system tree, you can replicate all the metadata of a source system, or only replicate the metadata of your DataSource.
4. Activate the DataSource.
5. Create an InfoPackage using the context menu of your DataSource. Your source BI 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 that you always use process chains for loading processes.
More information: Creating Process Chains
Result
You have loaded data from one BI system into another BI system.