Which OpenSource ETL tool is easier to use & more agile?

Please notice this analysis is “vendor independent” and based on multiple clients experience

Which OpenSource ETL tool is easier to use & more agile?

talend

  1. Talend and Pentaho offers some of the most deployed Open Source ETL tools and used in several critical implementations.
  2. Talend and Pentaho have strong community support  ( 3 million downloads for Talend ), well known companies. Open Source Business Intelligence is  growing fast and real world applications are widespread.
  3. Talend Open Studio and Pentaho Kettle are  both user friendly, well documented and have a strong community support.  Talend Open Studio requires more initial effort to get started however  its great potential is highly appreciated from the beginning.
  4. The interpreted nature of Kettle makes it sometimes slower in some tasks compared to Talend.
  5. Talend is a single threading code generator Java (or Python for Mapreduce or Scala for Spark ) , Kettle uses a metadata driven multi-threaded engine. So  it’s your choice: either debug generated Java code (Talend) or debug a  graphical data flow (Kettle). Generated code is more preferable by most developers. 

     

    Which OpenSource ETL tool is easier to use & more agile?

Leave a Reply