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

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.