Advantages of Clover ETL (Why Clover ETL?)

CloverDX Platform
1

Hello,

we are looking now to choice (to decide) which ETL- Software is the best one for our needs.

We have to process a big amount of data (e.g. sort, compare of two or more files bigger then 1-2 GB with many million records).

In addition to the “classic” ETL- functions we need the possibilities to define a powerful compare between two or more files and/ or database- tables and to define a logic considering different cases of the compare- result.

Possibly BI (business intelligence) functions (OLAP, Data- Mining, …) will be interesting too.

At the moment we are considering Clover ETL and the solutions of Pentaho (http://www.pentaho.com/, http://www.pentaho.com/products/data_integration/) (open source).

  1. I have the feeling that Clover ETL has some advantages, but I am not sure. Can you help me, if you know pentaho (e.g. pentaho Kettle http://www.pentaho.com/products/data_integration/)
  2. Can I use Clover ETL with success without Clover GUI too?

Thank you in advance!

2

I can’t tell you whether Clover is Better than Pentahoo - or I can say it but I am a bit biased :wink:

Clover uses different approach than Pentahoo. Clover is strictly component based. Each component runs as independent process - like data flow programming is teaching us.

You can use the Clover engine (CloverETL) without GUI. GUI just makes it nicer experience. But there were times where no GUI was on horizont and the only way how to put together transformation was old good text editor.

Clover’s functionality can be easily extended by creating new components which once coded become 1st class citizens of the environment - can instantly cooperate with all the others.

3

We have conducted a comprehensive benchmark on CloverETL, Talend and Pentaho which show Clover is the fastest out of these three:
http://www.cloveretl.org/_upload/clover-etl/Comparison%20CloverETL%20vs%20Talend%20and%20Pentaho.pdf