eSSL-Zoho People Attendance Sync

I already have an eSSL Jupiter device logging punches into Smart Office’s MSSQL back-end. What I now need is a seamless bridge that streams those attendance records straight into Zoho People, in real time, through the ZAttendance plugin running on my Apache Tomcat server.

Scope of the work
• Connect to the existing MSSQL instance, detect new attendance rows and push them instantly to Zoho People.
• Use the ZAttendance Zoho plugin on Tomcat as the integration layer; configure, customise if needed, and document every step so the sync survives updates or server reboots.
• Make sure the check-in and check-out timestamps are mapped accurately along with the relevant employee ID that Zoho expects.
• Validate end-to-end by producing live punches on the device and confirming they appear in Zoho People with no noticeable delay.

Acceptance criteria
1. A punch recorded on the eSSL terminal shows in the Zoho People attendance list within seconds.
2. Check-in and check-out times remain unchanged during transit.
3. The solution auto-starts with Tomcat and includes clear rollback and manual trigger instructions.

If you have prior experience with eSSL or similar biometric feeds, MSSQL, and Tomcat-based plugins, your insight will be valuable.