Pentaho Data Integration and Analytics Reviews

Name: Pentaho Data Integration and Analytics
Brand: Hitachi Vantara
Rating: 4 (48 reviews)

4.0 out of 5

48 reviews
94% willing to recommend

1,177 followers

What is Pentaho Data Integration and Analytics?UNIXBusinessApplication
Price:

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Get the Pentaho Data Integration and Analytics Buyer's Guide and find out what your peers are saying about Pentaho Data Integration and Analytics, Azure Data Factory, Informatica PowerCenter and more!

Pentaho Data Integration and Analytics is the #16 ranked solution in top Data Integration Tools. PeerSpot users give Pentaho Data Integration and Analytics an average rating of 8.0 out of 10. Pentaho Data Integration and Analytics is most commonly compared to Azure Data Factory: Pentaho Data Integration and Analytics vs Azure Data Factory. Pentaho Data Integration and Analytics is popular among the large enterprise segment, accounting for 68% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 19% of all views.

Buyer's Guide

Pentaho Data Integration and Analytics

March 2024

Get the report

Helped 767,319 peers since 2012

Featured reviews

Jacopo Zaccariotto

Head of Data Engineering at InfoCert

Apr 5, 2022

It's difficult to use custom code. Implementing a pipeline with pre-built blocks is straightforward, but it's harder to insert custom code inside the pre-built blocks. The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode. Repository management is also a shortcoming, but I'm not sure if that's just a limitation of the free version. I'm not sure if Pentaho can use an external repository. It's a flat-file repository inside a virtual machine. Back in the day, we would want to deploy this repository on a database. Pentaho's data management covers ingestion and insights but I'm not sure if it's end-to-end management—at least not in the free version we are using—because some of the intermediate steps are missing, like data cataloging and data governance features. This is the weak spot of our Pentaho version.

Read full review

Ryan Ferdon

Senior Data Engineer at Burgiss

Mar 24, 2022

If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was. It was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.

Read full review

Dale Bloom

Credit Risk Analytics Manager at MarketAxess

Jan 20, 2022

I'm at the early stages with Lumada, and I have been using the documentation quite a bit. The support has definitely been critical right now in terms of trying to find out more about the architectural elements that need to go in for pushing the Enterprise edition. I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics. I also appreciate the fact that it's not one of the low-code/no-code solutions. You can put as much JavaScript or another code into it as you want, and that makes it a really powerful tool.

Read full review

Pentaho Data Integration and Analytics market share

As of March 2024, the market share of Pentaho Data Integration and Analytics in the Data Integration category stands at 1.4%, marking an increase of 477.8% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Data Integration

Key learnings from peers

Valuable Features

"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."
"The abstraction is quite good."

Room for Improvement

"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."
"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."
"If you develop it on MacBook, it'll be quite a hassle."

Pricing

"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."
"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use.I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case.We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Pentaho Data Integration and Analytics Buyer's Guide for additional reliable information.