The invention discloses a data extraction method based on ETL, relates to the field of data processing, in particular to a data extraction method based on ETL. The ETL-based data extraction method provided by the invention is used for efficiently and reliably extracting enterprise project visual management and control data. According to the method, under a distributed integrated environment of multi-system and multi-data-source extraction requirements, data extraction and data processing message notification manufacturing, and data extraction processing; the method has the following technicaleffects: 1, perceptibility of project visual management and control data extraction and analysis processing: rules can be flexibly configured or expanded to adapt to data extraction dynamic perceptualmessage transmission of different business systems and different relational data; 2, the resource property of project visual management and control data extraction and analysis processing: when a complex physical environment is subjected to data extraction and processing, dynamic scheduling of data extraction resources is carried out in a multi-distributed cluster environment.