The invention discloses a visual multi-
data source ETL tool and belongs to the technical field of
visualization of ETL tools. The ETL tool is easy to synchronize
business data to a
target database, sothat a user can conveniently perform
online business analysis and
visualization on the
business data without
programming. The method comprises the steps of S1, connecting various data sources; S2, obtaining a source table
SQL of the
data source library through configuration of a table structure or field of the source
database and an ETL tool; S3, optimizing the source table
SQL, obtaining a plurality of pieces of
data source data after the source table
SQL is optimized, and injecting the data
source data into a target table of an ODS target
library; and S4, respectively scheduling the data source, scheduling
task management, scheduling task execution condition and scheduling OSD
list management from the target table of the ODS target
library, thereby facilitating the user to perform
online business analysis on the
business data. The method is simple and easy to learn.