We performed a comparison between Fivetran and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most important feature of the solution is its ability to build data pipelines in less time."
"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
"Fivetran's most valuable feature is replication."
"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"There's the general feature of the platform where it just makes it very easy to integrate different things, but I would say a specific difference is their integration of DBT,."
"The product is very easy to use and very easy to configure."
"The compare feature is the most valuable piece of it."
"Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
"Provides a good open source option."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"The abstraction is quite good."
"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."
"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 fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."
"It should have a few more monitoring functionalities."
"I would like Fivetran to implement additional resource monitoring and restriction policies."
"We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool."
"The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords. Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results."
"I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"The environment must be more development-friendly."
"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."
"The reporting definitely needs improvement. There are a lot of general, basic features that it doesn't have. A simple feature you would expect a reporting tool to have is the ability to search the repository for a report. It doesn't even have that capability. That's been a feature that we've been asking for since the beginning and it hasn't been implemented yet."
"I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking."
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."
"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"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."
"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."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Fivetran is ranked 13th in Data Integration with 19 reviews while Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews. Fivetran is rated 8.0, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Fivetran writes "Solution reduces time-to-value; high ROI". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Azure Data Factory, Oracle GoldenGate and Informatica Cloud Data Integration, whereas Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue. See our Fivetran vs. Pentaho Data Integration and Analytics report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.