Informatica PowerCenter vs Pentaho Data Integration and Analytics comparison

Informatica PowerCenter vs. Pentaho Data Integration and Analytics

Download the complete report

Helped 896,942 peers since 2012

Review summaries and opinions

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

ROI

Sentiment score

8.3

Informatica PowerCenter provides cost-effective, flexible data management, enhancing decision-making, efficiency, and return on investment for businesses.

Sentiment score

7.1

Pentaho streamlines data integration, reducing costs and development time, with savings up to $75,000 annually and improved efficiency.

It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.

Associate Principal Engineer at Nagarro

The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.

Operations Engineer at a computer software company with 501-1,000 employees

The return on investment is very good, as I previously mentioned, because the development team has been reduced to half, and it has saved us around one hour per day since we switched to Informatica PowerCenter.

For more quotes and insights, download the Informatica PowerCenter report

Data engineer at a tech vendor with 10,001+ employees

I have seen a return on investment; my team was able to stay extremely small even though we had a lot of data integrations with many companies.

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

I can testify to the return on investment with metrics regarding time saved; we have increased our efficiency by about 20 to 30 percent due to the swift migration processes facilitated by the tool.

Data Integration Developer at a tech services company with 1,001-5,000 employees

I have noticed a return on investment with Pentaho Data Integration and Analytics in terms of time savings and staff reduction.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Customer Service

Sentiment score

7.0

Informatica PowerCenter's support is mostly well-rated, though some users report delays and desire improved complex problem understanding.

Sentiment score

5.1

Users find community resources and forums helpful for Pentaho support, but complex issues sometimes require paid assistance.

The documentation is thorough, and anyone with minimal knowledge of ETL can easily understand it and work through errors.

Data engineer at a tech vendor with 10,001+ employees

I like the technical support provided by Informatica.

Professor of Economics of Informatic at CMAYOR

I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.

For more quotes and insights, download the Informatica PowerCenter report

Associate Principal Engineer at Nagarro

24/7 assistance is available for the Enterprise Edition.

Jayakrishnanmg MG

Data architect at a tech vendor with 10,001+ employees

take the time to understand our business requirements, offering appropriate recommendations.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech services company with 1,001-5,000 employees

Communication with the vendor is challenging

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Scalability Issues

Sentiment score

6.8

Informatica PowerCenter offers scalability but faces limitations and cost challenges, especially compared to cloud alternatives in real-time applications.

Sentiment score

7.2

Pentaho Data Integration scales effectively for large datasets, though massive environments may challenge performance without cloud deployment.

In the cloud, scaling up and down becomes easy when working with cloud providers.

Associate Principal Engineer at Nagarro

The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly.

Operations Engineer at a computer software company with 501-1,000 employees

We can easily scale the memory and also the workflows.

For more quotes and insights, download the Informatica PowerCenter report

Data engineer at a tech vendor with 10,001+ employees

It can be scaled well until you reach a point where you need to perform a lot of operations, and the issue arises when it runs out of memory to handle some data.

reviewer2787603

Data engineer at a educational organization with 1,001-5,000 employees

Its ability to scale horizontally in cloud-native architectures or for massive real-time processing is limited.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Pentaho Data Integration handles larger datasets better.

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Stability Issues

Sentiment score

7.9

Informatica PowerCenter is highly reliable with minimal issues, praised for its stability and dependable performance across industries.

Sentiment score

7.3

Pentaho Data Integration's stability varies, with reliability for small tasks but struggles with massive data and occasional bugs.

We are getting 100% uptime every day.

Operations Engineer at a computer software company with 501-1,000 employees

Informatica PowerCenter is stable and can scale well.

Professor of Economics of Informatic at CMAYOR

The product is very stable with very few issues encountered in production.

For more quotes and insights, download the Informatica PowerCenter report

Associate Principal Engineer at Nagarro

Performance issues arise due to reliance on a flowchart-based mechanism instead of scripts, which can lead to longer execution times.

Jayakrishnanmg MG

