Skip to Content
Author's profile photo Frank Densborn

How to Visualize Data Migration Projects

Talking about data migration projects is talking about a topic which actually is relevant for all companies that need to move data from one application to another. This includes companies that are:

  • Implementing a new SAP system while replacing a legacy one
  • Acquiring or merging with other companies
  • Expanding into new lines of business
  • Initiating green IT projects to reduce hardware and system environmental and dollar costs
  • Harmonizing data and processes across organizational boundaries
  • Conducting a global SAP rollout

In this third part of the Data Migration blog, we are focusing on reporting, visualization, and governance for data migration projects. In addition to the jobs, workflows, mappings provided as Best Practices content by SAP rapid deployment solutions, there are also reports and visualizations to keep you updated on the status of the data migration. The data migration project can lay the ground work for data governance, data ownership, and ongoing data quality. Governance of data and information is a topic gaining increased interest and data migration falls into the Governance category, providing the first opportunity to implement governance processes around the management and data quality expectations. Below are some examples of the reports provided today with the SAP Rapid-deployment solutions for Rapid Data Migration.

Figure 1, an example report that shows the status of the migration objects.

Figure 2, shows the number of valid and invalid records for the customer master.


Figure 3, the management summary for all customer master related segments.

Figure 4, an example reconciliation report for material master showing which records have failed.

Using SAP Rapid Data Migration when migrating to non-SAP applications

There are several situations where customers may need to migrate to non-SAP systems or load data from one non-SAP system to another, for example loading a data warehouse. Extraction, transformation, and loading of non-SAP systems is supported by SAP Data Services. Of course, the migration content discussed above cannot be leveraged, but Data Services does provide blueprint examples.

Data Services blueprints provide examples of quality rules, workflows, jobs that can be used. These are used to depict best practice settings for common data quality issues. With these blueprints example data is used to illustrate how a job and quality rules should be designed. There are also blue prints for text analysis functions in Data Services. You can access the blueprints and related documentation on SCN:


You now have enough information to investigate the use of SAP Rapid Data Migration software for your next data migration project. Hopefully it is now clear that SAP has a proven solution to migrate legacy data to SAP application systems. This solution is based on SAP Data Services, an ETL (Extract, Transform, Load) tool out of SAP’s growing Enterprise Information Management portfolio (EIM). Part 1 of this blog gives a good overview about the Data Migration architecture while Part 2 provides a detailed step-by-step example.

SAP Rapid Data Migration should be used when implementing new SAP systems, as well as when adding new lines of business, or having system consolidation/system decommissioning projects. SAP’s Information Lifecycle Management works with data migration for the decommissioning of non-SAP application systems.

SAP Rapid-deployment solutions for data migration saves time and effort by providing migration content that enables you to map source to target data structures, as well as reports and dashboards that monitor the data migration jobs. Migration content can be downloaded from and loaded into Data Services. Migration projects require iteration of data loads to better understand the data, as well as close collaboration between business and IT.

Still more appetite? 🙂 Watch this 5 minutes demo recording to get a clear picture about the tools and the process:

Follow SAP Rapid Deployment Solutions on Twitter: @SAPRDS

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Excellent overview Frank. Very clear and also points to the importantance of data migration and the valuable content & best practices delivered with RDS. The 5 minute video link is also outstanding.

      Thank you for the clear, concise messages and the importance of DM to any project!


      Author's profile photo Frank Densborn
      Frank Densborn
      Blog Post Author

      ASUG member?

      Make sure to register for the upcoming ASUG WebCast on July, 26:

      "Accelerate the Management and Migration of Your Enterprise Data with new tools and methods from SAP Rapid Deployment Solutions"

      Author's profile photo Frank Densborn
      Frank Densborn
      Blog Post Author

      After today's successful ASUG webcast, you'll have now the opportunity for real hands-on: the first teach of the all-new SAP Education Data Migration training workshop with SAP Data Services will be held in Newtown Square PA August 30-31. Register here:

      The two-day workshop is available in SAP Education as course WNAM4M.

      Author's profile photo Frank Densborn
      Frank Densborn
      Blog Post Author

      There is a new date and availability to attend the all-new SAP Education Data Migration training workshop on-site. The course will cover SAP Data Services usage combined with the SAP RDS Rapid Data Migration content.

      New date is November 1-2, location is Newtown Square, PA.

      More information and how to register under the following link:

      The two-day workshop is available in SAP Education as course TZIM4M.

      Author's profile photo Frank Densborn
      Frank Densborn
      Blog Post Author

      There are new Rapid Data Migration packages available. Both contain more and updated objects and an upgrade to SAP Data Services version 4.1.

      Check it out:

      Author's profile photo Frank Densborn
      Frank Densborn
      Blog Post Author

      You want to learn more?

      Please register for the upcoming webcast:

      Author's profile photo Frank Densborn
      Frank Densborn
      Blog Post Author

      Today we’ve released the Rapid Data Migration to cloud solutions from SAP package including content for SAP Customer on Demand (CoD) and SuccessFactors Employee Central (EC). Please continue reading here.


      The official landing page in the SAP Service Marketplace is as below: