Real-Time ESSL Data Sync
Budget: ₹600 – ₹1,500 INR
I need an automated bridge that pulls attendance logs from my ESSL X2008 biometric punch machine and inserts them directly into our on-premise SQL Server database the moment each punch is recorded.
The solution must:
• Connect reliably to the X2008 using the official ESSL SDK or any proven alternative.
• Stream new punch events in real time—no manual export or scheduled batch jobs.
• Map every field the device provides (employee code, punch time, in/out flag, etc.) to the corresponding columns already present in my SQL Server table.
• Handle network interruptions gracefully and guarantee no duplicate or missed records.
• Include a simple configuration file or UI where I can change IP, port, or SQL Server credentials without editing code.
Acceptance will be based on watching a live punch propagate to SQL Server within a few seconds and seeing historical punches back-filled accurately during the initial sync. Please package the finished code, any libraries or drivers used, and concise setup instructions so I can redeploy it on another Windows machine if needed.
The solution must:
• Connect reliably to the X2008 using the official ESSL SDK or any proven alternative.
• Stream new punch events in real time—no manual export or scheduled batch jobs.
• Map every field the device provides (employee code, punch time, in/out flag, etc.) to the corresponding columns already present in my SQL Server table.
• Handle network interruptions gracefully and guarantee no duplicate or missed records.
• Include a simple configuration file or UI where I can change IP, port, or SQL Server credentials without editing code.
Acceptance will be based on watching a live punch propagate to SQL Server within a few seconds and seeing historical punches back-filled accurately during the initial sync. Please package the finished code, any libraries or drivers used, and concise setup instructions so I can redeploy it on another Windows machine if needed.
Related categories:
.NET
SQL
C# Programming
Software Development
Database Programming
Microsoft SQL Server
Database Management