No more typing reviews! Try our Samantha, our new voice AI agent.

Informatica PowerCenter vs SAP Data Hub [EOL] comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Integration (4th), Data Visualization (13th)
SAP Data Hub [EOL]
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Garima Goel - PeerSpot reviewer
Associate Principal Engineer at Nagarro
Has supported complex data pipeline creation but performance tuning and monitoring responsiveness need improvement
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.
VM
GTM Lead at Capgemini
The solution is seamless, but the database sometimes leads to confusion
We used to have multiple different kinds of databases, which internally, had different compliance levels. Retention management is very different now. If the policy is live and the claim has been completed, I couldn't archive the claim. I needed to keep a reference integrity of that claim and understand which policy paid out the claim. With this solution, the policy came in six months ago and qualified for archiving. The claim had been paid and in every environment, the claim had been closed, including the reporting system, the claims system, etc. With the payment set gateway, I can just go and archive. But, we had a hard time during this process. I rate the overall solution a seven out of ten.

Quotes from Members

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

Pros

"In the end, you have structured, proper data for use in an integrated BI solution."
"The solution is stable."
"The technical support is excellent."
"It has a Data Catalog that uses the Model repository."
"It is very easy to use it to develop mappings and workflows."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The functions in Informatica PowerCenter that I have found most valuable are the way it manages the volume of data, the push down optimization, and the performance aspects of it, mostly related to parallelism techniques."
"The ability to scale through partitions helped us to improve the performance."
"The most valuable feature is the S/4HANA 1909 On-Premise"
"Its connection to on-premise products is the most valuable. We mostly use the on-premise connection, which is seamless. This is what we prefer in this solution over other solutions. We are using it the most for the orchestration where the data is coming from different categories. Its other features are very much similar to what they are giving us in open source. Their push-down approach is the most advantageous, where they push most of the processing on to the same data source. This means that they have a serverless kind of thing, and they don't process the data inside a product such as Data Hub. They process the data from where the data is coming out. If it is coming from HANA, to capture the data or process it for analytics, orchestration, or management, they go to the HANA database and give it out. They don't process it on Data Hub. This push-down approach increases the processing speed a little bit because the data is processed where it is sitting. That's the best part and an advantage. I have used another product where they used to capture the data first and then they used to process it and give it. In Data Hub, it is in reverse. They process it first and give it, and then they put their own manipulations. They lead in terms of business functions. No other solution has business functions already implemented to perform business analysis. They have a lot of prebuilt business functions for machine learning and orchestration, which we can use directly to get an analysis out from the existing data. Most of the data is sitting as enterprise data there. That's a major advantage that they have."
"They lead in terms of business functions, and no other solution has business functions already implemented to perform business analysis, with a lot of prebuilt business functions for machine learning and orchestration that we can use directly to get an analysis out from the existing enterprise data."
"Having this solution enables us to approach our clients to upgrade their databases, and we upgrade them according to their business requirements."
"SAP is one of the most seamless ERPs that have integrated SAP archiving within Excel. I have not seen this with any other database."
 

Cons

"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 PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"When I deal with very large amounts of data, there have been performance issues."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"In 2018, connecting it to outside sources, such as IoT products or IoT-enabled big data Hadoop, was a little complex. It was not smooth at the beginning. It was unstable. It took a lot of time for the initial data load. Sometimes, the connection broke, and we had to restart the process, which was a major issue, but they might have improved it now. It is very smooth with SAP HANA on-premise system, SAP Cloud Platform, and SAP Analytics Cloud. It could be because these are their own products, and they know how to integrate them. With Hadoop, they might have used open-source technologies, and that's why it was breaking at that time. They are providing less embedded integration because they want us to use their other products. For example, they don't want to go and remove SAP Analytics Cloud and put everything in Data Hub. They want us to use SAP Analytics Cloud somewhere else and not inside the Data Hub. On the integration part, it lacks real-time analytics, and it is slow. They should embed the SAP Analytics Cloud inside Data Hub or support some kind of analysis. They do provide some analysis, but it is not extensive. They are moreover open source. So, we need a lot of developers or data scientists to go in and implement Python algorithms. It would be better if they can provide their own existing algorithms and give some connections and drop-down menus to go and just configure those. It will make things really quick by increasing the embedded integrations. It will also improve the process efficiency and processing power. Its performance needs improvement. It is a little slow. It is not the best in the market, and there are other products that are much better than this. In terms of technology and performance, it is a little slow as compared to Microsoft and other data orchestration products. I haven't used other products, but I have read about those products, their settings, and the milliseconds that they do. In Azure Purview, they say that they can copy, manage, or transform the data within milliseconds. They say that they can transform 100 gigabytes of data within three to five seconds, which is something SAP cannot do. It generally takes a lot of time to process that much amount of data. However, I have never tested out Azure."
"The company has everything offshore."
"Its performance needs improvement. It is a little slow. It is not the best in the market, and there are other products that are much better than this."
"Nowadays there are some inconsistencies in data bases, however, they upgrade and release the versions to market."
 

Pricing and Cost Advice

"Our client has purchased the license, and we are using it."
"A basic setup can be from $100,000 and up annually."
"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."
"The price of Informatica PowerCenter is expensive, but it does give value."
"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
"Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
"Our customers pay a licensing fee yearly."
"It's much more expensive, almost three times more expensive than most other solutions."
"The Cloud is very expensive, but SAP HANA previous service is okay."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
913,683 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Manufacturing Company
8%
Outsourcing Company
7%
Government
6%
Outsourcing Company
14%
Manufacturing Company
12%
Construction Company
10%
Financial Services Firm
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise11
Large Enterprise76
No data available
 

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...
Ask a question
Earn 20 points
 

Also Known As

PowerCenter
No data available
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Kaeser Kompressoren, HARTMANN
Find out what your peers are saying about Informatica, Palantir, Microsoft and others in Data Integration. Updated: September 2026.
913,683 professionals have used our research since 2012.