Pentaho Data Integration and Analytics Reviews

• 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.

• 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.

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

I've used it for 4.5 years.

We've had no issues with deployment.

We've had no issues with stability.

We've had no issues with scalability.

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

For Pentaho, the initial setup is very straightforward.

We did it in-house.

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

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.

Data transformation within Pentaho is a nice feature that they have and that I value.

Integration between databases and data import for a BI solution.

I would like to see more improvements with AS400 DB2. I journalled the tables/instance and the data migration is too slow if I compare it with other databases.

There were no issues with the deployment.

Until now, the stability of Pentaho is great. I've already tested various scenarios and I didn't feel a loss of performance.

There have been no issues so far in scaling the product.

I used self-learning to implement it and found that the tool is very easy to understand. For some things, I looked at YouTube videos for conceptual ideas during the planning phase.

I did it myself.

• Fast
• Easy to learn and then teach to our team
• It integrates with everything on market

We never used a data integration or BI platform before, and struggled with lots of Excel spreadsheets and CSV files. So when we first used Pentaho to automate a data-integration flow, we were stunned with how fast and how easy it was. We are very productive today thanks to that piece of software integration our data and the platform serving the processed data to our users.

An easier upgrade process for community tools would be nice. They also need to update the ad-hoc reports tool, as the one available is outdated. To get round this, we are using Excel as the output for some reports.

For more then 4 year

Upgrading the bi-platform that is a little pain, but the rest is easy to use and to set-up.

There have been no issues with the stability.

There have been no issues with the scalability.

We use only the community edition, so we only consult the internet for help. There is a strong community of users all over the world. Here in Brazil, the e-mail list is very helpful.

We have performed a lot of setups since we started using Pentaho, and there have been no issues there.