Export of events to third-party systems

Ask a question

Sigur offers an option to export own events to a third-party system deployed in your company. 

You might need to export data to analyze employee movements in a custom visitor management system or time & attendance system as well as for payment services or non-standard reporting forms.

HOW IT WORKS AND HOW IT IS USED

Events recorded in the ACS can be then used by other systems.
Automated transfer of ACS events to another system is fast and error-proof and will help you save on manual data input.

DATA TRANSFER VIA SYNCHRONIZATION

This option is convenient when you are dealing with databases using a standard ODBC driver, such as MS SQL, Oracle, MySQL, Firebird, PostgreSQL, dBase, MS Access, Paradox, etc.

In this case, no programming skills are needed since all settings are configured at the Sigur server, which will, according to the set synchronization schedule, export all events to the specified external database.

Export of every event is implemented as an SQL query executed on the external database. The text of the query, including placeholders for event parameters, have flexible configuration options.

Besides, you can choose what kind of events to export.

DATA TRANSFER VIA AN HTTP REQUEST

This option is suitable for web developers and can be used to export events to a platform, such as a website, where the employees’ attendance is tracked.

The interactions are implemented via HTTP(S) POST requests from the Sigur server. The external system serves as the recipient of these requests. The data are transferred in JSON format. The system supports HTTP and HTTPS protocols. HTTP authorization is also supported. HTTP requests can be sent directly or via HTTP proxy (with or without authorization).

In addition to access events, Sigur can send footage captured by IP cameras to a web server (if the option of saving footage to the ACS archive is enabled).

DIRECT CONNECTION TO THE PACS DATABASE

To gather the information about access events, you can connect and send requests directly to the ACS database. SQL queries are initiated by the external system and you will not need any extra efforts on the ACS side.

USING TCP TEXT PROTOCOL

A TCP server is launched on Sigur server side and a third-party system is connected to its dedicated port. Then, data exchange is initiated via a text protocol developed by Sigur.

This protocol provides extended functionality and therefore can be used not only to pull events.

Please note that your external system must support this protocol as well. To learn more, please contact the Sigur support team.

You can obtain the following information from the ACS via this interface:

  • All access events in real time and from the ACS archive for any historical period
  • Any fields from the files of employees, visitors and vehicles
  • Information about the existing access/time zones

Receiving information about access events in real time can be particularly useful for payment services, specialized systems for fitness clubs and other paid access systems.