Compare Informatica PowerCenter vs. Pentaho Data Integration

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use Pentaho Data Integration? Share your opinion.
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: July 2020.
431,468 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System.The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter.The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed.The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution.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 features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand.In the end, you have structured, proper data for use in an integrated BI solution.The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage.

More Informatica PowerCenter Pros »

The solution has a free to use community version.

More Pentaho Data Integration Pros »

Cons
The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer.I found it is kind of weird that not all of the mapping changes are treated as true changes.Include more instruments for LOGs analysis, interpretation, and job corrections.The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica.I would like to see an improvement in the digital adoption.Integration with Artificial Intelligence would benefit this solution.As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good.Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better.

More Informatica PowerCenter Cons »

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.

More Pentaho Data Integration Cons »

Pricing and Cost Advice
Its maintenance is expensive.Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis.

More Informatica PowerCenter Pricing and Cost Advice »

Information Not Available
report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
431,468 professionals have used our research since 2012.
Ranking
2nd
Views
40,970
Comparisons
32,709
Reviews
8
Average Words per Review
383
Avg. Rating
8.1
12th
Views
11,232
Comparisons
9,258
Reviews
1
Average Words per Review
845
Avg. Rating
8.0
Popular Comparisons
Compared 18% of the time.
Compared 21% of the time.
Also Known As
PowerCenterKettle
Learn
Informatica
Hitachi
Overview

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Offer
Learn more about Informatica PowerCenter
Learn more about Pentaho Data Integration
Sample Customers
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Top Industries
REVIEWERS
Comms Service Provider11%
Energy/Utilities Company11%
Financial Services Firm11%
Healthcare Company11%
VISITORS READING REVIEWS
Computer Software Company45%
Comms Service Provider11%
Insurance Company7%
Media Company5%
REVIEWERS
Comms Service Provider18%
Financial Services Firm18%
Healthcare Company18%
Government9%
VISITORS READING REVIEWS
Computer Software Company37%
Media Company10%
Comms Service Provider10%
Government8%
Company Size
REVIEWERS
Small Business17%
Midsize Enterprise11%
Large Enterprise71%
VISITORS READING REVIEWS
Small Business14%
Midsize Enterprise8%
Large Enterprise78%
REVIEWERS
Small Business21%
Midsize Enterprise25%
Large Enterprise54%
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: July 2020.
431,468 professionals have used our research since 2012.
Informatica PowerCenter is ranked 2nd in Data Integration Tools with 11 reviews while Pentaho Data Integration is ranked 12th in Data Integration Tools with 1 review. Informatica PowerCenter is rated 8.2, while Pentaho Data Integration is rated 8.0. The top reviewer of Informatica PowerCenter writes "Assists us with integration as we migrate from on-premise to cloud, but it needs a performance analyzer". On the other hand, the top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". Informatica PowerCenter is most compared with SSIS, Informatica Cloud Data Integration, Oracle Data Integrator (ODI), Azure Data Factory and Mule Anypoint Platform, whereas Pentaho Data Integration is most compared with SSIS, Talend Open Studio, IBM InfoSphere DataStage, Azure Data Factory and Oracle Data Integrator (ODI).

See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

We monitor all Data Integration Tools 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.