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

Oracle Data Integrator (ODI) vs SAS Data Integration Server 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.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
SAS Data Integration Server
Ranking in Data Integration
36th
Average Rating
7.2
Reviews Sentiment
6.5
Number of Reviews
4
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 4.6%, up from 4.4% compared to the previous year. The mindshare of SAS Data Integration Server is 0.5%, up from 0.5% 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.
NN
Offloads processes on the server side but needs better installation syntax
One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference between two dates, the general syntax in SAS is called the data difference or data net function. However, another name is used, such as NF and INK. Without knowledge of SAS programming, it becomes unclear what these functions mean. It is not good to define function names this way.

Quotes from Members

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

Pros

"The most valuable feature is Data movement."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"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."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"​The installation of the client ODI Studio is easy.​"
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The most valuable feature that we use is the Knowledge Modules."
"The solution offers very good data manipulation and loading."
"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."
"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."
 

Cons

"The performance of the user interface is in need of improvement."
"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."
"​The stability of the software could be improved. Sometimes, the software just crashes. ​"
"Technical Support could be better."
"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."
"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 are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"We used a third party to do the implementation of ODI."
"The initial setup had issues, and even after using it for about one year, it was still not fixed."
"So I would like to see improved integration with other software."
"The initial setup had issues, and even after using it for about one year, it was still not fixed."
"The initial setup of SAS Data Integration Server was complex."
"The transform tool has limited access. They should make it more flexible."
"One area for improvement is the installation process."
 

Pricing and Cost Advice

"We found that the cost compared to other integration tools is a little high, but the solution works great."
"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."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"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."
"The solution is very expensive."
"It is an expensive program."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
845,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
17%
Computer Software Company
12%
Government
10%
Manufacturing Company
8%
Financial Services Firm
26%
Computer Software Company
13%
Government
12%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
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...
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 SAS Data Integration Server?
The most valuable feature of the solution is its amazing capabilities in regard to data handling.
What is your experience regarding pricing and costs for SAS Data Integration Server?
I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.
What needs improvement with SAS Data Integration Server?
One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference...
 

Also Known As

ODI
SAS Enterprise Data Integration Server, Enterprise Data Integration Server
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. SAS Data Integration Server and other solutions. Updated: February 2025.
845,406 professionals have used our research since 2012.