The invention belongs to the technical field of data
synchronism, and particularly discloses a data
synchronism ETL (
Extract Transform Load)
system. The data
synchronism ETL
system comprises the following function modules: a context parameter configuration module, a synchronous
interface definition module, a synchronous script generation module, a
workflow configuration module, a data synchronism core module and a log and prewarning module, wherein the context parameter configuration module, the synchronous
interface definition module and the synchronous script generation module are basic modules and are operated according to the sequence of the modules to generate a script; the
workflow configuration module mainly plays the role of a dispatching center, and configures the script in a
workflow to realize parallel or serial execution, parallel progress amount, and what time or condition a task is triggered; when anomaly or an error task occurs in the execution steps, the log and prewarning module captures an error reason, and informs
system management personnel of the error reason. The data synchronism ETL system is provided with a bidirectional synchronism mechanism, and is capable of supporting data sources configured with
multiple context names and accessing multiple environments, the coverage of the synchronism method is wide, meanwhile, a complicated user-defined synchronism method is supported, and the expansibility is stronger.