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."The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is a scalable solution."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"It is very easy to build integrations and processes to pull and push data."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"Jitterbit provides the ability to quickly map data between files and databases."
"It runs like an appliance and has tremendous throughput."
"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."
"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."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."
"The abstraction is quite good."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
"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 would like the ability to offer a dedicated cloud version for security."
"Its API management capabilities need improvement."
"Looping through complex data structures can be difficult."
"The initial setup can be a little bit difficult."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Sometimes additional connectors are needed."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"I would like to see more improvements with AS400 DB2."
"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."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud."
"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"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."
"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."
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.