Data architect at a tech vendor with 10,001+ employees

I find that version 3.1 is the most stable version I have ever used.

Alberto Pedro

Founder-CEO at Ubuntu Analytica

It's pretty stable, however, it struggles when dealing with smaller amounts of data.

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Room For Improvement

Informatica PowerCenter users seek enhanced flexibility, modern interface, better integration, and improved support, with cost and scalability concerns.

Pentaho Data Integration needs improved performance, scalability, cloud integration, real-time processing, updated interface, and better documentation and support.

With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.

Narasimha MLV

Director at a computer software company with 1,001-5,000 employees

Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.

Professor of Economics of Informatic at CMAYOR

Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.

For more quotes and insights, download the Informatica PowerCenter report

Associate Principal Engineer at Nagarro

We should also explore more effective partitioning for parallel processing and fine-tuning database connections to reduce load times and improve ETL speed.

Data Integration Developer at a tech services company with 1,001-5,000 employees

Pentaho Data Integration and Analytics can be improved by working with different environments, specifically the possibility to change the variables, meaning I write my variables only once and can change them for different environments such as production or development.

Alberto Pedro

Founder-CEO at Ubuntu Analytica

Pentaho Data Integration and Analytics could have real-time processing and automatic alerting, having alerts or automatic notifications when a job fails or when certain data doesn't meet certain rules.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Setup Cost

Informatica PowerCenter's high pricing suits large enterprises, with costs beginning at $100,000 annually, limiting smaller businesses.

Pentaho provides cost-effective data integration and analytics with a free Community Edition and a competitively priced Enterprise Edition.

I find that the pricing and licensing for Informatica PowerCenter align with its quality.

Professor of Economics of Informatic at CMAYOR

The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.

Narasimha MLV

Director at a computer software company with 1,001-5,000 employees

We haven't paid for it; our client had paid for this tool.

For more quotes and insights, download the Informatica PowerCenter report

Operations Engineer at a computer software company with 501-1,000 employees

I use the community version of Pentaho Data Integration and Analytics, and I do not need additional costs.

JuanCarlosMartinezLara

Project Manager at Laberit

The setup cost was minimal, and the pricing experience was pretty good.

reviewer2787603

Data engineer at a educational organization with 1,001-5,000 employees

The company covered it and they had no problem paying for it because they saw that it was cost-effective in terms of performance afterwards.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Analyst at Telefonica Digital

Valuable Features

Informatica PowerCenter offers a user-friendly interface, robust transformations, seamless integration, scalability, and automation for efficient data management.

Pentaho Data Integration is user-friendly, versatile, and integrates well with data sources, supporting automation and minimal coding for efficiency.

The system supports real-time integration, which is essential for many of my tasks.

Professor of Economics of Informatic at CMAYOR

Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.

Operations Engineer at a computer software company with 501-1,000 employees

Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload.

For more quotes and insights, download the Informatica PowerCenter report

Data engineer at a tech vendor with 10,001+ employees

Pentaho Data Integration and Analytics has positively impacted my organization because it meant we didn't have to write a lot of custom API back-end processing logic; it did the majority of that heavy lifting for us.

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

It automates the data workflow, including extraction, cleansing, and loading into warehouses for BI reporting purposes, while also removing duplicates, validating data, and standardizing formats, enabling real-time decision-making.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech services company with 1,001-5,000 employees

Pentaho Data Integration and Analytics has positively impacted my organization because it is easier to use, and my knowledge about this work facilitates the translation from the source to my final system.

JuanCarlosMartinezLara

Project Manager at Laberit

Categories and Ranking

Informatica PowerCenter

Ranking in Data Integration

3rd

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Visualization (11th)

Pentaho Data Integration an...

Ranking in Data Integration

8th

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of June 2026, in the Data Integration category, the mindshare of Informatica PowerCenter is 3.4%, down from 8.6% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.7%, down from 1.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration Mindshare Distribution
Product	Mindshare (%)
Informatica PowerCenter	3.4%
Pentaho Data Integration and Analytics	1.7%
Other	94.9%

