What is Data Migration?

Data Migration is the very complex process of extracting data from one system, convert content and structure according to the requirements of a second system, and then load these converted data into this second system. In some cases, it is even required to split the converted data and data structure for load into more than one target system.

To be successful means to understand the data structure and the content of the source system first. Secondly, it is also required to understand the structure of the target system. Then, along with the business owners of these data the conversion exercise (mappings) can start. This process is a highly complex technical but also complex business subject.

Data Migration is also a good chance to get rid off organically grown content and structure.

Data Migration Sample

Altova

Complex looking data mapping (Source: Altova Mapforce screenshot)

The picture on the left shows a complex mapping structure using Altova´s mapforce tool. Trying to handle this in Excel would certainly fail. Using the right tool makes even very complicated mappings quite easy.

Data migration usually involves not only mapping of fields between source and destination database but also to do complicated calculations, transformations or corrections. Sometimes it is even required to split the source database content into two or more destination databases.

Our contribution

Holistic Analytics will exercise the following 13 steps of data migration:

1. Understand the business
2. Analyze the existing processes
3. Understand the data structure of the legacy systems
4. Understand the new processes
5. Understand the data structure of the new implemented systems
6. Undergo a data profiling
7. Recommend data cleansing activities
8. Obtain customer buy-in
9. Execute data cleansing
10. Setup the data mapping
11. Achieve customer acceptance of the recommended mapping
12. Perform the data mapping
13. Get customer signoff

So we utilize our unique blend of business acumen, process knowledge and technology expertise.