Real-Time Person Data Sync for Access Control Systems (Suprema's Biostar X and dormakaba's Matrix Professional)
Budget: ₹12,500 – ₹37,500 INR
Both of my access-control platforms—System A (Suprema's Biostar X) and System B (dormakaba's Matrix Professional)—sit on the same Windows server and share a local MS SQL instance. Each exposes a REST API, yet today they operate in silos. I need a seamless, bi-directional integration so that any change to a person or employee record in one system is reflected in the other almost instantly.
Scope of the sync
• Core identity fields: name and unique ID
• Credential data: RFID card number and state
• Biometric assets: fingerprint templates
• Media: profile picture
• Security attributes: access-level permissions
Key requirements
1. Real-time operation (sub-second latency acceptable).
2. Conflict-resolution logic—latest change wins unless marked “locked.”
3. Robust logging of every API call and DB write for audit trails.
4. Graceful retry mechanism on network or API errors.
5. Delivered as well-documented integration service with unit tests and a simple configuration file (DB strings, API tokens, polling interval set to zero for push mode).
Acceptance criteria
• Create, update, or delete a record in System A; the same action appears in System B and vice-versa without manual refresh.
• Mismatch simulation (e.g., tampered RFID) triggers a log entry and e-mail alert.
• Full source code, setup script, and deployment instructions supplied.
If you have hands-on experience integrating REST-based access-control or HRMS platforms and can demonstrate a previous live sync, I’d like to hear how you would approach this and your estimated timeline.
Scope of the sync
• Core identity fields: name and unique ID
• Credential data: RFID card number and state
• Biometric assets: fingerprint templates
• Media: profile picture
• Security attributes: access-level permissions
Key requirements
1. Real-time operation (sub-second latency acceptable).
2. Conflict-resolution logic—latest change wins unless marked “locked.”
3. Robust logging of every API call and DB write for audit trails.
4. Graceful retry mechanism on network or API errors.
5. Delivered as well-documented integration service with unit tests and a simple configuration file (DB strings, API tokens, polling interval set to zero for push mode).
Acceptance criteria
• Create, update, or delete a record in System A; the same action appears in System B and vice-versa without manual refresh.
• Mismatch simulation (e.g., tampered RFID) triggers a log entry and e-mail alert.
• Full source code, setup script, and deployment instructions supplied.
If you have hands-on experience integrating REST-based access-control or HRMS platforms and can demonstrate a previous live sync, I’d like to hear how you would approach this and your estimated timeline.