Building a Custom ERP Integration
A European manufacturing leader faced a common challenge: their sales team lived in HubSpot, but their production and inventory data were locked in a legacy SAP system. Manual data entry was leading to errors and delayed order fulfillment.
The Challenge
- Legacy API: The SAP instance used an older SOAP API with strict security requirements.
- Real-time Requirements: Sales needed to see stock levels instantly before promising delivery dates.
- Bidirectional Flow: Orders created in HubSpot needed to trigger production in SAP, and status updates needed to flow back.
The Solution
We architected a custom middleware layer using Node.js and AWS Lambda.
- Secure Proxy: We built a secure gateway to communicate with the legacy SAP SOAP API.
- Webhooks & Polling: Used HubSpot webhooks for instant order sync and scheduled polling for inventory updates.
- CRM Extensions: Built custom UI cards in HubSpot that show real-time production status for each deal.
The Result
- 100% Automation: Eliminated manual order entry.
- 48h Faster Fulfillment: Orders hit the factory floor immediately.
- Data Integrity: Zero discrepancies between sales and production records.
Need to connect your legacy stack to HubSpot? Let's talk.