Research on Data Integration Based on Kettle
Xie Suping, Chen Huaichu, Cai Wuyue, Zhen Wang · 2018
Kettle is a powerful ETL tool for data integration. We implement kettle in the data integration and sharing of the basic database. The key issues of ETL implementation include multi-data source data consolidation and data incremental update. We put forward the “merge join” and “database join” solutions for multi-data source data consolidation and the “timestamps”, “triggers”, “Database log data” and “Data comparison” solution for data incremental update issue.