SQL User Sync for HikCentral Professional

Return

Solutions

By Partner

Joint-value Solutions

SQL User Sync for HikCentral Professional

Automated personnel synchronization from SQL-based third-party systems to HikCentral

Solution Type: Access Control Platform, ERP, HRMS (Human Resource Management System), SAP, Time & Attendance

Targeted Industries: Banking and Finance | Healthcare | Education | Government Facilities

Solution Description

This solution automates personnel synchronization between HikCentral Professional and third-party SQL-based systems such as HR, payroll, ERP, or time attendance platforms. A Python middleware script reads user records from a SQL view, maps departments to HikCentral organizations, and uses HikCentral OpenAPI to add, update, or delete users. The solution includes a sync log table, retry mechanism, and Windows Task Scheduler automation.

The application of this solution should be subject to the applicable local laws and regulations.

User Benefits

Automatically synchronizes personnel from SQL-based third-party systems to HikCentral Professional
Reduces manual user creation, update, and deletion work for system administrators
Keeps HikCentral user information aligned with the source HR or ERP system
Supports automatic update detection for employee names and department changes
Maintains a synchronization log with retry handling for failed records and troubleshooting

Key Features

SQL view-based employee data extraction from MenaITech or any compatible third-party database
HikCentral OpenAPI integration for add, update, and delete person operations
Department-to-HikCentral organization mapping using orgIndexCode exported from HikCentral
Hash-based change detection to identify updated employee names, departments, or status values
Automated periodic execution using Windows Task Scheduler with log file output

Solution Architecture

The solution uses a Python middleware script to read user data from a third-party SQL view via ODBC, check active/inactive status and sync logs, then call HikCentral Professional OpenAPI over HTTPS to add, update, or delete users. A sync log table tracks status, errors, retries, and automation through Windows Task Scheduler.

Hikvision Product Compatibility

Access Control

HikCentral Professional

Technical Details

Partner Product Name: HCP SQL Based System Integration

Partner Product Version: V1.x

Hikvision Product Models and Firmware Versions: HCP (3.0.1 and later)

Integration Protocol: HikCentral Professional OpenAPI

Availability

Regions: Middle East & North Africa

Languages: English

About Shabkati Network Solutions

Shabkati Network Solutions is a technology and networking company providing integrated ELV, security, networking, access control, CCTV, and software integration solutions. The company supports customers with system design, implementation, configuration, troubleshooting, and integration between Hikvision platforms and third-party systems.

Website: https://shabkati.com

Please contact us with any questions or if you are interested in this solution.

Contact

How It Works

Description: This screenshot shows the main integration folder C:\HCP_Integration, which contains the Python synchronization script, the HikCentral organization mapping CSV file, the batch file used for automation, and the generated sync log file. Explanation: All integration files are stored in one fixed path to make the solution easier to maintain, automate, and troubleshoot. The Task Scheduler runs the batch file from this folder, and the script reads the required CSV mapping file and writes logs in the same location

Description: This screenshot shows the run_hcp_sync.bat file used to execute the Python synchronization script automatically. Explanation: The batch file changes the command prompt encoding to UTF-8 to support Arabic names, moves to the integration folder, runs the Python script, and redirects all execution results to the sync_log.txt file. This allows the integration process to run silently in the background while keeping a full execution history.

Description: This screenshot shows the sync_log.txt file generated after the scheduled script execution. Explanation: The log file records each script run, including SQL connection status, organization mapping loading, active employee count, add/update/delete results, skipped records, and any errors. This file is used for monitoring, troubleshooting, and confirming that the automated synchronization is running successfully.

An email containing the license key file will be sent to you shortly. If you do not see the email in your inbox, please check your SPAM or JUNK folder.

Cancel

Solution Doc Application Form