SAP MDG data migration - Part 1

[mageshwaran_subramanian]

The primary goal for any organization implementing the SAP MDG solution is to get the data clean and keep the data clean. SAP MDG facilitates the consolidation of the master data from the decentralized data sources and/or centrally governs the data. The data load tool availability will vary depending on the MDG consolidation and central governance capabilities.



SAP recommends implementing MDG as a separate master data hub as opposed to co-deployment. You can read more about the deployment considerations here. If MDG is to be deployed as a hub then the data migration becomes a vital task.

In order to get the data into MDG, SAP provides a handful of tools. In this blog series, let us discuss the various data load tools and techniques available to us. Please note that non-SAP tools are not covered.

Let us see the tools/functionalities available that facilitate the data loads.

1. Data Import Framework *


2. File upload*


3. Data Migration Cockpit (only available on MDG on S/4HANA) *


4. SAP Data Services (and Information Steward) **


5. SAP Smart Data Integrator (and Smart Data Quality) **


6. SAP Agile Data Preparation**


7. Master Data Consolidation file upload**


8. Back-end functions/LSMW*


9. SOA*

*: Available for MDG - Central Governance

**: Available for both MDG – Master Data Consolidation and Central Governance

Please note that the functionalities 1,2,3,7 and 8 are available within the MDG system and no additional licenses required.

If you read this blog, please comment on the data load tool that you preferred in your MDG implementation projects.

Part 2 explains the MDG Data Import Framework and File upload method.

Part 3 provides details about SAP Data Services and S/4HANA Migration cockpit in terms of MDG data loads.

Part 4 explores how next-generation HANA powered tools such as Smart Data Integrator (SDI), Smart Data Quality (SDQ) and SAP Agile Data Preparation (ADP) help in MDG on S/4HANA data migration.

Part 5 explains MDG consolidation data import and traditional data loads methods using back-end functions.

---

This disclaimer informs readers that the views, thoughts, and opinions expressed in the text belong solely to the author, and not necessarily to the author's employer.

[mgbernardo]

Nice analisis mageshwaran.subramanian

Is MDG included with S/4 Hana 1809? Or is it a separate license?

 

Thanks in advance

[mageshwaran_subramanian]

Thanks. S/4HANA comes with MDG functionality but licensing required.

[former_member186897]

Good post, mageshwaran.subramanian. Interesting read about various tools and options available for data migration with MDG. This is time saver as well if someone wants to learn quickly about these various options.

[former_member277436]

very useful post. thanks for sharing detailed information on Data Migration with MDG.

[Former Member]

Hello Magesh Subramanian,

We are implementing MDG Hub on S/4 (HEC), and in parallel moving ECC to S/4. We need to define how to load initial master data into the project (BP Supplier, Customer, Partner, Material). In addition, we need to load related data such as bank account, consignment account, profit center, cost center, class/classification, What would be the best tool to perform this initial load? Which one you recommend?

Thanks a  lot!

 

BR,
Ana

[mageshwaran_subramanian]

Hi Ana,

Sorry for joining in late.

This blog series could have given you some idea of what tool to choose from.  You can take a look at software such as SAP Data Services as it offers a wide range of data migration capabilities and works seamlessly with SAP S/4HANA and ECC.

Feel free to post additional questions if you have any.

Regards,

Magesh

[maraheem]

Good information provided for the data migration on hub senario

[sawantp80]

Very useful Information. i am working on finance topic such as cost center, profit center, GL and their Hierachies. In this topic i need one matrix templet. Specially in Edition concepts the data will migrate from S4 hana to MDG system. Please provide me if you have any Finance matrix for above topic.  Its big help for me.

[former_member300808]

Hi Magesh,

Thanks for sharing this useful info. I am looking for data file import functionality to send 16K+ vendor records  to a third party tool from MDG. Do you recommend any tool available for data replication in MDG . As of now when i use file import functionality it tigers idocs but in  a limited quantity ( 200) only i can trigger and send the data to third party. but i need a tool which can trigger all 16K+ vendor data.

[mageshwaran_subramanian]

Do you want to replicate the data real-time from MDG to a third party system?. From you question I understand that the target system can receive the idocs. I'm not sure what limits the 200 idocs but if it is a one time load and you want to extract the data from MDG and load to a different system, use tools like Data Services.

[former_member668697]

Hi Magesh,

 

Firstly, thank you so much for series of blogs with very useful information.

We have a scenario where in we are migrating suppliers from 8 different ECC source systems into MDG. Post migration the ECC systems would still continue for few more years until complete S4 HANA transformation.

This means MDG will be the source for supplier data and will replicate them to ECCs.

Now, as part of the data migration we need to get the key mapping updated with all the 8 different ECC systems as source so that post migration the updates in MDG are replicated to ECC with the right ECC supplier number.

 

Our customer is requesting to use the MDG Consolidation to create the key mapping and not to go with any custom development. Also, SAP contact person recommended the same instead of Data Import.

 

Can you please share more details to upload the source data to MDC to create the mapping?

Appreciate your reply.

 

Thank you.

[mageshwaran_subramanian]

Hi Shiva,

Hope this is what you're looking for: https://blogs.sap.com/2020/02/28/sap-mdg-consolidation-data-import-the-etl-way/

Let me know if you have more questions.

[nallasivam_balagurusamy]

Hi Magesh,

Thanks for sharing such a detailed & clear information about the all possible Migration options at one stop!!!

Thanks,

Nalla B.