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."It is a scalable solution."
"It runs like an appliance and has tremendous throughput."
"The Cloud Console for monitoring and troubleshooting data operations."
"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."
"Easy integration with Salesforce"
"Jitterbit provides the ability to quickly map data between files and databases."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"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."
"It has improved our data integration capabilities."
"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."
"The amount of data that it loads and processes is good."
"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."
"The abstraction is quite good."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"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."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Looping through complex data structures can be difficult."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"The initial setup can be a little bit difficult."
"Its API management capabilities need improvement."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."
"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."
"I would like to see more improvements with AS400 DB2."
"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."
"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."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"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."
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.