We performed a comparison between Informatica Cloud Data Integration and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Informatica Cloud Data Integration is stable."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"The user interface which is very easy to use if we have any problems to solve."
"Informatica Cloud Data Integration is stable."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"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."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"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."
"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 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."
"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 way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"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."
"The current features are a bit complicated, and we need to write big scripts and test."
"I would like to see support for more data sources."
"It would be helpful if there was a GenAI feature integrated into the system, especially regarding the data quality."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."
"There may be some types of limitations with the performance."
"One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."
"The cloud version could be better in terms of pricing."
"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."
"I would like to see improvements made for real-time data processing."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data 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."
"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 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."
"The product needs more plugins."
More Informatica Cloud Data Integration Pricing and Cost Advice →
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Informatica Cloud Data Integration is ranked 5th in Cloud Data Integration with 40 reviews while Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews. Informatica Cloud Data Integration is rated 7.8, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Informatica Cloud Data Integration writes "A stable, scalable, and user-friendly solution". 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". Informatica Cloud Data Integration is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Fivetran and Mule Anypoint Platform, 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 Informatica Cloud Data Integration vs. Pentaho Data Integration and Analytics report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.