We performed a comparison between Jitterbit Harmony and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Jitterbit provides the ability to quickly map data between files and databases."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"The Cloud Console for monitoring and troubleshooting data operations."
"It is a scalable solution."
"It is very easy to build integrations and processes to pull and push data."
"Easy integration with Salesforce"
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"It runs like an appliance and has tremendous throughput."
"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."
"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."
"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."
"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"The initial setup can be a little bit difficult."
"I would like the ability to offer a dedicated cloud version for security."
"Sometimes additional connectors are needed."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Looping through complex data structures can be difficult."
"Its API management capabilities need improvement."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"One thing that I don't like, just a little, is the backward compatibility."
"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."
"The product needs more plugins."
"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."
"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."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"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."
"If you develop it on MacBook, it'll be quite a hassle."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Jitterbit Harmony is ranked 35th in Data Integration with 13 reviews while Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews. Jitterbit Harmony is rated 8.6, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Jitterbit Harmony writes "An easy-to-setup solution with good stability ". 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". Jitterbit Harmony is most compared with MuleSoft Composer, Azure Data Factory, Microsoft Azure Logic Apps, Mule Anypoint Platform and SnapLogic, 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 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.