Data Mart Interface 

Purpose

The data mart interface makes it possible to update data from one InfoProvider to another.

You have the following options:

·        Data exchange of several BI Systems:  The data-delivering system is then referred to as the Source BI, the data-receiving system as the Target BI. The individual BI Systems arranged in such a way are called data marts. In this way, the InfoProviders for the source BI are drawn up as source systems.

·        Data exchange between BI Systems and other SAP Systems

For more information see Data Mart Interface between Several Systems.

Data marts can be used in different ways

·        they save a subset of the data for a Data Warehouse in another database, and wherever possible 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).

Features

A BI System defines itself to be the source system for another BI System by:

·        providing metadata

·        providing transaction 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.

Constraints

·        Changes to the Metadata for the source system can only be made here by a regeneration of 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.

See also:

Assigning a Source System to a Source System ID