Global Manufacturing Company
ERP Data Integration from Multiple Sources.
Overview
THE CHALLENGE
A global manufacturing company needed to merge all of the data from five organizations into one seamless application.
THE SOLUTION
Ollion designed a scalable ETL framework to collect and transform data from changing data sources.
THE OUTCOME
The client achieved significant cost savings by integrating the different data sources into a central hub.
The Challenge
Our client had five organizations that were combining into a single and upgraded instance of their ERP system. They required a data integration from multiple sources to merge all of the data from each organization into one seamless application that would allow for easier and quicker management analysis.
The Solution
Our team developed updates to underlying SQL stored procedures that allowed for the extraction of data from each new source. The data from the old ERP system was also migrated to reflect the new structure and values. As a result, the back-end reporting was updated to use the new source data without service interruptions.
The Outcome
The data integration from multiple sources into a central hub helped our client achieve significant cost savings. The new central hub allowed them to access all of the data from each organization, as well as see overall trends and problem areas at a holistic level. The new system was also helped to identify data quality issues with each new data source and fix these issues before they caused inaccurate reports.