Data Migration: the Earlier Business Users Get Involved, the Better

by Katherine VasilegaNovember 22, 2010

One of the biggest challenges of data migration is getting business users involved on early stages. Data migration professionals often fail to provide data collaboration with business users. This has a great impact on the success of data migration projects. When business data experts are not engaged, the technical team has to decide what data needs to be migrated and how it should be mapped. When a technical team makes these decisions instead of a business team, this could end up in re-writing data mappings and business rules of the entire data migration solution.

What can you do to resolve these data migration issues? Here are some recommendations:

    1. Make sure that you have the correct source system. Validate that you are pulling out all the information needed without any duplicated records.
    2. Profile the source data and share that information with business users before data mapping.
    3. When the data mapping is complete, profile the target data to ensure that you have the right information and share your conclusions with the business team.
    4. Continue profiling and evaluating the quality of the data throughout the data migration process.

These data migration practices require a close collaboration of the entire team, including data stewards, developers and the end-users. You should start data migration with a project plan. Then you can appoint data stewards and data experts. After that, be sure to gain commitment from them for mapping, data quality review, validation, and scheduling the entire project. This will make your data migration efforts much more efficient and prevent you from doing a useless job.