Data consolidation from multiple source systems to MDG

[former_member469694]

Hi All,

First, I am new to MDG and here is my business scenario. Anyone can help me with the best approach here?. Is key mapping and value mapping  can take care this scenario?. Below scenarios are examples only.

1. When we consolidate (initial load) master data from multiple source systems to MDG hub, how do we identify what records come from what source systems in MDG hub?

2. How do we build user security in MDG for each source system for data governance?. For example 'Data steward 1' has access to 'source system 1' data only in the MDG user interface

2. How do we handle unit of measure or material type in MDG when this is different in different source systems and each source system want to keep the same for example, source system 1 has material type 'ABC - Finished goods' and in MDG we have 'FERT - Finished goods' in ECC system.

The  business scenario is, we need to consolidate material master from 'source system 1' and the material type is ABC - Finished goods, after consolidation and any maintenance in MDG, we need to keep the same material type for 'source system 1' and replicate back to 'source system1'.

Another example is UOM is different in source system & MDG

Thanks.

[former_member188878]

Dear Mike,

1. When we consolidate (initial load) master data from multiple source systems to MDG hub, how do we identify what records come from what source systems in MDG hub?

There are various tool and methods are Provided by SAP to consolidated the data for different source system.you can evaluate the possibility of which one suite to you based on the complexity of data and volume.tools like SAP BODS,MDM etc can be use along with MDG.coming to the point of reconize the data coming from the which source system various paramaters lik who upated,time of updated etc.

Eg:use ID DATASERVICES then the Udate record will have the same ID.

2. How do we build user security in MDG for each source system for data governance?. For example 'Data steward 1' has access to 'source system 1' data only in the MDG user interface

   Security aspect are restricted to respective systems and can be control based on Role bases.

2. How do we handle unit of measure or material type in MDG when this is different in different source systems and each source system want to keep the same for example, source system 1 has material type 'ABC - Finished goods' and in MDG we have 'FERT - Finished goods' in ECC system.

while migrating the data you can define the transformation and Mapping rules in the tool that is use to migrated the data from source system.

you can define the value mapping in MDG before you import the data or using the other tools like data services define the transformation in the DS,post the data in MDG hub and replicate it back to target system.

Hope this will helo you

[Former Member]

Hi Mike

From above as there is change in configuration values from Source into MDG Hub it is prefer to do value mapping. Key mapping is used for mapping between any objects Like material number or vendor number.But in your case as yoy want to map configuration/reference data, you need to perform value mapping means we can map ABC material type from Source into FERT material Type into MDG Hub.

Please refer Maintain value mapping via file export/import

Also you can restict users by adding Plant restrictions