We performed a comparison between Informatica PowerCenter and Palantir Foundry based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"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."
"Good interface, reasonable documentation."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"The setup is very simple."
"We have found the PowerCenter and B2B data transformation most valuable."
"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."
"The virtualization tool is useful."
"Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration."
"It's scalable."
"The solution provides an end-to-end integrated tech stack that takes care of all utility/infrastructure topics for you."
"The security is also excellent. It's highly granular, so the admins have a high degree of control, and there are many levels of security. That worked well. You won't have an EDC unless you put everything onto the platform because it is its own isolated thing."
"Great features available in one tool."
"The solution offers very good end-to-end capabilities."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"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."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"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."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"Requires an established data center because there is no option for software as a service."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The frontend capabilities of Palantir Foundry could be improved."
"Difficult to receive data from external sources."
"The data lineage was challenging. It's hard to track data from the sources as it moves through stages. Informatica EDC can easily capture and report it because it talks to the metadata. This is generated across those various staging points."
"Compared to other hyperscalers, Palantir Foundry is complex and not so user-intuitive."
"The workflow could be improved."
"There is not a wide user base for the solution's online documentation so it is sometimes difficult to find answers."
"If you want to create new models on specific data sets, computing that is quite costly."
"Cost of this solution is quite high."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Palantir Foundry is ranked 11th in Data Integration with 13 reviews. Informatica PowerCenter is rated 8.0, while Palantir Foundry is rated 7.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Palantir Foundry writes "The data visualization is fantastic and the security is excellent". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Palantir Foundry is most compared with Azure Data Factory, Palantir Gotham, SAP Data Services, AWS Glue and BCG Big Data & Advanced Analytics. See our Informatica PowerCenter vs. Palantir Foundry report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration 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.