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

Oracle Data Integrator (ODI) 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

Oracle Data Integrator (ODI)
Ranking in Data Integration
8th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
No ranking in other categories
Palantir Foundry
Ranking in Data Integration
13th
Average Rating
7.8
Reviews Sentiment
7.0
Number of Reviews
18
Ranking in other categories
IT Operations Analytics (8th), Supply Chain Analytics (1st), Cloud Data Integration (10th), Data Migration Appliances (3rd), Data Management Platforms (DMP) (1st), Data and Analytics Service Providers (1st)
 

Mindshare comparison

As of May 2026, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 2.5%, down from 4.5% compared to the previous year. The mindshare of Palantir Foundry is 2.1%, down from 2.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Oracle Data Integrator (ODI)2.5%
Palantir Foundry2.1%
Other95.4%
Data Integration
 

Featured Reviews

Hafiz Mannan - PeerSpot reviewer
Head of Data Services – Services Partner at 3 As Technologies
Facilitates complex data integration with ease and flexibility
It would be great if ODI could link the designer, mapping, and workflows in a more simplified manner, maybe in one combined interface. It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame instead of having the designer separately, mapping separately, and monitoring and session management separately. With respect to data quality challenges, it would be great to give an option to fix data quality issues based on AI. Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent. One of the main disadvantages of the Oracle Data Integrator (ODI) is that it sometimes takes a lot of resources when handling multiple jobs. The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement, and certain parallel threads should be added along with the ability to configure multiple jobs from the same data directory structure.
BA
Associate Vice President at a insurance company with 10,001+ employees
Unified data workflows have empowered collaborative analytics and streamlined AI development
Regarding points for improvement for Palantir Foundry, I see that they are improving day by day. In the last one to two years, I have seen many improvements compared to the two years that I have worked on Palantir Foundry. There are many things that come up, but a few things are not intuitive enough. Now that we are in this AI phase, Palantir Foundry has created some wrappers around the models, allowing us to create using a no-code application, chatbots, and LLM functions. The problem is that interaction with outside applications can be difficult with the current setup that Palantir Foundry has. There are ways to do that, but it is not that intuitive, which is what I feel.

Quotes from Members

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

Pros

"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"ODI is really powerful for BI projects with traditional star-schema loads."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Far more efficient and robust than OWB, (it was the natural evolution for us)."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"I think that ODI is one of the most complete and open solutions, since it can work with almost any technology and it gives you the ability to develop the same solution in a wide variety of ways depending on the one you prefer."
"The data lineage is great."
"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."
"Live video sessions enhance the available documentation and allow you to ask questions directly."
"It has been the platform for end to end data processing, manipulations, and reporting, greatly improved org's data reporting effort."
"The AI engine that comes with Palantir Foundry is quite interesting."
"It's scalable."
"Great features available in one tool."
 

Cons

"I think Oracle should add more functions to improve optimization."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The main problem with ODI is that you have to create each step of the transformation as a new interface. A big data flow can have more than 100 interfaces, which can make it difficult to trace the data."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"When I do a BI type of project, I like to pick the simplest declarative solution that I can find, but that sometimes puts a lot of burden on me personally to fix all of the nuances of the platform that I am integrating to and from."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"Export/import isn't stable and they don't have a clear behavior."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"If you want to create new models on specific data sets, computing that is quite costly."
"Compared to other hyperscalers, Palantir Foundry is complex and not so user-intuitive."
"The solution could use more online documentation for new users."
"The one area where improvement could be made is the cost of the solution which is quite expensive."
"The frontend capabilities of Palantir Foundry could be improved."
"It would be helpful to build applications based on Azure functions or web apps in Palantir Foundry."
"The solution’s data security could be improved."
"The workflow could be improved. Although it works rather seamlessly, the workflow is too complicated sometimes."
 

Pricing and Cost Advice

"Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
"The solution is very expensive."
"The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"Palantir Foundry has different pricing models that can be negotiated."
"The solution’s pricing is high."
"Palantir Foundry is an expensive solution."
"It's expensive."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
893,244 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Database Administrator at a tech services company with 51-200 employees
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Government
9%
Manufacturing Company
8%
Comms Service Provider
7%
Manufacturing Company
13%
Financial Services Firm
9%
Government
8%
University
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise5
Large Enterprise9
 

Questions from the Community

What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Data Integrator (ODI)?
In comparison with other products of the same range, licensing mode is really attractive, no need to license according technology/topology to be used and an incredible Versatility to build any Data...
What needs improvement with Palantir Foundry?
Regarding points for improvement for Palantir Foundry, I see that they are improving day by day. In the last one to two years, I have seen many improvements compared to the two years that I have wo...
What is your primary use case for Palantir Foundry?
There are several use cases that we are working on with Palantir Foundry. The first thing is for data model creation for all our data engineering pipelines. That is one use case. Palantir Foundry a...
What advice do you have for others considering Palantir Foundry?
The visualization part in Palantir Foundry works for me at least if I want to see how the data is structured and for an initial analysis, but I would say it is not as matured as Power BI or Tableau...
 

Also Known As

ODI
No data available
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Merck KGaA, Airbus, Ferrari,United States Intelligence Community, United States Department of Defense
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Palantir Foundry and other solutions. Updated: May 2026.
893,244 professionals have used our research since 2012.