Informatica PowerCenter vs. Pentaho Data Integration Comparison

Informatica PowerCenter

Pentaho Data Integration

Informatica PowerCenter

Read 11 Informatica PowerCenter reviews.

40,970 views|32,709 comparisons

Pentaho Data Integration

Read 1 Pentaho Data Integration review.

11,232 views|9,258 comparisons

Anonymous User

Database Administrator and Applications Specialist at a university

Utilized to ease and speed up building integrations between applications

Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System.

Use Pentaho Data Integration? Share your opinion.

Download Free Report

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: July 2020.

Download now

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

See Which Vendors Are Best For You Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs. See Recommendations 431,468 professionals have used our research since 2012.
Ranking
2nd out of 93 in Data Integration Tools Views 40,970 Comparisons 32,709 Reviews 8 Average Words per Review 383 Avg. Rating 8.1	12th out of 93 in Data Integration Tools Views 11,232 Comparisons 9,258 Reviews 1 Average Words per Review 845 Avg. Rating 8.0
Popular Comparisons
SSIS vs. Informatica PowerCenter Compared 18% of the time. Informatica Cloud Data Integration vs. Informatica PowerCenter Compared 14% of the time. Oracle Data Integrator (ODI) vs. Informatica PowerCenter Compared 9% of the time. Azure Data Factory vs. Informatica PowerCenter Compared 8% of the time. Mule Anypoint Platform vs. Informatica PowerCenter Compared 3% of the time. See more Informatica PowerCenter competitors » + Add more products to compare	SSIS vs. Pentaho Data Integration Compared 21% of the time. Talend Open Studio vs. Pentaho Data Integration Compared 15% of the time. IBM InfoSphere DataStage vs. Pentaho Data Integration Compared 8% of the time. Azure Data Factory vs. Pentaho Data Integration Compared 6% of the time. Oracle Data Integrator (ODI) vs. Pentaho Data Integration Compared 6% of the time. See more Pentaho Data Integration competitors » + Add more products to compare
Also Known As
PowerCenter	Kettle
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	Learn more about Pentaho Data Integration Learn More
Sample Customers
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank	66Controls, Providential Revenue Agency of Ro 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%

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).

Compare Informatica PowerCenter vs. Pentaho Data Integration