Try our new research platform with insights from 80,000+ expert users
Oracle Data Integrator (ODI) Logo

Oracle Data Integrator (ODI) Reviews

Vendor: Oracle
4.1 out of 5
Leave a review

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 #8 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 66% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 18% of all views.
Buyer's Guide
Oracle Data Integrator (ODI)
August 2025
Get the report
Helped 866,218 peers since 2012

Featured Oracle Data Integrator (ODI) reviews

Read more reviews

Oracle Data Integrator (ODI) mindshare

As of August 2025, the mindshare of Oracle Data Integrator (ODI) in the Data Integration category stands at 4.2%, down from 4.3% compared to the previous year, according to calculations based on PeerSpot user engagement data.
Data Integration Market Share Distribution
ProductMarket Share (%)
Oracle Data Integrator (ODI)4.2%
Informatica PowerCenter8.1%
Azure Data Factory7.4%
Other80.3%
Data Integration

PeerResearch reports based on Oracle Data Integrator (ODI) reviews

TypeTitleDate
CategoryData IntegrationAug 29, 2025Download
ProductReviews, tips, and advice from real usersAug 29, 2025Download
ComparisonOracle Data Integrator (ODI) vs Azure Data FactoryAug 29, 2025Download
ComparisonOracle Data Integrator (ODI) vs SSISAug 29, 2025Download
ComparisonOracle Data Integrator (ODI) vs Informatica PowerCenterAug 29, 2025Download
Suggested products
TitleRatingMindshareRecommending
Informatica Intelligent Data Management Cloud (IDMC)4.04.3%93%186 interviewsAdd to research
Azure Data Factory4.07.4%92%92 interviewsAdd to research
 
 
Key learnings from peers

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
Company SizeCount
Small Business19
Midsize Enterprise9
Large Enterprise35
By reviewers
By visitors reading reviews
Company SizeCount
Small Business316
Midsize Enterprise200
Large Enterprise1008
By visitors reading reviews

Top industries

By visitors reading reviews
Financial Services Firm
18%
Government
9%
Computer Software Company
9%
Manufacturing Company
7%
Healthcare Company
5%
Comms Service Provider
5%
Retailer
5%
Energy/Utilities Company
4%
Insurance Company
4%
University
3%
Construction Company
3%
Educational Organization
2%
Outsourcing Company
2%
Media Company
2%
Performing Arts
2%
Non Profit
2%
Recreational Facilities/Services Company
2%
Consumer Goods Company
1%
Legal Firm
1%
Hospitality Company
1%
Transportation Company
1%
Pharma/Biotech Company
1%
Wholesaler/Distributor
1%
Real Estate/Law Firm
1%
Marketing Services Firm
1%
Recruiting/Hr Firm
1%
Aerospace/Defense Firm
1%
Logistics Company
1%

Compare Oracle Data Integrator (ODI) with alternative products

Go!

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.

Oracle Data Integrator (ODI) customers

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

Related questions

  • 73
Which ETL tool would you recommend to populate data from OLTP to OLAP?
  • 27
Oracle ICS vs ODI
  • 48
What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)
  • 260
Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
  • 510
What Is The Biggest Difference Between ODI and OIC?
  • 66
Looking for advice on how to invoke a select script through ODI?
  • 85
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
  • 37
What is the best suitable replacement for ODI on Azure?
  • 24
When evaluating Data Integration, what aspect do you think is the most important to look for?
  • 44
Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?

Product Categories

Product Categories
Data Integration

Popular Comparisons

Popular Comparisons
Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator (ODI) Logo
Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator (ODI)
Azure Data Factory vs Oracle Data Integrator (ODI) Logo
Azure Data Factory vs Oracle Data Integrator (ODI)
Informatica PowerCenter vs Oracle Data Integrator (ODI) Logo
Informatica PowerCenter vs Oracle Data Integrator (ODI)
SSIS vs Oracle Data Integrator (ODI) Logo
SSIS vs Oracle Data Integrator (ODI)
Teradata vs Oracle Data Integrator (ODI) Logo
Teradata vs Oracle Data Integrator (ODI)
Palantir Foundry vs Oracle Data Integrator (ODI) Logo
Palantir Foundry vs Oracle Data Integrator (ODI)
IBM InfoSphere DataStage vs Oracle Data Integrator (ODI) Logo
IBM InfoSphere DataStage vs Oracle Data Integrator (ODI)
Talend Open Studio vs Oracle Data Integrator (ODI) Logo
Talend Open Studio vs Oracle Data Integrator (ODI)
Oracle GoldenGate vs Oracle Data Integrator (ODI) Logo
Oracle GoldenGate vs Oracle Data Integrator (ODI)
SAP Data Services vs Oracle Data Integrator (ODI) Logo
SAP Data Services vs Oracle Data Integrator (ODI)
Qlik Replicate vs Oracle Data Integrator (ODI) Logo
Qlik Replicate vs Oracle Data Integrator (ODI)
Denodo vs Oracle Data Integrator (ODI) Logo
Denodo vs Oracle Data Integrator (ODI)
Fivetran vs Oracle Data Integrator (ODI) Logo
Fivetran vs Oracle Data Integrator (ODI)
Alteryx Designer vs Oracle Data Integrator (ODI) Logo
Alteryx Designer vs Oracle Data Integrator (ODI)
SnapLogic vs Oracle Data Integrator (ODI) Logo
SnapLogic vs Oracle Data Integrator (ODI)
See all alternatives
 
Oracle Data Integrator (ODI) Reviews Summary
Author infoRatingReview Summary
Works3.5I work at an insurance company using Oracle Data Integrator for our data warehouse, which excels in Oracle environments with its ELT system. However, it struggles with diverse infrastructures compared to tools like Informatica PowerCenter or IBM DataStage.
DWH Framework Architect at Erste Group4.0I am using Oracle Data Integrator for mapping data with models created in PowerDesigner, appreciating its robust development environment and support for various programming languages, though its slow interface and costly pricing model for Oracle Cloud pose challenges.
Technical lead at a transportation company with 10,001+ employees3.5No summary available
Assistant consultant at Tata Consultancy4.0No summary available
DBA at a comms service provider with 201-500 employees3.0We use Oracle Data Integrator for ETL in our data warehouse because of its fast ELT approach. However, the setup is complex, and due to its high cost, we're considering alternatives like Azure Data Factory to save money.
Data Engineer at Systems Limited3.5We utilize Oracle Data Integrator (ODI) for extracting, transforming, and loading data into systems like Azure and Salesforce. Its robust ETL capabilities and user-friendly features improve efficiency, although compatibility with other tools needs enhancement. The platform significantly reduces operational time and costs.
Founder at DEN21DS4.5ODI excels in data integration across diverse sources with efficient metadata handling, offering fast staging and data mark building. It could improve by enhancing feature streamlining and integration with other tools and focusing on consistent software quality and fixes.
Senior Data Archirect at Yettel5.0I use Oracle Data Integrator for our data warehouse integration. It's a powerful tool, surpassing previous solutions like Amazon Redshift and Informatica. However, I find the error handling in parallel load plan executions could be improved.