Integration of source systems for implementing unified sales and operation planning
Matasma engaged with one of the leading automotive player to integrate their source systems such as SAP, CRM, PLM and Dealer Management Systems for implementing unified sales and operations planning
Challenges
- 50+ files that needs to be loaded into planning systems for effective decision making process
- 20+ systems from SAP, CRM, PLM and Dealer Management Systems to be integrated into planning system
- Errors in data transformations due to manual data transformations before loading into systems
- Scalability Challenge due to 100% information processing server utilization between 12 AM to 9 AM
Our Approach
- Integrated the source systems to an intermediate SFTP data storage systems
- Integrated SFTP servers to the Anaplan using information as ETL systems
- Optimized the existing task flows and data transformation steps to optimally utilize the informatica resources
Delivered Outcomes
- Scheduled automations from source to target systems through informatica IICS
- Unlocked 30% resources for more transformation and integration capability between source and target systems
- Real-time visibility of the integrations and data reconciliations between source and target systems
Let’s Transform Your Business Together
Have a challenge you need solved? Reach out to us today!
Stay in the loop and sign up for the Matasma newsletter.