Efficient Data Migration from Legacy Systems to ERP: A Financial and Leasing Provider Case Study
Technology Category
- Application Infrastructure & Middleware - Data Exchange & Integration
- Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Functions
- Quality Assurance
Use Cases
- Personnel Tracking & Monitoring
- Visual Quality Detection
Services
- System Integration
- Testing & Certification
About The Customer
The customer in this case study is a major financial and leasing provider. They were dealing with the challenge of managing over 27 million records across two legacy systems. The presence of a large number of duplicate records was affecting their business operations and increasing their overhead costs. They were also facing compatibility issues among the legacy systems, platforms, and databases. The simultaneous running of both systems was causing slow processing speeds and necessitating an increase in staff. The company needed a solution that would not only migrate their data but also consolidate duplicate records and update and purge outdated or deficient data.
The Challenge
The company, a major financial and leasing provider, was grappling with the challenge of managing over 27 million records across two legacy systems - Microsoft Dynamics NAV and Target. The presence of a large number of duplicate records was affecting business operations and increasing overhead costs. The simultaneous running of both systems was causing slow processing speeds and necessitating an increase in staff. Furthermore, the company was facing compatibility issues among the legacy systems, platforms, and databases. The daily management of critical data assets was often met with these compatibility issues, further complicating the situation.
The Solution
To address these challenges, a detailed data migration solution was developed using CloverDX. The solution aimed to migrate all the data, consolidate duplicate records, and update and purge outdated or deficient data, causing minimal impact on business during the transition. The solution included built-in data cleansing checks and dedup capabilities. These data quality tools and a set of rules were used to filter outdated and inconsistent records, reducing the data volume by 25% before the migration began. After the cleansing process, the cleansed data set was enhanced with supplemental information from both units. The final data was then transferred into a new SAP ERP system, replacing the two outdated ones.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Goldcorp: Internet of Things Enables the Mine of the Future
Goldcorp is committed to responsible mining practices and maintaining maximum safety for its workers. At the same time, the firm is constantly exploring ways to improve the efficiency of its operations, extend the life of its assets, and control costs. Goldcorp needed technology that can maximize production efficiency by tracking all mining operations, keep employees safe with remote operations and monitoring of hazardous work areas and control production costs through better asset and site management.
Case Study
Rapid and Simple Installation Provides Access to Critical Data
The customer needed to monitor non-contact alignment and non-contact process temperature in different positions along a 100-meter production line. Space around the line is tight and operators and forklift trucks are passing by constantly. Installation of correctly routed cables from sensors back to the control station would have been expensive and would have taken too long and caused too much disruption to ongoing operations.
Case Study
Cisco Kinetic for Oil and Gas: Refineries and Plants
The plant manager and safety teams needed a solution that provided near real-time visibility of gas detection and personnel location, with easy to understand visualization and alerting dashboards. This would enable them to improve productivity through decreasing the time taken to start work, optimize evacuation route planning, and to meet critical staff safety and compliance goals.
Case Study
Real-Time IoT Tracking and Visualization Improve Manufacturing
Shimane Fujitsu, a wholly-owned subsidiary of Fujitsu and a leading manufacturer of business notebooks and tablets, set out to improve processes where factory inspections found product errors. Prioritizing product rework based on shipping date was challenging, and it caused Shimane Fujitsu to incur additional shipping fees. The company needed a way to collect data to better track the location of products in the rework cycle as well as monitor progress in real time. The collected data would also help process analysis for future improvements.
Case Study
Industry 4.0 at ALPLA: Enhancing Factory Efficiency with IoT
ALPLA, a global leader in packaging solutions, faced several challenges as the complexity of their production machinery increased. The need for highly trained specialists in each factory led to higher personnel costs, difficulties in recruiting experienced talent at each location, and costly personnel turnover. Furthermore, less experienced operators running the machines sub-optimally impacted resource consumption and overall equipment effectiveness (OEE). ALPLA also faced the challenge of monitoring visual inspection systems in every line of their plants, which was almost impossible to do manually. In 2016, ALPLA decided to use data from the 900 different types of embedded sensors in each factory to address these issues. However, their initial choice of SQL Server as the data store for the sensor data proved inadequate, as it was unable to cope with their data requirements.
Case Study
Digital Transformation of Atlanta Grout & Tile: An IoT Case Study
Atlanta Grout & Tile, a Tile, Stone & Grout restoration company based in Woodstock, Georgia, was facing challenges with its traditional business model. Despite steady growth over the years, the company was falling behind the web revolution and missing out on the opportunity to tap into a new consumer base. They were using independent software from different vendors for each of their department information and workforce management. This resulted in a lot of manual work on excel and the need to export/import data between different systems. This not only increased overhead costs but also slowed down their response to clients. The company also had to prepare numerous reports manually and lacked access to customer trends for effective business decision-making.
