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

Oracle Data Integrator (ODI) vs SAP Data Services 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
7th
Average Rating
8.2
Reviews Sentiment
6.7
Number of Reviews
70
Ranking in other categories
No ranking in other categories
SAP Data Services
Ranking in Data Integration
11th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
48
Ranking in other categories
Data Quality (2nd)
 

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 4.6%, up from 4.5% compared to the previous year. The mindshare of SAP Data Services is 2.5%, down from 3.0% 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.
RambabuMandala - PeerSpot reviewer
Responsive support, scalable, and beneficial integration
The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept. There are a lot of SAP applications and they have good integration with SAP packages. In the next release, they should be more advanced cloud functionalities and web services. More integration with other applications including SAPs and other applications. They should not switch to a complete solution but provide better integration with other applications.

Quotes from Members

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

Pros

"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The most valuable feature that we use is the Knowledge Modules."
"​The installation of the client ODI Studio is easy.​"
"Besides loading data, we do most of our transformations in ODI."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"It effectively manages errors through its logging and exception-handling capabilities."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"The product's most valuable features are data validation and rules."
"The API tool in this product is very valuable; it is very easy to onboard and use."
"The solution offers very good integration capabilities."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"Data Services' table comparison mechanism is very powerful. It's pretty hard to find a similar feature in other solutions."
"The maintenance of data services is the solution's most valuable feature."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
 

Cons

"The resource management aspect of the solution could be improved."
"The initial setup is complex, especially if you also have to install a console."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"There could be better compatibility with other ETL tools and cloud platforms."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The Oracle Data Integrator interface is extremely slow, especially when using remote desktop connections."
"The solution should improve connectivity with more source systems and target systems."
"There should be some kind of enhancement that can be done on the admin side of certain sites where we can assign the roles and responsibilities. We should be able to control who is using the tool and how."
"Scheduling of jobs in the sequence is not available. It's a very tedious process to do that particular task. If there was a tool to schedule in the sequence that would be extremely helpful."
"In the future, Data Services should offer a cloud version."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"With SAP Data Services, the problem arises when I try to connect to Azure Databricks."
"We encounter challenges while exporting implemented rules, such as those applied to objects like the material master, into a format like Excel for documentation and further analysis."
"The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster."
 

Pricing and Cost Advice

"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."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"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."
"ODI comes included when buying the cloud version of the Oracle database license."
"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."
"The price of SAP Data Services is a little high when compared to other solutions. Due to the pricing and capabilities, many clients are switching to other solutions."
"The enterprise version of SAP Data Services is free."
"The price is very reasonable."
"Pricing is good, there is no problem."
"The pricing is a little high to make the product more competetive in the marketplace."
"At the entry level, if you're using it only for data integration, it is a little bit cheap. However, for large organizations it can be expensive. There are additional costs apart from the license."
"Speaking about prices, Oracle and SAP are market leaders. So, the prices are more."
"It's relatively expensive compared to other vendors, but it is competitive."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
837,501 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
17%
Computer Software Company
13%
Government
9%
Manufacturing Company
8%
Manufacturing Company
15%
Computer Software Company
11%
Financial Services Firm
8%
Government
8%
 

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)?
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 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.
How do you evaluate the ratio of price to quality for SAP Data Services?
I believe the license for the product is fair, even though some competitors offer similar services at lower prices. The difference between the Edge edition and the next one up is significant in pr...
Would you recommend SAP Data Services to complete beginners?
I think after some preparation, a beginner will be able to use SAP Data Services, however, if you are completely unprepared, you may have some issues. I think that in particular you will need a mo...
How has SAP Data Services helped your organization?
SAP Data Services has helped our whole staff understand the data across various sources and systems within the company. Not everyone who works at my organization is an IT expert - most just have av...
 

Also Known As

ODI
SAP BusinessObjects Data Services, SAP BusinessObjects Data Integrator, BusinessObjects Data Integrator
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
EMC Corporation, LivePerson, Eldorado, Mozzart, The VELUX Group, AOK Bundesverband, Hilti Group, Nissha Printing Company Ltd., Asian Paints, Aareal Bank Group, Migros Group
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. SAP Data Services and other solutions. Updated: February 2025.
837,501 professionals have used our research since 2012.