Overview
Imprint Engine required a seamless and automated way to transfer and sync data between its internal Product Information Management (PIM) system and Acumatica, the company’s hosted ERP system. We developed the Data Transfer Service (DTS) — a set of serverless functions enabling reliable and efficient data synchronization.
Project Scope
DTS was built as a set of serverless functions with these core components:
- GraphQL/Hasura Integration - Accessing and updating PIM data through a GraphQL API layer powered by Hasura.
- Acumatica REST API Integration - Communicating with Acumatica ERP via REST to push and pull synchronized data.
- Netlify Serverless Functions - Hosting DTS on Netlify for automatic scaling, lower infrastructure overhead, and improved reliability.
- Automated Event-Driven Synchronization - Triggering data transfers automatically to maintain consistency between systems.
Challenges
Prior to implementing DTS, data transfer between PIM and Acumatica was handled manually or through inefficient scripts, leading to:
- Data inconsistencies between platforms
- High manual intervention for updates and synchronization
- Increased operational overhead
- Lack of real-time updates between systems
Solution
- Automated Synchronization — DTS enables event-driven synchronization between PIM and Acumatica, ensuring data consistency.
- Netlify Serverless Functions — Hosting on Netlify provides automatic scaling, reduced infrastructure maintenance, and improved reliability.
- Acumatica Integration — DTS communicates with Acumatica through its REST API.
- GraphQL/Hasura Integration — PIM is accessed via GraphQL to support efficient data retrieval and updates.
Results
- Enhanced Data Integrity — Automated data sync eliminated inconsistencies and improved accuracy
- Reduced Manual Effort — Automated transfers drastically reduced the need for manual updates
- Improved Efficiency — Real-time data availability led to faster decision-making
- Scalability & Reliability — Serverless architecture handles increased data volumes efficiently
Conclusion
By implementing DTS, Acts Media helped Imprint Engine bridge the gap between PIM and Acumatica with a reliable, automated synchronization layer. The solution improved operational efficiency, reduced manual work, and created a scalable foundation for future integrations.
Have a similar project?
Let's talk about how we can build something like this for your business.