Data Integration

Featured Reviews

Has supported complex data pipeline creation but performance tuning and monitoring responsiveness need improvement

Associate Principal Engineer at Nagarro

Sometimes, I see various performance issues with Informatica PowerCenter, including caching concerns, whether it's a joiner transformation or other transformations, so I believe the team can enhance the performance perspectives of these transformations. Additionally, sometimes the Informatica Monitor hangs or takes time to open the current run or logs, which the team can also look into. Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.

Read full review

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

Streamlines complex data workflows and has supported automated customer payment notifications

I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.

Read full review

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

896,942 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Manufacturing Company

Computer Software Company

Government

Financial Services Firm

15%

Educational Organization

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	15
Midsize Enterprise	11
Large Enterprise	75

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	17
Large Enterprise	32

Questions from the Community

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

Which Informatica product would you choose - PowerCenter or Cloud Data Integration?

Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerCenter

Comparisons

Compared 7% of the time

WhereScape RED vs Informatica PowerCenter

Compared 5% of the time

Oracle Data Integrator (ODI) vs Informatica PowerCenter

Compared 5% of the time

SSIS vs Informatica PowerCenter

Compared 5% of the time

Databricks vs Informatica PowerCenter

Compared 3% of the time

More Informatica PowerCenter Competitors

Airbyte Cloud vs Pentaho Data Integration and Analytics

Compared 12% of the time

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 7% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 7% of the time

StreamSets vs Pentaho Data Integration and Analytics

Compared 5% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Informatica PowerCenter

Download Informatica PowerCenter product report

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

Also Known As

PowerCenter

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.

Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.

What are the key features of Informatica PowerCenter?

Data Integration: Facilitates robust data handling across numerous platforms.
Real-Time Processing: Manages data workflows efficiently in real-time.
Transformation Options: Provides extensive options for data mapping and manipulation.
Error Handling: Enhances development through efficient error management.
Scalability: Supports growing data needs with adaptability across diverse systems.

What benefits should users look for?

Scalability: Supports growth with efficient data management and integration.
Efficiency: Offers user-friendly interfaces for streamlined workflows.
Support: Provides traceability and comprehensive support for large data handling.
Adaptability: Integrates seamlessly with various data platforms, enhancing flexibility.
Future-Preparedness: Ready for transition to cloud environments for better scalability.

Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.

Informatica

Pentaho Data Integration and Analytics offers an intuitive platform for data workflows, enabling users to easily manage ETL processes across diverse data formats, ensuring seamless automation and development.

With its drag-and-drop interface, Pentaho allows for efficient ETL workflows without extensive coding. It supports a multitude of data formats and sources such as SQL, NoSQL, Hadoop, CSV, and JSON. Advanced features like metadata injection and API integration enable seamless automation. However, improvements in big data performance, better cloud service integration, and enhanced real-time processing capabilities can enhance user experience. Additional connectors and improved documentation are sought after by many. Providing support for more programming languages and optimizing memory usage also presents opportunities for enhancement.

What are the key features of Pentaho Data Integration and Analytics?

Drag-and-Drop Interface: Simplifies building workflows without coding.
Broad Data Support: Accommodates SQL, NoSQL, Hadoop, CSV, and JSON.
Advanced Automation: Leverages metadata injection and API integration.
Cost-Effectiveness: Offers value with comprehensive big data support.

What benefits should be evaluated in Pentaho reviews?

Versatility: Supports both on-premises and cloud solutions.
Data Integration: Facilitates seamless connection of disparate data sources.
Transparency: Enhances data management and reporting.
Scalability: Adapts to the growing data needs of organizations.

Pentaho is employed across finance, healthcare, and retail industries for ETL processes. It's instrumental in integrating data from ERP, SAP systems, Excel, and APIs to develop comprehensive reports and data models. Companies rely on its capabilities for both on-premises and cloud deployments, improving data transparency and management.

Hitachi Vantara

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

Informatica PowerCenter vs. Pentaho Data Integration and Analytics