The invention mainly provides an automatic synchronization method for a BI
system. The automatic synchronization method comprises the steps that a scheduling platform exports data to a
database regularly; starting a CDC monitoring service for log information of the
database, capturing change data of the scheduling task instance table, exporting task information parameters which are successfully executed, converting the task information parameters into interface data, and pushing the interface data to a
webhook service; after receiving interface data, the
webhook service transmits the interface data to a
shell script for judgment
processing, splices a curl command according to a project name and a table name configured by a BI
system, and pushes the curl command to a BI
system interface; and the BI system triggers a
data synchronization task after receiving the data. According to the technical scheme, the change of the
database is captured in real time, the BI system is triggered in time to synchronize the data, near-real-time updating of the data is achieved, the timeliness of
data analysis and display is improved, meanwhile, unnecessary resource waste is avoided, and the overall performance and efficiency of the system are improved.