Oracle Data Integrator (ODI) Reviews

Name: Oracle Data Integrator (ODI)
Brand: Oracle
Rating: 4.1 (71 reviews)

4.1 out of 5

71 reviews
83% willing to recommend

3,462 followers

What is Oracle Data Integrator (ODI)?

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.

Get the Oracle Data Integrator (ODI) Buyer's Guide and find out what your peers are saying about Oracle Data Integrator (ODI), Informatica Intelligent Data Management Cloud (IDMC), Azure Data Factory and more!

Oracle Data Integrator (ODI) is the #7 ranked solution in top Data Integration Tools. PeerSpot users give Oracle Data Integrator (ODI) an average rating of 8.2 out of 10. Oracle Data Integrator (ODI) is most commonly compared to Informatica Intelligent Data Management Cloud (IDMC): Oracle Data Integrator (ODI) vs Informatica Intelligent Data Management Cloud (IDMC). Oracle Data Integrator (ODI) is popular among the large enterprise segment, accounting for 68% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 17% of all views.

Buyer's Guide

Oracle Data Integrator (ODI)

May 2025

Get the report

Helped 851,604 peers since 2012

Featured Oracle Data Integrator (ODI) reviews

Jagadish Sau

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

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

Jozsef Gazsik

DWH Framework Architect at Erste Group

We are using a graphical tool called PowerDesigner to create logical and physical models. From that, we create code that can be run by Oracle Data Integrator, which then maps the data based on these models and sends it to its destination. It is currently very integrated with Oracle The Oracle…

Read full review

Swati-Singh

Assistant consultant at Tata Consultancy

The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module.

Read full review

Oracle Data Integrator (ODI) mindshare

As of May 2025, the mindshare of Oracle Data Integrator (ODI) in the Data Integration category stands at 4.6%, up from 4.3% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Data Integration

PeerResearch reports based on Oracle Data Integrator (ODI) reviews

Type	Title	Date
Category	Data Integration	May 20, 2025	Download
Product	Reviews, tips, and advice from real users	May 20, 2025	Download
Comparison	Oracle Data Integrator (ODI) vs Azure Data Factory	May 20, 2025	Download
Comparison	Oracle Data Integrator (ODI) vs Informatica PowerCenter	May 20, 2025	Download
Comparison	Oracle Data Integrator (ODI) vs Informatica Intelligent Data Management Cloud (IDMC)	May 20, 2025	Download

Title	Rating	Mindshare	Recommending
Informatica Intelligent Data Management Cloud (IDMC)	4.0	4.4%	93%	183 interviews Add to research
Azure Data Factory	4.0	8.9%	92%	91 interviews Add to research

Valuable Features

Oracle Data Integrator provides advanced features like Knowledge Modules, dimensional modeling, and real-time data integration capabilities. Users highlight its flexibility, multi-technology connectivity, and powerful ELT architecture. Its ability to automate tasks, effective error management, and database engine utilization stand out. Developers value the ease of reusability and customization. ODI excels in creating efficient, rapid data transformation processes supporting diverse database environments, making it preferred for business intelligence projects and complex data integrations across various platforms.

"Oracle provides strong support. I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly."
"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."
"It effectively manages errors through its logging and exception-handling capabilities."

Room for Improvement

ODI users highlight several areas needing enhancement. Its interface, based on Java, is outdated and sluggish, causing development delays. There are calls for better integration with Oracle products and external tools like GIT, as well as improved error handling and version control. Scalability and real-time integration need attention. The tool is seen as complex, with a steep learning curve, and users request easier setup and lower licensing costs. Pricing models also require reevaluation to cater to smaller projects.

"ODI components may not fulfill as much as Informatica PowerCenter or IBM DataStage. The pushdown optimization is not as effective as other tools."
"The Oracle Data Integrator interface is extremely slow, especially when using remote desktop connections."
"There could be better compatibility with other ETL tools and cloud platforms."

