Load your source data into your target system with Advanced Data Migration

In this blog, I demonstrate how to load your source data into your target system with SAP Advanced Data Migration by BackOffice Associates, leveraging the steps of my previews blogs:

1. A first technical glimpse into Advanced Data Migration
2. Get to know your target system with Advanced Data Migration
3. Extract your source data and prepare it for loading into your target system with Advanced Data Migration
4. Map your source data to your target system with Advanced Data Migration
5. Transform your source data into your target format with Advanced Data Migration

To start with, I must register my target SAP system as a data source. I did something similar before to download the target data dictionary and value mapping tables, but this time the connection is not to the database, but to the application server itself:

With this, I navigate to ADM > Integrate and create a Category for my Customer Migration like the Wave I created in dspMigrate earlier:

Within my Category I can now create a Template for the loading of my customer data. For this I leverage Batch Data Communication (BDC):

After the recording, I check that I got all fields that I need captured:

Next I create a view on top of my Target table and provide mapping field names as aliases:

With that I create my Process leveraging the Template and View I just created:

In the corresponding Process Template loop I specify the Primary Key Column Name and Field Mappings:

After activating my Process, I run the Process Post and see my Upload Succeeded with 91 successful records and 0 failed records:

Checking the log for more details I see 91 Success Messages including the Account numbers created in SAP:

And in transaction VD03, I see all my customers with their respective customer numbers (overall there are 93 customers now, because I had created 2 customers manually already):

With this my Customer Migration is completed and I can move on to the next migration wave which for me would be Material.