We performed a comparison between Boomi AtomSphere Integration, Jitterbit Harmony , and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about MuleSoft, Microsoft, Oracle and others in Integration Platform as a Service (iPaaS)."This solution has a user-friendly interface and very good documentation with solutions that helped us in working with the tool efficiently."
"The best features are that it is a cloud-based and a multi-tenant tool."
"Boomi AtomSphere Integration is stable."
"Extremely flexible for any kind of integration between systems."
"The solution has a lot of connectors, which is quite helpful."
"Very effective with its drag-and-drop feature."
"Low-code development is the most valuable feature."
"It has been a stable product."
"Easy integration with Salesforce"
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"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."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It runs like an appliance and has tremendous throughput."
"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."
"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."
"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."
"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"Provides a good open source option."
"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."
"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 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."
"They should create a custom connector option. With this, they could improve where the user can create the connector, based on their usage."
"We would like to see more involvement between Dell Boomi and the end-users to help improve the customer experience."
"They need to introduce more configurable functions to remove scripting or coding. Scripting should be minimized. It should have exhaustive functions. Currently, it lacks in this aspect."
"There is no validation in the mapping profile custom scripting, such as IntelliSense or advanced error checking."
"Boomi AtomSphere Integration is not yet exposed to the world as a good product owing to certain shortcomings in the area of marketing where improvements are required."
"The solution is complex. There's a few items and features that are hard to understand. They should work to simplify the functionality so new users don't struggle."
"The high price of the solution is an area of concern where improvements are required."
"There are still some areas that need improvement. For example, when updates are going on, the product becomes very slow."
"Looping through complex data structures can be difficult."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"Its API management capabilities need improvement."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"The initial setup can be a little bit difficult."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Sometimes additional connectors are needed."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"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."
"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."
"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."
"I would like to see more improvements with AS400 DB2."
"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."
"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."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
"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."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →