Data Migration is a process of moving required volumes of data from our clients’ existing systems to new systems. Existing systems can be anything from custom-built IT infrastructures to spreadsheets and standalone databases. Data conversion can be defined as a process of converting data from one structural form to another to suit the requirements of the system to which it is migrated
Importance of data conversion/migration and interfaces within any ERP implementation project can’t be ignored. Since ERP mostly deals with data which finally leads into Information , thus it is equally important to understand the aspect how “data” is important in any ERP system specifically in implementation phase, no matter how simple and unified operation is. In common situation, we have three cases:
The Customer is running there some home grown IT application which cater most of the company need. Now management has decided to go for any ERP solutions, then the question what will happen for data which is already in the existing application?
Another situation is already using ERP
They want to upgrade to higher version resuming the structure of some table get changed?
The company is acquired or merged with some other company, and the whole data need to move into the parent or child company.
They want to enable some additional modules within existing application.
There are few data interacting with both the cases irrespective of database technology for where data is coming and going based out of need.
The answer of the 1 is data migration and 2 is more pronounced as data conversion where as thirds is popularly known as Interface. The ways these are working haven’t much difference but it is more important to understand definition and need.
Lets take a deep drive to understand better:
Why conversion/Migration is more important in ERP?
Before Go-Live in the production environment the required master data, the open transaction data and the historical transaction data need to be imported from the old legacy applications to WORLD-PMS Applications. Since data structure and data design in legacy systems are different from those of WORLD-PMS Applications, data need to be messaged/ converted satisfying the business rules to suite the WORLD-PMS requirement. Initial data can be migrated by any other means as discussed above depending upon cetain paramater like Volumn, usage, complexity , business rule etc.
How we Define Data Conversion
Process where existing data from the client’s old system is extracted, cleansed, formatted, and installed into a new system.
These can be manual or automated.
The big difference is that these are One-time only process that requires extensive testing and preparation.
They must be executed and performed before a system goes into production.