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

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

Oracle Data Integrator (ODI)
Ranking in Data Integration
12th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
No ranking in other categories
Palantir Gotham
Ranking in Data Integration
57th
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of September 2026, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 2.6%, down from 3.5% compared to the previous year. The mindshare of Palantir Gotham is 0.8%, up from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Oracle Data Integrator (ODI)2.6%
Palantir Gotham0.8%
Other96.6%
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.
WH
Manager at a tech services company with 201-500 employees
A seamless all-in-one solution
This solution is seamless. From one platform, we can do just about anything. With other solutions, you'll need a separate platform for data ingestion, manipulation, etc. Then you'll need another tool for reporting. Palantir Gotham literally does it all. It generates a report regardless of the format. It can seamlessly generate it after the data has been collected.

Quotes from Members

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

Pros

"The user interface for the data integrator tool is probably the most valuable piece."
"It increased ETL development efficiency 1/3 in time."
"Oracle provides great documentation."
"For the EPM environment, the ODI is the key to transforming a good project into a great project."
"It is a clever integration tool to extract data from every possible source, and it can transform the source data to a format the targets can handle."
"We looked at alternatives, but they could not provide us with the complete set of features."
"The tool is declarative, and it only runs on the target staging databases, so I have full control over it and I can change the SQL that the tool generates."
"The CAEM is very useful in its modularity and portability."
"This solution is seamless. From one platform, we can do just about anything."
 

Cons

"There could be better compatibility with other ETL tools and cloud platforms."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"If you have something like Cisco on top of it, you will have endless problems."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The GUI is Java based, and is less than friendly."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"I would like more different tools of transformation. In the current version I have only worked with lookup and filter, and sometimes it is not good enough for what I use it for."
"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."
"I think there should be less coding involved. Currently, using it involves a tremendous amount of coding."
 

Pricing and Cost Advice

"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"ODI comes included when buying the cloud version of the Oracle database license."
"The solution is very expensive."
"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 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."
"I rate the platform pricing as five out of ten."
"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."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
Information not available
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_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
13%
Outsourcing Company
9%
Government
8%
Comms Service Provider
8%
Manufacturing Company
11%
Outsourcing Company
9%
Comms Service Provider
8%
Computer Software Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
No data available
 

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

Also Known As

ODI
No data available
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Team Rubicon, CGI
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.