ERP Applications and Vendors
  Home ERP Benefits Features Selection Implementation SAP Oracle Microsoft Dynamics Books
ERP Guide
Business Performance
Change Management
Data Migration
Decision Making
Enterprise 2.0 S/W
Enterprise System
ERP and Accounting S/W
Fix Implementation Failure
Functional Modules
Guide for Executives
Implementation Failure
Implementation Time
Improve ROI
Manufacturing S/W
Measuring Performance
Negotiating Agreements
Open Source S/W
Outsource Service Providers
Outsourcing Software
Project Management
Replace Existing Software
SAP Business One for SME
S/W for Telecom Sector
Syspro Accounting S/W
Vendor Shootout
Web Vs Server Based
When to Consider
Beginner's Guide
Basic Features
Become Consultant
Before Implementation
Best Practices
Certification Course
Effects of Enterprise S/W
Evolution and History
Finance Module
Functional Consultant
Functional vs Technical
Future of ERP
Future Trend
GAP Analysis
Get Maximum ROI
Goals and Objectives
Guide for Beginners
History and Evolution
Implementation Methods
Implementation So Long
Implementation Stages
Implementation Steps
Implementation Timeframe
Increase Productivity
Industry Focus
Issues In Outsourcing
Latest Trends
Major Pitfalls
Market and Industry
Market Growth In India
Open Source Popularity
Regulation Governing
Rising Need of S/W
Roles of Consultants
Software as a Service (SaaS)
Software for SMEs
System Requirements

Data Migration Strategies in ERP Software

SocialTwist Tell-a-Friend

Data migration is a crucial stage of ERP implementation which requires careful analysis of data and removal of junk data. If it is not done carefully - the excess data may clog the system and waste a lot of resources and even confuse the waste data with the priority data. For data migration the following steps should be taken.

Identify the data: The most crucial stage of data migration is identifying the valuable data. The data will be categorized in various types such as set up data - the principles and procedures to be entered to the system and this is done manually.

The other type of data is the sub master and master data - which is basically one time entry data required to be entered only once and it includes the terms of payments or methodologies.

Master and sub master entry: The master data include the material master, customer master, company master etc. The entry is done for the company and its parameters. The data entered in the master tables should be extensible and should be of transactional nature. The data requires regular updates and maintenance. Tools can be used to make the masters entries.

Transaction data: When the transactional data is entered into the system - the system goes live and therefore, it should be carefully analyzed. It is the data related to everyday transactions and financial balances. The system can go live only after the transactional data is entered and fully tested. The transaction data includes the data from the customers, suppliers, the trail balances etc.

Determine the time of data migration: All the data till date is entered in to the system. The open balance and the open and closed balances should be resolved to prevent any errors in data. The data should be validated before it is to make it go-live and it should be ready for conference room pilot.

The data should be validated and the sub master data should follow the same process for set up as the master data.

The transaction data should be tested for the whole data load cycle which includes the validation of accounting entries and transferring the data to ledgers.

Data migration for different countries: The sharable component of the whole software should be used for integrating the data of various countries and the templates can be used to handle different sets of data. The data having unique identity such as customer id, supplier id should be made mandatory and the second set of data include the payment terms - which are non mandatory fields.

The third set of data refers to the data which is specific of certain regions and countries.

Get the tools: There are many different types of tools available to load data into the tables and it includes the data loader, SQL loader, standard APIs, forms, user interfaces etc.
Setups can be used for data migration and certain set ups can be specifically designed for moving the data into the new tables.

Data archiving: Data archiving can be done for statutory data required for the country specific or region specific data which belongs to particular business areas.

Security: The security of data should be ensured at each stage of data migration.

 Read Related Articles

ERP SoftwareNeed of ERP System
ERP SystemNegotiating ERP Agreements
Enterprise SystemERP Project Management
Enterprise SoftwareInstitution for ERP Courses

  SocialTwist Tell-a-Friend
Review Section
Dynamics AX  
Dynamics CRM  
Dynamics GP  
Dynamics NAV  
Dynamics SL  
Godrej eNcompass  
JD Edward  
Microsoft Dynamics  
Sage X3  
SAP Business One  
Tally Accounting  
SAP Section
ABAP Module  
Business Warehouse  
BW Module  
Career In ABAP  
CO Module  
Course Duration  
Course Fees  
Data Warehousing  
Enterprise Portal  
FI Module  
HRMS Software  
HR Module  
Job Opportunities  
MM Module  
Modules Features  
Online Training  
Performance Tuning  
SD Module  
Web AS  
Web AS Features