Pentaho Review

It enabled seamless data movement from one system to another. ​Debugging and logging needs to improve.

Valuable Features

Transformations. The wide range of transformations that are available in product suite, enable me to do data cleaning, transformation and mapping. I have used Pentaho mostly for ETL purposes.

Improvements to My Organization

Pentaho was used for data massaging in a system integration project. It enabled seamless data movement from one system to another. The biggest advantage of using this tool was that it support a wide range of input and output formats

Room for Improvement

Debugging and logging needs to improve. Not all the time debugging gives the accurate picture of what is going wrong with the jobs or transformations.

Use of Solution

I've been using it for one year.

Deployment Issues

We've had no issues deploying it.

Stability Issues

It's been stable.

Scalability Issues

Data type mismatch issues causes a lot of error in the transformations, which I believe at times make it difficult to scale. For example in many transformations you have to mention the data type of the data and if the input file changes the data type, these transformation also needs to be updated. Hence one data type change in the input file have cascading effects

Customer Service and Technical Support

I've never had to use it, but they do have a strong online community.

Previous Solutions

There was no previous solution in place.

Initial Setup

It was straightforward, as there was not much of configuration was involved.

Implementation Team

I was the vendor team who implemented this solution for the client.


It's difficult to predict the ROI as it was just a component of the system.

Other Advice

The tool is easy to implement, but it needs technical acumen to do so. In other words although it look like a simple drag and drop kind of tool, it can be fairly complex.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email