Extract your source data and prepare it for loading into your target system with Advanced Data Migration

[architectSAP]

In my previous blog, I explained how Get to know your target system with Advanced Data Migration. In this blog, I will subsequently explain how to extract your source data and prepare it for loading into your target system.

For this, I use the Northwind database as my source system:



To start with, I create a System Type for this database in ADM > Common > System Types:



Next I create a corresponding source database in my ADM server:



And register it as a Migration Source Database in ADM > Common > Configuration > Data Source Registry with my new System Type SQL Server:



Similarly, I register my Northwind database as an External System Connection of Data Source Type ODBC:



Especially important is the Connection String in Advanced Settings, e.g.:

Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

With this I can add my Northwind database as a Target in ADM > Collect > Targets and Target Sources respectively:



This allows me to Fetch Tables from my Northwind Database into my System Type:



Where I find them, and can choose which ones to replicate. In my scenario, I am interested in the customers so I chose the respective table:



To Import Group Tables into my Target Source:



Which enables me to extract them with Build And Refresh:



Thus, I get my 91 customers:



Based on this I define the field mappings from my Northwind database to my SAP system:



Since this is a big topic it is covered individually in more detail in my blog Map your source data to your target system with Advanced Data Migration.