Oracle Data Integrator (ODI) vs SAS Data Management comparison

Oracle and SAS are both solutions in the Data Integration category. Oracle is ranked #6 with an average rating of 8.1, while SAS is ranked #37 with an average rating of 7.5. Oracle holds a 5.4% mindshare in DI, compared to SAS’s 0.8% mindshare. Additionally, 83% of Oracle users are willing to recommend the solution, compared to 87% of SAS users who would recommend it.

Oracle Data Integrator (ODI)

Read 70 Oracle Data Integrator (ODI) reviews

10,557 Views
6,396 Comparison Views

83% willing to recommend

SAS Data Management

Read 16 SAS Data Management reviews

1,195 Views
995 Comparison Views

87% willing to recommend

Oracle Data Integrator (ODI)

SAS Data Management

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

Oracle Data Integrator and SAS Data Management compete in the data integration and management category. Oracle Data Integrator seems to have an advantage with its ELT capabilities and flexible integration, while SAS Data Management provides a comprehensive suite more suited for data quality and accessibility.

Features: Oracle Data Integrator delivers extensive ELT capabilities, enhances performance by leveraging source and target technologies, and supports multiple scripting languages, enabling diverse platform integration. SAS Data Management supports robust import/export functionalities, ensures data quality and provides an accessible interface for non-technical users.

Room for Improvement: Oracle Data Integrator could enhance its graphical interface, improve error handling, and simplify multi-user development. SAS Data Management needs better cloud integration, improved inter-tool compatibility, and more automation features.

Ease of Deployment and Customer Service: Both Oracle Data Integrator and SAS Data Management are primarily on-premises solutions. Oracle accommodates public and hybrid cloud configurations but has inconsistent customer service. SAS offers stable support with quick problem resolution.

Pricing and ROI: Oracle Data Integrator is viewed as expensive, with high licensing costs, but provides value through automation and efficiency. SAS Data Management, while also costly, offers a robust feature set beneficial for larger enterprises. Both solutions deliver ROI with efficient implementation, though high initial costs may deter smaller users.

To learn more, read our detailed Oracle Data Integrator (ODI) vs. SAS Data Management Report (Updated: November 2024).

Buyer's Guide

Oracle Data Integrator (ODI) vs. SAS Data Management

November 2024

Download the complete report

Helped 824,067 peers since 2012

Categories and Ranking

Oracle Data Integrator (ODI)

Ranking in Data Integration

6th

Average Rating

8.2

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

SAS Data Management

Ranking in Data Integration

37th

Average Rating

8.4

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Quality (11th), Data Governance (26th)

Mindshare comparison

As of December 2024, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 5.4%, up from 5.4% compared to the previous year. The mindshare of SAS Data Management is 0.8%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Jagadish Sau

Technical lead at a transportation company with 10,001+ employees

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.

Read full review

Vivek Trivedi

Head finance transformation at Ahli United Bank Ksc

Has robust data governance capabilities and efficient financial alerting features

The platform's robust data governance capabilities ensure strong compliance with regulatory standards. Our dedicated data governance team is responsible for setting policies and monitoring data access and usage. Additionally, we have a Data Protection Officer (DPO) and an independent InfoSec team that work together to enforce these policies. This multi-layered approach ensures that data governance is effectively managed and compliant with all necessary regulations. It is integrated with SQL and Power BI servers for executive management dashboard reporting. This integration supports comprehensive data analysis and reporting needs, which was a key factor in our decision. The value of using vCenter lies in its comprehensive data infrastructure management. It significantly enhances our reporting, day-to-day decision-making, and analytics capabilities. Integrating SaaS with vCenter adds value by streamlining key functions and improving overall organizational efficiency. The solution can be considered expensive, particularly due to infrastructure, maintenance, and ownership costs. The long-term savings and efficiencies gained from using vCenter can justify the investment for large organizations. However, the high costs might not be justifiable for smaller organizations with less data and fewer resources. Conducting a thorough cost-benefit analysis based on the organization's specific needs and scale is recommended. I rate it an eight.

Read full review

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."

"It effectively manages errors through its logging and exception-handling capabilities."

"The most valuable feature that we use is the Knowledge Modules."

"The product has an ELT approach."

"It is an ETL tool, which does the extract, transform, and load."

"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."

"The scalability is great. It's one of the reasons we chose the solution."

"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."

More Oracle Data Integrator (ODI) pros

"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."

"The tool is reliable, quick, and powerful."

"The technical support is excellent."

"If you compare it to SQL, the memory and development times are very quick."

"The platform's robust data governance capabilities ensure strong compliance with regulatory standards."

"This is an established product with powerful data analysis and varied options for user entry points."

"I am impressed with the tool's ability to customize."

"The product offers very good flexibility."

More SAS Data Management pros

Cons

"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 Oracle Data Integrator interface is extremely slow, especially when using remote desktop connections."

"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."

"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."

"Stability could be improved because some operators have issues."

"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."

"The performance of the user interface is in need of improvement."

More Oracle Data Integrator (ODI) cons

"Integration and cloud migration are areas where we see potential for improvement."

"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."

"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."

"I would like the tool to include the ability to automate the modifications of the integrations."

"The solution could use better documentation."

"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."

"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."

"The pricing of the solution needs to be improved. They need to work to make it more affordable."

More SAS Data Management cons

Pricing and Cost Advice

"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."

"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."

"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."

"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."

"ODI comes included when buying the cloud version of the Oracle database license."

"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."

