Synchronize Access Records to Third-Party Database

You can enable synchronization function to apply the access records of specified resources from HikCentral Professional to the third-party database automatically.

1. Select Data Interchange on the left navigation bar.
2. Switch on Data Interchange.
3. Click Add and select the resource(s) for access records synchronization.
   Note

   • For card readers, you should also select a direction when adding them. Or you can select the added card readers and click Set Direction (In/Out) of Attendance Check Point to batch select directions for them.

   • Click in the Operation column to delete the resource or click Delete All to delete all added resources.

   • Select the added resource(s) and click Synchronize Event and set the time range for events to be synchronized from devices.

4. Select the encoding format of data interchange.
5. Optional: Check Do Not Push Failed Records.

   The failed records will not be pushed to the third-party system.

6. Select Database Synchronization.
7. Optional: Switch on Auto Push Failed Record to select the push mode.

   Push at Fixed Time

   The failed record will be pushed at the time you set.

   Push at Fixed Interval

   The failed record will be pushed according to the interval you set.

8. Optional: Select a database type.
9. Set the required parameters of the third-party database, including server IP address or domain name, server port, database name, user name, and password.
10. Click Test Connection to test whether database can be connected.
11. Set table parameters of database table and table fields according to the actual configurations.
    1. Enter the table name of the third-party database.
    2. Enter the mode of the third-party database.
    3. Set the mapped table fields between the HikCentral Professional and the third-party database.
    4. Optional: Click Customize Items to Display to select the items to be displayed in the table.
12. Click Save.

    A window will pop up and you can choose to push the test data now or later.

13. Optional: Click Quick Diagnosis in the top right corner to quickly diagnose the settings and the function.
    Note

    If there are errors found, you can export the failed data for checking.