Zoho–Sage 100 Sync Bridge

I need a reliable integration that lets Zoho Creator and our on-premise Sage 100 instance talk to each other automatically. The scope is focused on invoices and payments only, and the data must move in both directions so whichever system is updated first becomes the source of truth. An overnight (once-per-day) schedule is sufficient as long as it can be triggered manually when required.

Sage 100 is installed on a Windows server inside our network; Zoho Creator is, of course, cloud-based. You may leverage the Sage 100 SDK, Web Services, ODBC, or a lightweight middleware layer—whatever delivers a secure, authenticated connection without leaving data exposed. Likewise, Deluge scripts, Zoho Creator APIs, or a small Node/Python service are all acceptable on the Zoho side as long as the final solution is maintainable by our internal IT team.

Key points I care about:
• Accurate bi-directional sync of invoice headers, line items, payment status, and references.
• Automatic daily run plus a simple way for staff to force a sync on demand.
• Clear error handling with logs we can review.
• Deployment and hand-off documentation so we can move the integration if we migrate servers later.

You will receive VPN access to the Sage 100 server, test company databases, and a Zoho Creator sandbox app as soon as an NDA is in place. Send along any questions about field mapping or security constraints; I’m happy to clarify early so we both avoid rework.