Professional Services – Data Migration
Every application operates on its own specific data model but this does not mean that the transfer of data from one system to another has to be as arduous as it may initially appear. The key consideration of the process plan for transferring data is timing, in order to reduce and hopefully eliminate any system downtime.
Data migration may involve many phases but it minimally includes data extraction where data is read from the old system and data loading where data is written to the new system. To achieve an effective data migration procedure, data on the old system is mapped to the new equivalents. This mapping specification also incorporates any potential technical issues such as relating old data formats to the new system’s formats and requirements.
Typically, Jane implementers will adopt an Extract, Transform and Load (ETL) approach which allow elements of data to be groomed before being loaded into the Jane database model. Automated and manual data cleansing is commonly performed in migration to improve data quality, eliminate redundant or obsolete information, and match the requirements of the new system.
The Jane System Module incorporates a number of standard application functions which allows implementers and users alike to load data into the Jane modules from industry standard formatted data sources such as Spreadsheets. This can be done as one consolidated exercise or added to the appropriate modules when new functionality is being introduced in a staged manner.
After loading data into Jane, standard application functionality such as reports and queries can be used to determine whether the data was accurately translated, is complete, and supports processes in the new system. During verification, there may be a need for a parallel run of both systems to identify areas of disparity and potentially identify errors or even loss of data during the migration process.
Converting data can often cause long-term problems if not audited for accuracy, so our conversions are fully audited and the data verified as key stages of the project implementation plan.