EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.
Recent Searches
Watch the video and get a short introduction to data migration with use of ETL processes and tools – including an example.
If you acquire one or more companies you may face the task of consolidating several ERP-systems into one ERP system which usually involves migrating master data and transaction data into the future common ERP system. This is where ETL can be the solution.
ETL is a data integration process consisting of the following 3 steps:
- Extracting data
- Transform data
- Load data
Use cases for ETL tools (or ELT – which is primarily used on cloud technologies like Azure) involving data migration, cleansing and validating data could be:
- Data consolidation when acquiring companies
- A company wanting to upgrade existing systems
- Improving processes by data cleansing, validation and enrichment to get higher data quality
- Automation of repetitive data imports/transformation tasks which can help in reducing human errors and reduce cost
In the video EY describe an ETL process and illustrate through an example how data from legacy source ERP-systems can be prepared and loaded into a new ERP-systems.
Summary
With this you will get an introduction to data migration with use of ETL processes and tools. The video shows the process of extracting data, transforming and loading data.