Skip to Content
Author's profile photo Former Member

Data Migration – Challenges

Challenges in data migration:

Traditionally in SAP implementations, the customer is asked to provide data in a particular format at a certain stage of the project. Many organizations find themselves to be in deep trouble because of the complex nature of the data requirements of the SAP and the non availability of data in their current/ legacy applications. This leads to many questions like:

  • How can I prepare data for SAP?
  • Where do I find the data to load into SAP?
  • What is the state of that data?
  • What is the process to get trusted data into SAP?

Without a proper plan many customers proceed with the implementation. Typically an ideal data migration effort takes up about 25-30% of the total implementation project. Due to sheer ignorance clients end up provision just 10% of their effort in data migration and in turn end up spending about 50% of the effort cleansing bad data post Go Live.

Need for a Data Migration framework and tool

It is not enough to just prepare and migrate the data to the newly built SAP system, the data has to be cleansed, profiled, and validated. This calls for a structured framework, robust methodology and investments in software/tools.

In my next blog, i will also speak about the various options availale within data migration and may be some best practices.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Markus Ganser
      Markus Ganser
      Looking forward to your follow-up blog.
      Author's profile photo Priti Rani Patnaik
      Priti Rani Patnaik
      Hi Sriram.. this is a very important point being made. I faced this in one of my projects.. wherein we relished the importance of cleansing, enriching data much later. Needless to say.. if this would have been taken care of in the initial stages.. consolidating the data would have given much better results!


      Author's profile photo Former Member
      Former Member
      Hi, Sriram,
      I fully agree with your contents. Data migration is always underestimated. Normally client also give us full confidence that they have all the data ready accordingly we bank on this confidence in project plan with roughly 10% of effort estiated as you rightely said. It then turns into real pain area when actual migration starts and Go-live date is close.
      Author's profile photo Saif Manzar
      Saif Manzar
      We have been using SAP Business Objects for Data Migration without any issue.
      Once you have BO, i don't think there is need of any other tool. We do have a full-time data migration team working on the project though.