Try our new research platform with insights from 80,000+ expert users

Informatica PowerCenter vs Palantir Foundry comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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
Ranking in Data Integration
4th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
82
Ranking in other categories
Data Visualization (9th)
Palantir Foundry
Ranking in Data Integration
14th
Average Rating
7.8
Reviews Sentiment
7.1
Number of Reviews
17
Ranking in other categories
IT Operations Analytics (9th), Supply Chain Analytics (1st), Cloud Data Integration (11th), Data Migration Appliances (3rd), Data Management Platforms (DMP) (1st), Data and Analytics Service Providers (1st)
 

Mindshare comparison

As of June 2025, in the Data Integration category, the mindshare of Informatica PowerCenter is 8.9%, down from 11.7% compared to the previous year. The mindshare of Palantir Foundry is 3.0%, up from 2.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Deepak Shiv - PeerSpot reviewer
Provides multiple transformations in one toolset and helpful when extracting data from multiple sources
Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors. In addition, there are KB articles published by Informatica that are really helpful. So, error handling and the KB articles provided by Informatica are very helpful. Even if you face any issues or errors, we can usually resolve them. If the error cannot be solved with Informatica PowerCenter, we can raise a case with Informatica, and their support team will help us address that issue. If it cannot be solved with that particular version, they will consider it and try to solve it with the next patch or hotfix. AI Initiatives: Our company also has organizational AI or machine learning initiatives. However, Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool. It doesn't have a significant role in the field. It is just a small ETL on-premises tool. So basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud and Informatica Cloud), where their AI comes into the picture. But for Informatica PowerCenter, AI does not come into the picture at all.
Rama Subba Reddy Thavva - PeerSpot reviewer
A low-code/no-code platform with a user-friendly UI
We couldn't implement or use some of the latest functionalities, like Spark. Palantir Foundry is scalable, but it is costly compared to other cloud providers. The solution is more suitable for small and medium businesses. It might be difficult for large enterprises. I rate the solution’s scalability 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

"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"The most valuable features are the monitoring tools and the reporting manager."
"The setup is straightforward."
"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."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"The solution offers very good end-to-end capabilities."
"The interface is really user-friendly."
"The solution provides an end-to-end integrated tech stack that takes care of all utility/infrastructure topics for you."
"I rate Palantir Foundry a ten out of ten."
"Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration."
"The ease of use is my favorite feature. We're able to build different models and projects or combine different projects to build one use case."
"It is easy to map out a workflow and run trigger-based scripts without having to deploy to another server."
"The predictive analytics capability within Palantir Foundry impacts financial forecasting strategies through its AIP functionality, which includes numerous pre-built models, LLMs, and data science application libraries."
 

Cons

"I would like to see an improvement in the digital adoption."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The licensing is difficult."
"The documentation could be improved."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"The frontend capabilities of Palantir Foundry could be improved."
"They do not have a data center in Europe, and we have lots of personally identifiable information in our dataset that needs to be hosted by a third-party data center like Amazon or Microsoft Azure."
"The major hindrance with Palantir Foundry is that being a very closed product, the cost optimization and costing are not exposed to the end users."
"Compared to other hyperscalers, Palantir Foundry is complex and not so user-intuitive."
"It requires a lot of manual work and is very time-consuming to get to a functional point."
"If you want to create new models on specific data sets, computing that is quite costly."
"Some error messages can be very cryptic."
"It would be helpful to build applications based on Azure functions or web apps in Palantir Foundry."
 

Pricing and Cost Advice

"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"Our customers pay a licensing fee yearly."
"The licensing fees are paid on a yearly basis."
"Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support. If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it."
"Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products. Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive."
"The price of this solution is high."
"The price is mostly reasonable."
"Its licensing is expensive in terms of scaling."
"The solution’s pricing is high."
"It's expensive."
"Palantir Foundry is an expensive solution."
"Palantir Foundry has different pricing models that can be negotiated."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
858,327 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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
19%
Computer Software Company
12%
Manufacturing Company
7%
Insurance Company
7%
Manufacturing Company
13%
Financial Services Firm
11%
Computer Software Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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...
What do you like most about Palantir Foundry?
Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration.
What needs improvement with Palantir Foundry?
Palantir Foundry is missing marketing, which could help it grow. Additionally, the startup pricing is high, causing concern despite being cost-effective in terms of total cost of ownership. Palanti...
What is your primary use case for Palantir Foundry?
I am getting into the ontology space using Palantir Foundry. The primary use case is for developing a common business model that includes data, people, and processes, essentially describing how bus...
 

Also Known As

PowerCenter
No data available
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Merck KGaA, Airbus, Ferrari,United States Intelligence Community, United States Department of Defense
Find out what your peers are saying about Informatica PowerCenter vs. Palantir Foundry and other solutions. Updated: May 2025.
858,327 professionals have used our research since 2012.