I want to share our implementation of real-time order status synchronization between our ERP system and Salesforce CRM using Mendix Integration Hub. Before this implementation, our sales team had to manually check the ERP system for order status updates, leading to delayed customer responses and frustrated clients.
We built an event-driven integration that automatically pushes order status changes from the ERP to Salesforce within seconds of the change occurring. This has dramatically improved our customer service response times and reduced the manual workload on our sales team.
The solution uses Mendix 9.24’s Integration Hub with REST API connectors to both systems, and includes monitoring to track sync latency. I’ll share the architecture approach and some key lessons learned from getting this running in production.
We’re using Microsoft Dynamics 365 for our ERP. For event triggers, we leveraged Dynamics’ webhook capability which fires HTTP callbacks when order records change. The webhook posts to a Mendix REST endpoint, which then processes the change and forwards to Salesforce. For SAP, you might need to implement a change document reader that polls for new changes, or use SAP Event Mesh if you have access to it.
This sounds like exactly what we need. What ERP system are you using, and how did you set up the event triggers? We’re on SAP and struggling with the event mechanism - SAP can generate change documents but getting them to trigger external integrations reliably has been challenging.
I’m also interested in the monitoring aspect. Do you have dashboards showing sync status? And how do you handle conflicts - what if someone updates the order in Salesforce while an ERP update is in flight?