The data mart interface makes it possible to update data from one InfoProvider to another.
You have the following options:
● Data exchange of multiple BI Systems: the data-delivering system is referred to as the Source B; the data-receiving system as the Target BI. The individual BI systems arranged in this way are called data marts. The InfoProviders of the source BI are used as sources of data here.
● Data exchange between BI systems and other SAP systems
More information: Data Mart Interface Between Several Systems
Data marts can be used in different ways:
● They save a subset of the data of a Data Warehouse in another database, possibly even in a different location.
● They are smaller units of a Data Warehouse.
● They are stored as intentionally redundant segments of the (logical, global) overall system (Data Warehouse).
A BI system defines itself as the source system for another BI system by:
● Providing metadata
● Providing transaction data and master data
An export DataSource is needed to transfer data from a source BI into a target BI. Export DataSources for InfoCubes and DataStore objects contain all the characteristics and key figures of the InfoProvider. Export DataSources for master data contain the metadata for all attributes, texts, and hierarchies for an InfoObject.
● Changes to the metadata of the source system can only be added to the export DataSources by regenerating the export DataSources.
● The Delete function is not supported at this time.
● You can only generate an export DataSource from an InfoCube if:
○ The InfoCube is activated
○ The name of the InfoCube is at least one character shorter than the maximum length of a name, since the DataSource name is made up of the InfoCube name and a prefix.
Note the special features of the assignment of a source system to a source system ID in data mart scenarios.
More information: Assigning a Source System to a Source System ID