A powerful ETL tool which is open source
Updated March 01, 2016

A powerful ETL tool which is open source

Yinghua Hu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version

5.0.1

Modules Used

  • kettle

Overall Satisfaction with Pentaho

Pentaho is used as main ETL tool in the data analytics team. It solves the problem of processing and populating financial and ads related data.
  • Populate relational database
  • Transform and clean data
  • Create periodic job and generate report
  • Aggregate data
  • It will be helpful to have modules supporting Google Adwords and Facebook API and Twilio API
  • It has "add constant", but does not have "multiply constant" module.
  • Unit transform module
Pentaho is more powerful with more functionality. Also it is Java based and is therefore platform independent.
Pentaho is free and powerful. It is user friendly and with ample documentation.
Pentaho is well suited for ETL processing and database population. It is less appropriate for visualization and analytics. Key question is the benefit it can bring and the cost and robustness.

Upgrading Pentaho

Yes - The new release is fully compatible with earlier release. There is no unexpected impact.