+27 (0)21 551 2410
Facebook Twitter LinkedIn

Data Migration

 

Data Migration is the process of moving data from one or more systems and environments to a new solution environment. It sounds easy, but many projects fail (running over time and over budget) because of Data Migration challenges not being resolved on time.

Why? The answer is simple; because Data Migration is often underestimated and considered as an afterthought within the bigger programme. Data Migration is a complex task and should be considered as an integral component of any new Solution Development. Some of the challenges that can be expected are as follows:

  • Identifying and analysing Source Data: Often there is insufficient understanding of data and source systems. The required data is spread across multiple source systems, not in the right format, of poor quality, only accessible through little-understood interfaces, poorly documented, missing source code, burdened by superfluous logic, or sometimes missing altogether.
  • Addressing Data Quality in the Source Systems: Data migration teams need to understand and accept that there will be inconsistent or corrupt data in the Source Systems. Data quality can be compromised as a result of how the data has been entered, maintained, processed, and/or stored. Poor quality data may jeopardise the success of the Target Solution.
  • Preparing and loading data into the Target Solution: The Target Solution is often under development at the time of Data Migration, and the requirements often change during the project. Many Target Solutions have restrictions, constraints, and thresholds on the validity, integrity, and quality of data to be loaded. This means that Data Cleansing is often a pre-requisite for Data Migration.

How can InfoBluePrint help?

 

InfoBluePrint have developed a tried and tested Data Migration Methodology which is based on our Framework which defines all the components that are critical to successful data migration.

  • We start with a Pre-Migration Preparation Process which includes a Data Assessment and the development of a Data Migration Strategy.
  • The Data Migration Strategy defines the Scope of Data to be migrated and the Approach in terms of Extract, Cleanse, Transform and Load (ECTL) and also the Supporting Processes.
  • The ECTL Process is the main Data Migration Process.
  • Supporting Processes are integral parts of each of the ECTL Processes. This results in assurance that the Data Migration Process is Auditable, Tested, and Prepared for both Cutover and User Acceptance.
  • We advocate an iterative approach to Data Migration. The approach must be automated, production class and should require minimal human intervention.
  • We will assist your company to define, implement and monitor the Data Migration Strategy.
  • We will implement the Data Migration Strategy providing an expert team to manage and implement the ECTL Process and its supporting processes.
  • In addition we will ensure that the expectations for reliable data in the target solution are met, by applying our proven Data Quality Management Framework in conjunction with our Data Migration Methodology.