ROI

Users experience strong returns from Oracle Data Integrator (ODI) when implemented properly. Its stability and automation lead to tangible savings in time and operational costs, enhancing investment value. While some encounter challenges with setup, the cloud version demonstrates the tool's capabilities effectively. Many find its cost justified, reporting enhanced operational efficiency and a reduction in effort for custom ETL solutions, thus demonstrating its impact on resource allocation and productivity.

Pricing

Oracle Data Integrator (ODI) pricing is considered expensive, with various licensing options depending on usage and deployment needs. While more costly for smaller companies, the cost can be justified for medium and large enterprises seeking robust integration solutions. Discounts and package deals might offer some relief, but the overall investment remains significant due to licensing complexity and additional costs for hardware and support. Despite its higher price, ODI's power and efficiency are valued by many enterprise users.

"I rate the platform pricing as five out of ten."
"The solution is very expensive."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."

Popular Use Cases

Users primarily utilize Oracle Data Integrator (ODI) for data integration across vast, complex environments. They integrate enterprise performance management applications, manage data warehouses, and move data between operational and cloud systems. ODI handles high-volume data loads, supports ETL processes, and performs data quality checks. Widely used in various industries, they benefit from its cloud integration capabilities, extensive use with Oracle databases, and ability to link diverse systems into centralized data repositories.

Service and Support

Many find Oracle Data Integrator's customer service efficient, with quick resolution for straightforward issues. However, technical support varies; some report helpful and knowledgeable staff, while others find delays, especially with complex multi-technology queries. Communication gaps between teams can hinder resolution, and response times for less urgent issues are often slow. Users appreciate the knowledge repository and educational resources, but improvements in support speed and coordination across diverse Oracle products are suggested.

Deployment

Users found the initial setup of Oracle Data Integrator (ODI) to be mostly straightforward, especially with Oracle's detailed documentation. However, some noted challenges with setting up schemas, repositories, and agents, requiring technical know-how, particularly for complex environments. Many acknowledged the importance of allowing enough time for setup and emphasized the learning curve involved. Despite this, the setup in version 12c was praised for being simpler and more accessible than previous versions.

Scalability

Oracle Data Integrator (ODI) has varied scalability experiences among users. Many find it effective for their needs without issues, while some mention configuration and environment factors affecting performance. Proper setup and updates enhance its ability to scale. Organizations, handling different user loads, appreciate its scalability, especially when integrated with other Oracle technologies. Scalability opportunities improve using WebLogic clustering. Users highlight that with the right environment and architecture, ODI can cater to both small and large enterprises.

Stability

Oracle Data Integrator (ODI) experiences mixed stability feedback. While early releases showed instability, subsequent versions, like 12.1.3, improved significantly. Older versions, such as 10g and 11g, maintained stable performance. Some instances report occasional issues, mainly due to Java memory leaks or integration challenges. Users appreciate its capacity for large-scale data processing and parallel executions, but some mention persistent stability issues that are often deployment-related. Customers highlight its reliability for regular use despite intermittent bugs.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Oracle Data Integrator (ODI) Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

12%

Government

10%

Manufacturing Company

Healthcare Company

Retailer

Energy/Utilities Company

Comms Service Provider

Insurance Company

University

Media Company

Construction Company

Educational Organization

Non Profit

Real Estate/Law Firm

Legal Firm

Outsourcing Company

Recreational Facilities/Services Company

Performing Arts

Hospitality Company

Transportation Company

Consumer Goods Company

Wholesaler/Distributor

Pharma/Biotech Company

Recruiting/Hr Firm

Logistics Company

Aerospace/Defense Firm

Marketing Services Firm

Engineering Company

Compare Oracle Data Integrator (ODI) with alternative products

Learn more about Oracle Data Integrator (ODI)

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

Oracle Data Integrator (ODI) was previously known as ODI.