Pentaho Data Integration Review

It's open source so there's no concern for pricing and licensing, and we've deployed it with minimal hardware.

Valuable Features:

  • It has a nice GUI that anyone can learn to use in just a few days with minimal training.
  • It has great support for big data technologies; Pentaho 5.3 comes with support for HBase, Pig, Oozie, and Hadoop distribution support.

Improvements to My Organization:

  • It's an open-source tool, so you don't need to worry about licensing costs.
  • We've deployed it with very minimal hardware.
  • We have migrated one of the key project from Microsoft BI to Pentaho Data integration, this saved lot of money as well there were much improvement in performance as well.

Room for Improvement:

The rule executor step can be improved. It has one limitation: we cannot give it a dynamic file name in this step.

Use of Solution:

I've used it for 4.5 years.

Deployment Issues:

We've had no issues with deployment.

Stability Issues:

We've had no issues with stability.

Scalability Issues:

We've had no issues with scalability.

Previous Solutions:

We used MSBI and we switched to Pentaho Data Integration and it has saved us lot of money and time.

Initial Setup:

For Pentaho, the initial setup is very straightforward.

Implementation Team:

We did it in-house.

Cost and Licensing Advice:

Because it's open source, there's no issue of pricing or licensing.

Other Advice:

Use if for any data warehousing and migration projects. I love this tool and we can use it without spending a penny.

I would say this is the best ETL tool in the market, considering this is open source and ease to use, very nice GUI.

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