We performed a comparison between Boomi AtomSphere Integration, Informatica Cloud Data Integration, 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)."Low-code development is the most valuable feature."
"We work on the flow between systems and the most valuable features for that purpose are the mapping of data, interface mapping, and data integration."
"The most valuable feature of the solution is its monitoring part to debug certain issues and find problems."
"I really appreciate the on-the-go access through the browser and the B2B integration."
"The product's initial setup phase was easy."
"The best features are that it is a cloud-based and a multi-tenant tool."
"Very effective with its drag-and-drop feature."
"It is easy to learn and implement."
"The product improves data quality."
"Informatica Cloud Data Integration is stable."
"Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API. The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables."
"The solution has the best feature for parameterization."
"It is quite easy to use and flexible."
"The most valuable features of the solution are pushdown, optimization, and partitioning, which can be used for frequent data loading, especially when we have a huge data volume in our company."
"I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"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 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."
"Provides a good open source option."
"It's very simple compared to other products out there."
"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."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"The solution has a free to use community version."
"There should be more scripting possibilities."
"It crashes if we run high-volume integration."
"There is no validation in the mapping profile custom scripting, such as IntelliSense or advanced error checking."
"Documentation could be improved."
"In my experience, I haven't encountered any major issues with the tool. However, there could be a learning curve for new users, especially depending on which tool you're using. For example, I've used MuleSoft in the past, which is more code-oriented and requires knowledge of Java. Transitioning to Boomi AtomSphere Integration took me a couple of months because of differences in terminology."
"The high price of the solution is an area of concern where improvements are required."
"They should create a custom connector option. With this, they could improve where the user can create the connector, based on their usage."
"Have to create some of our own pre-built connectors."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"The error information provided is not informative, as compared to Power Center."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."
"The integration process is not easy."
"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"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."
"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."
"One thing that I don't like, just a little, is the backward compatibility."
"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."
"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."
More Informatica Cloud Data Integration Pricing and Cost Advice →
More Pentaho Data Integration and Analytics Pricing and Cost Advice →