Data Mart Interface 

Purpose

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

You have the following options:

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

See Data Mart Interface between Several Systems

·        Data exchange between BW Systems and other SAP Systems

See Data Mart Interface between Several Systems

·        Data distribution within a BW System (Myself connection)

See Data Mart Interface in the Myself System

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).

Functions

A Business Information Warehouse represents a source system for another Business Information Warehouse by:

·        providing metadata

·        providing transaction and master data

An export DataSources is needed to transfer data from a source BW into a target BW. This export DataSources for InfoCubes and ODS objects includes an extract structure that contains all the characteristics and key figures of the data target. Export DataSources for master data contain the metadata for all attributes, texts and hierarchies for an InfoObject.

Restrictions

·        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