We performed a comparison between Informatica PowerCenter and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"Deployment was simple and straightforward."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"The interface is very clean and clear."
"Once you have learned Informatica, it is very easy to use."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"Provides a good open source option."
"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."
"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."
"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."
"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 solution offers features for data integration and migration. Pentaho Data Integration and Analytics allows the integration of multiple data sources into one. The product is user-friendly and intuitive to use for almost any business."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"The initial setup is not straightforward. You need expertise to do it."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"The reputation of Informatica is that it is expensive."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"I would like to see improvements made for real-time data processing."
"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."
"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..."
"The product needs more plugins."
"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."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 49 reviews. Informatica PowerCenter is rated 8.0, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". 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 PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Pentaho Data Integration and Analytics is most compared with SSIS, Azure Data Factory, Oracle Data Integrator (ODI), Talend Open Studio and IBM InfoSphere DataStage. See our Informatica PowerCenter vs. Pentaho Data Integration and Analytics report.
See our list of best 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.