ERP Data Migration Strategies for Successful Implementation

Published: 11th August 2010
Views: N/A

To make an ERP implementation successful data migration is the key factor. When a data can migrate effectively that proves that the ERP system is just appropriate for them. And this projection builds their confidence in the system and which in n turn becomes the key factor of the success of ERP implementation.

Though while implementing an ERP the main focus is on the modules attached with it and how popular it is, but what they lack is the focus in the operation of the system, that is real time data migration, which cannot be determined till the ERP is started working full fledged with all real time data, and when some one find out that the data is not migrating efficiently and effectively then the ERP implementation is becomes a failure.

The real problem lies in the fact that data migration is the last activity we do, because real time data can only migrate when the system is about to working live, so the real problem area starts after that.

Strategy of Data migration

There are few strategies that need to be followed while migration of data -

1. Data identification for migration.
2. Determine the time for data migration.
3. Generation of the data templates.
4. Data migration tools need to free zed.

The data Identification for migration

The Identification of the need to be migrated to any applications consists of four groups of data. A particular order need to be followed while entering the data as, all data is interdependent.

The order is like

A. Configuration Data - These data are for one time feeding into system that's required for set up.
B. Sub master Data - These data are mainly related to any transaction procedures.
C. Master Data - These are the data which are being regular updated. It relates from sales module to purchase modules to stocks and inventory.
D: Transaction Data - These are the data which are entered at the end of all these above data entry order. It consists of balance sheets, reports, and other end results.

Data load timing

1. As we discussed above the timing should starts from set up data and it will end at transaction data. But as set up data can be entered just one time so exception caution should be taken while entering it.
2. And same rule goes for the case of sub master's data entry.
3. And for Master data and transaction data, both are continuous process so loads on tools need to be taken care.


These are sharable components mostly for various users, between different countries or continents so it should be created and modified keeping the exact purpose of sharing.

Tools to be used

There are four different tools can be used to load data into the database.

1. Desktop Integration - This tool is used for one window based process.
2. SQL Loader - These tools accept data from databases.
3. Oracle Standard APIs - This tool is meant for oracle database.
4. Custom Built Interfaces - These are custom's verified data for loading into database.


Data migration is very important activity in establishing the success of an ERP implementation. An accurately migrated data is a reflection to the stakeholders that the ERP system is perfect and gives clear indication of their current organization. This increases their level of confidence in the system and in turn is a key factor in the ultimate success of ERP implementation.

Read information about ERP Implementation Strategies. Read information about Infor SyteLine ERP. Also read about NetSuite ERP Software Review.

Report this article Ask About This Article

More to Explore