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

Oracle Data Integrator (ODI) vs Palantir Foundry comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Oracle Data Integrator (ODI)
Ranking in Data Integration
6th
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
70
Ranking in other categories
No ranking in other categories
Palantir Foundry
Ranking in Data Integration
12th
Average Rating
7.6
Reviews Sentiment
7.2
Number of Reviews
15
Ranking in other categories
IT Operations Analytics (4th), 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 November 2024, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 5.2%, down from 5.4% compared to the previous year. The mindshare of Palantir Foundry is 2.5%, down from 3.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Jagadish Sau - PeerSpot reviewer
Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved
My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution. The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI). My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use. My rating for Oracle Data Integrator (ODI) is seven out of ten.
Manilal Kasera - PeerSpot reviewer
Transparent with good reliability and good data visibility
The initial setup had a medium level of difficulty. If we go through the documentation, we can learn about what to do. In Palantir, they had a section called Academy, and that Academy was quite useful. If you go through that as a new user, it makes the process easier as you learn what to do. Initially, we didn't have many sources that would help us learn things, so we struggled a bit. In contrast, with Azure and Amazon Cloud, you have many sources from where you would be easily able to learn. You could just Google what you needed with them, as there's so much available documentation online. What was easy was the fact that everything was in one place. With AWS Cloud, there are many applications to support. You can use Glue or Athena, and you have all these other applications. However, with Palantir, everything is easy due to the fact that it is centralized. It's drag and drop and everything is very transparent.

Quotes from Members

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

Pros

"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature is Data movement."
"The CAEM is very useful in its modularity and portability."
"Oracle Data Integrator offers a very good development environment and supports the use of multiple programming languages, including Python. It runs scenarios effectively, even when executing complex, long SQL scripts that are not runnable on other clients."
"​The installation of the client ODI Studio is easy.​"
"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."
"The scalability is great. It's one of the reasons we chose the solution."
"I like the data onboarding to Palantir Foundry and ETL creation."
"The interface is really user-friendly."
"The AI engine that comes with Palantir Foundry is quite interesting."
"Great features available in one tool."
"Live video sessions enhance the available documentation and allow you to ask questions directly."
"Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration."
"The virtualization tool is useful."
"The solution provides an end-to-end integrated tech stack that takes care of all utility/infrastructure topics for you."
 

Cons

"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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 initial setup is complex, especially if you also have to install a console."
"If you have something like Cisco on top of it, you will have endless problems."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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."
"If you want to create new models on specific data sets, computing that is quite costly."
"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."
"Cost of this solution is quite high."
"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."
"It would be helpful to build applications based on Azure functions or web apps in Palantir Foundry."
"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."
"It requires a lot of manual work and is very time-consuming to get to a functional point."
 

Pricing and Cost Advice

"ODI comes included when buying the cloud version of the Oracle database license."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"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."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"It's expensive."
"The solution’s pricing is high."
"Palantir Foundry has different pricing models that can be negotiated."
"Palantir Foundry is an expensive solution."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
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
16%
Computer Software Company
14%
Government
9%
Manufacturing Company
8%
Manufacturing Company
14%
Financial Services Firm
11%
Computer Software Company
10%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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)?
ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases.
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
The pricing of Oracle Cloud Services is not favorable as it charges daily regardless of usage, unlike competitors who charge only for days used.
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?
The solution’s data security could be improved. We cannot use many Python packages with the solution. We were able to use only a few compatible Python packages.
What is your primary use case for Palantir Foundry?
Our use cases are mostly related to data analytics. We are building some dashboards and ETL pipelines on the Palantir side. Palantir Foundry is a low-code/no-code platform with a user-friendly UI. ...
 

Also Known As

ODI
No data available
 

Learn More

 

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: November 2024.
816,406 professionals have used our research since 2012.