The invention discloses a universal ETL tool process model generation method based on workflow. Abstraction is conducted based on an ETL conceptual model, control of whole ETL and regular execution and dispatching of tasks are completed, the ETL model based on the workflow is built, a directed graph of an ETL process is built based on the ETL model, and through eight State transformation modes of integration transformation, decomposition, mergence, serialization, parallelization, restore point addition, division and replication, the ETL process is transformed into a new ETL process with a higher execution efficiency through appropriate transformation. According to the ETL system conceptual model different from traditional ETL models based on the workflow, steps of underlying concrete data extraction, transformation and loading are shielded, and when business is changed, a user only needs to modify an ETL flow chart. The development efficiency is greatly improved, the development cost is reduced, and popularization of data warehouses and data integration are really achieved.