Over the next few months I’m going to be part of Oracle Retail MOM and ISO Implementation for one of our middle east client. While Functional Team (BA Team) has already started on understating the existing Business, I got some time to plan the Data Migration strategy.
Data Migration from the legacy system is one of the key task for any retailer implementing Oracle Retail . Oracle released Data Conversion Toolkit from RMS 12.0.3 for the automatic data conversion from the legacy system. Latest version of this tool is available in RMS 13.0.1 version. (Oracle missed to release it with RMS 13 version). Though we have this Toolkit available, still we need to write lot of script for the data migration as toolkit doesn’t support migrating dynamic/transactional data. Data Migration should be treated as a small parallel project along with the complete implementation and can be broadly categorized in 4 phases:
Requirement Definition and Design Phase: This is the most important and crucial phage. In this phase, the detailed Data Mappings (with legacy and current system) and the strategy will be required in order to begin the detailed design process and also to produce conversion detailed designs and document procedures (manual and automated data conversion) to source, clean, convert and validate the data to be converted from the legacy systems to RMS.
Build & Test Phase: This stage is to produce a set of custom modules (for all automated conversion processes) based on the design documentation from the design stage andtest the data conversion processes and custom modules cutover.
Conversion Cutover Phase: This phase is to convert the legacy data required by the Oracle Retail Suite to the production database in phase wise.
Go Live : Once the business users have certified the conversion result meeting the pre-defined acceptance criteria, the new system can go into the production.
I've started working on the Requirement Definition and will post my approach for each phase in next few days.
About Nagesh Mishra
Nagesh Mishra - A Passionate Oracle Retail Certified Professional with more than 17 years of overall experience in IT industry and more than 15 years of domain expertise in Oracle Retail Applications. Worked extensively in diversified fields of Product Implementation, Business Consulting, Pre-Sales, Application Software Development, Maintenance and Support and Re-Engineering Oracle Retail projects.
0 comments :
Post a Comment