Businesses need to migrate data for a variety of reasons, including mergers and acquisitions, standardising services, retiring legacy systems and modernising existing systems to achieve greater operational capacity, efficiency and improved customer experience.
As data migration usually needs to be highly-structured and follow a specific set of rules, robots are the perfect tool for managing the process. Robotic Process Automation (RPA) is increasingly being used for data migration purposes as it gives consistent and accurate results with unparalleled efficiency.
TRADITIONAL DATA MIGRATION
Weaknesses of the ETL approach:
Bypasses most validation rules. Majority of the validation rules are built into the user interface & code. Extract, Transform, Load (ETL) extracts & loads via back-end databases.
Likely to push dirty data into your new system. Source system data was added over time, some data was added before current validation rules were created. Reliant on ETL developer to identify rules highlighting dirty data.
ETL & data analysis tools are expensive. Results depend on skills, knowledge & approach of specialist using the tools.
Strengths of the ETL approach:
Significant portion of your database is relatively straight-forward reference data, which:
Change less often than transactional data.
Has limited variation.
Usually requires only simple validation.
Easily migrated with “home grown” scripts.
ROBOTIC PROCESS AUTOMATION
Weaknesses of Robotics-Assisted Data Migration:
Target system may have 100’s of database tables. Many are simple and don’t justify the expense of Robot work flow development.
Robots don’t have the sophisticated data analysis capabilities of expensive ETL tools.
Strengths of Robotics-Assisted Data Migration:
All validation rules are applied – because data is entered into the screens.
Dirty data usually violates target system validation rules and won’t be added to your new system. Highlights data that needs to be cleansed.
Robots are multi-functional, investment can be used for other tasks.
Robots work 10 times faster than a human and NEVER makes a data entry error.
Robots don’t require integration or API’s (but can use them when available).