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."The most valuable features are the metadata repository and the data warehouse application console."
"The ability to scale through partitions helped us to improve the performance."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"It is UI friendly and has all the advantages of an ETL tool."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"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."
"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."
"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."
"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."
"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."
"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."
"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."
"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"We had stability issues, mostly with JVM size."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"I would like to see an improvement in the digital adoption."
"It should be more cloud-centric than on-prem-centric."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"If you develop it on MacBook, it'll be quite a hassle."
"I would like to see more improvements with AS400 DB2."
"I would like to see improvements made for real-time data processing."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"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."
"One thing that I don't like, just a little, is the backward compatibility."
"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 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."
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 48 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, Talend Open Studio, Oracle Data Integrator (ODI) and FME. 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.