Hardware Performance Evaluation of Freeware ETL Tools

The extract, transform, load (ETL) process is becoming more important as larger and larger amounts of data are created daily. In this work, ETL software products that can load data, conduct transformations on it, and either save or upload that data to cloud databases were tested. The selected software is either open source or freely available and two datasets have been tested to create aggregated performance evaluations on a local machine. The tested measures are processor use, available memory amount, and committed memory amount. Analysis of the results has determined that Pentaho Kettle and CloverDX are the most hardware-efficient ETL software tested after comparing the results with baseline values of the test computer. Talend Open Studio performed as the least efficient among the tools.