ETL - EXTRACT, TRANSFORM & LOAD:
ETL - EXTRACT, TRANSFORM & LOAD:
Extraction is the first step where the existing data is extracted for migration process from the original source. This data is completely unmodified and is in it’s original form that works as per the compatibility formats of the source platform or hardware.
This extracted data is then transformed as per the applicable compatibility rules that complies with the destination platform which can be either the of the same type or a completely different version. This requires complete compatibility check and the data is transformed to work with the same efficiency on the destination platform.
The final step of the ETL process is the “LOAD” where the transformed data (Processed as per the compatibility format of the destination platform) is finally loaded to the destination platform or hardware and enabled to run as per the core rules of the application.
With evolving technologies in the storage space, companies often find the need to upgrade their storage hardware of their physical media using various virtualisation methods. During this storage upgrade or migration, the content in the physical media is migrated to the new storage space without disturbing the actual content in it and the quality of the same. This improves the efficiency of handling the storage space and improves indexation of the media with the latest hardware upgrade while the layers and formats of the original media left undisturbed.
Application upgradations takes place to improve the software functionality and to add new features to it. This results in transferring the database to a new software or upgrading the version of the existing software. The transferring requires compatibility check and the process might require minor or major changes to the original database while the upgradation might require little or no changes to the original data. Databases based on latest technologies like MySQL, Sybase, DB2 or SQL Server to Oracle requires little or no changes at all during the migration process since these platforms are optimised to handle all types of migration or upgradation process. This might require some testing phases to ensure the original functionality of the database remains the same.
Companies face the need to upgrade or switch to a new CRM [Customer Relationship Management] or ERP [Enterprise Resource Planning] platforms when the necessity arises. This involves substantial data migration process since every application has their own set of data handling structure and fundamentals. This post-migration structure also needs to simultaneously interact with other applications and machines on a wide scale, within the Enterprise applications environment. Commercial off-the shelf packages are available to configure the applications right from their meta-data and help them scale-up their promotions. Application Programming Interfaces [API] are also provided by the vendors to retain the integrity of the applications and scripts using the web-interface can also be configured for automated application data-migration process.
BUSINESS PROCESS MIGRATION
Business Acquisitions, store migration, mergers, new verticals and expansions in different locations involves data or application migration to suit the new environment and work seamlessly with the existing data structure. This brings an impact on the existing data-structure and can often face huge challenges. The migration process needs to comply with the new set of customers, products and operational scenarios.
Unlike Storage or Database migration processes, these type of migration process often involves changes in the business fundamentals without disturbing the existing structure and needs a highly adaptive approach. These are very complex changes made to the existing environment and can be achieved through some key factors like data-governance, resilient project-management, business audit capability, support from the stake-holders and concurrent synchronization.