The present invention discloses a system and a method for extraction, transformation and distribution of data increments. The system comprises an extraction transformation designer, an extraction transformation actuator and an an extraction transformation monitoring unit, wherein the extraction transformation designer is used for defining a data source of a source database, designing a transformation rule, then defining a data target, and packaging the designed transformation rule into a KTR file; the extraction transformation actuator is used for capturing incremental data of the source database in real time, analyzing the source of the incremental data, transmitting the incremental data to a server which analyzes the obtained information and selectively calls the corresponding transformation rule to perform transformation processing, the KTR file is executed in batches; and the extraction transformation monitoring unit can monitor the running condition of the rule and can control the start and the stop of data synchronization. A technology combining a log analysis technology and ETL is adopted, so that the functions of capturing the incremental data of the source database in real time, performing transformation processing on the incremental data, and finally loading the incremental data into a target database in a quasi-realtime manner are realized.