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:

object-explorer-7381128

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

system-types-1-2176286

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

new-database-8662351

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

data-source-registration-sdbnorthwind-1363079

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

data-source-registration-northwnd-2732447

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:

target-sources-5162024

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

fetch-tables-8362368

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:

system-type-group-tables-5904074

To Import Group Tables into my Target Source:

import-group-tables-1132152

Which enables me to extract them with Build And Refresh:

build-and-refresh-4992523

Thus, I get my 91 customers:

source-northwnd-7456713

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

field-mappings-6429817

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.

New NetWeaver Information at SAP.com

Very Helpfull

 

 

User Rating: Be the first one !