"I rate the platform pricing as five out of ten."

"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."

More Oracle Data Integrator (ODI) pricing and cost advice

"While it is even free for personal use on the cloud, it can be expensive for desktop installations and enterprise use."

"The solution is expensive."

"The tool is a bit expensive."

"The licensing model for vCenter is a perpetual license with yearly payments."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

824,067 professionals have used our research since 2012.

Comparison Review

it_user99375

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…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Computer Software Company

13%

Government

Manufacturing Company

Financial Services Firm

29%

Computer Software Company

13%

Insurance Company

Government

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...

See all answers

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.

See all answers

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.

See all answers

What do you like most about SAS Data Management?

I am impressed with the tool's ability to customize.

See all answers

What is your experience regarding pricing and costs for SAS Data Management?

The licensing model for vCenter is a perpetual license with yearly payments. This model ensures continuous updates and support while managing initial setup costs.

See all answers

What needs improvement with SAS Data Management?

Integration and cloud migration are areas where we see potential for improvement. A more seamless integration process and transitioning to a cloud-based environment would enhance user-friendliness ...

See all answers

Comparisons

Oracle Integration Cloud Service vs Oracle Data Integrator (ODI)

Compared 17% of the time

Informatica PowerCenter vs Oracle Data Integrator (ODI)

Compared 14% of the time

SSIS vs Oracle Data Integrator (ODI)

Compared 11% of the time

Azure Data Factory vs Oracle Data Integrator (ODI)

Compared 9% of the time

Talend Open Studio vs Oracle Data Integrator (ODI)

Compared 5% of the time

More Oracle Data Integrator (ODI) Competitors

Informatica PowerCenter vs SAS Data Management

Compared 18% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs SAS Data Management

Compared 13% of the time

Palantir Foundry vs SAS Data Management

Compared 13% of the time

Ab Initio Co>Operating System vs SAS Data Management

Compared 11% of the time

SSIS vs SAS Data Management

Compared 9% of the time

More SAS Data Management Competitors

Product Reports

Buyer's Guide

Oracle Data Integrator (ODI)

December 2024

Download Oracle Data Integrator (ODI) product report

Buyer's Guide

SAS Data Management

November 2024

Download SAS Data Management product report

Also Known As

ODI

SAS Data Management Platform, Data Management Platform, DataFlux

Learn More

Oracle

SAS

Overview

Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.

Oracle Data Integrator Features

ODI has many valuable key features. Some of the most useful ones include:

Automatic documentation generation
Visualization of data flows in the interfaces
Customization of generated code
Automatic reverse-engineering of existing applications or databases
Graphical development and maintenance of transformation and integration interfaces
Robust data integrity control features, assuring the consistency and correctness of data
Powerful core differentiators
Heterogeneous ELT, declarative design and knowledge modules
Flexibility and modularity
Oracle Data Integrator repository
Topology navigator
Operator Navigator
Security Navigator
Integrator Console
ODI domains

Oracle Data Integrator Benefits

There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:

Efficient architecture: Oracle Data Integrator has a simple architecture that utilizes the source and target servers to perform complex transformations, making it an efficient solution.

Supports all platforms: ODI gives you platform independence by supporting all platforms, hardware, and OSes with the same software.

Cost-effective: Oracle Data Integrator reduces costs associated with initial hardware and software acquisition, and also decreases maintenance costs because it eliminates the need for an ETL Server and an ETL engine.

Automatic detection of faulty data: By using ODI, faulty data is recycled before insertion in the target application, providing you with a data quality firewall.

Easy development and maintenance: With a low learning curve, Oracle Data Integrator increases developer productivity while facilitating ongoing maintenance.

Active integration: ODI includes all styles of data integration: data-based, event-based and service-based.

Reviews from Real Users

Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.

Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”

Ashok S., Applications Support Manager at a marketing services firm, mentions, "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."

Every decision, every business move, every successful customer interaction - they all come down to high-quality, well-integrated data. If you don't have it, you don't win. SAS Data Management is an industry-leading solution built on a data quality platform that helps you improve, integrate and govern your data.

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University

Data Management, 1-800-FLOWERS.COM, Absa, Aegon, Allianz Global Corporate & SpecialtyAusgrid, Bank of Queensland, Bell, BMC Software, Canada Post, Ceska pojistovna, Chantecler, Chubb Group of Insurance Companies, Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Enerjisa, ERGO Insurance Group, Florida Department of Corrections, Generali Hellas, Gitanjali Group, Gloucestershire Constabulary, GS Home Shopping, HealthPartners, IAG New Zealand, iJET, Invacare, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, North Carolina Office of Information Technology Services, Orlando Magic, OTP Group, PITT OHIO, Plano Independent School District, RWE Poland, Spanish Air Force, Stockholm County Council, Telus, The Travel Corporation, Transitions Optical, Triad Analytic Solutions, UNIQA, US Census Bureau, US Department of Housing and Urban Development, USDA National Agricultural Statistics Service, West Midlands Police, XS Inc., Zenith Insurance

Buyer's Guide

Oracle Data Integrator (ODI) vs. SAS Data Management

November 2024

Free Report: Oracle Data Integrator (ODI) vs. SAS Data Management

Find out what your peers are saying about Oracle Data Integrator (ODI) vs. SAS Data Management and other solutions. Updated: November 2024.

DOWNLOAD NOW

824,067 professionals have used our research since 2012.

See our Oracle Data Integrator (ODI) vs. SAS Data Management report.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.