Agito provides the table structure and requests the customer to prepare migration data compatible to this structure. Dedicated specialist(s) from the customer should be provided for data conversion phase of the project to work together with Agito’s developers. Data conversion is multi-phased work in the project, it is crucial that the customer provides consistent data before conversion runs by Agito.
Phases of migration process are listed below:
Analysis of Data Will be transferred:
Structure of current data of the customer and Agito General are analyzed. Then the mapping of source and target system is made.
Data Transfer Code Development:
Development of intermediate data base structure and validation rules which will be run on intermediate data base to validate quality of data are performed in this phase.
Data Migration Tests:
In order to detect previously encountered situations are simulated in an iterative process of data transfer prior to the actual data transfer process within the framework of the project. Control rules will be executed on the data obtained in this process, and possible errors in the intermediate data base. Evaluating the necessary arrangements is made by the customer and Agito.
Data Migration User Acceptance Phase:
In the approval process, before user acceptance test phase of the project, data is transferred to the system for testing usability and accuracy of the transferred data. In this way, considering all factors before using live a full testing process is operated.
Transferring Data to Live Platform:
After user acceptance test phase, with the approval of business departments live data is transferred to the live system.
Data Migration Process
Migration process is planned according to the steps below:
- Requirements Analysis
- Functional Design
- Technical Design
- Extracting and Loading
- Functional Test
Once the analysis and mapping steps are completed, the way of importing the data into the new system is decided. This process may be a combination of automation and manual processes or may be completely automated or may be completely manual.
b. Analysis & Assessment:
- The source structure is analyzed and defined
- The structure of Agito application is defined
- The field mapping is performed (mapping between the source and target structure with data cleansing, if necessary)
To analyze and define source and target structures, analysis is performed on the existing system to understand how it works, who uses it, and what they use it for. A detailed migration analysis document is prepared by Agito and customer.
The staging table structure where the verification rules to be executed is designed in specific to the customer.
d. Extract & Transform & Load:
Following the assessment and design; development of migration process is completed and partial data is transferred to the staging tables. Verification rules are run on the staging tables in order to see the incompatible data. Until the confirmation of ETL codes and the transferred data; migration is iteratively continued. As the ETL codes and the migrated data are accepted to be complete; the cumulative data is transferred to the legacy system and the verification rules are run on the legacy system.
e. Testing & Verification:
Test scenarios, prepared in specific to the customer; verification rules are executed on the migrated data in order to be sure that the system is compatible with the migrated data. ETL codes are reviewed and data migration is performed until Agito system is compatible with the migrated data.