No more typing reviews! Try our Samantha, our new voice AI agent.
Oracle Data Integrator (ODI) Logo

Oracle Data Integrator (ODI) Reviews

Vendor: Oracle
4.0 out of 5
Leave a review

What is Oracle Data Integrator (ODI)?

Oracle Data Integrator offers flexible EL-T architecture, optimizing processing with database capabilities. It supports diverse data sources, automates deployment, and provides efficient data transformations, making it suitable for data warehousing and complex data environments.

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), Teradata 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.0 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 58% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 16% of all views.
Buyer's Guide
Oracle Data Integrator (ODI)
April 2026
Get the report
Helped 893,164 peers since 2012

Featured Oracle Data Integrator (ODI) reviews

Read more reviews

Oracle Data Integrator (ODI) mindshare

As of May 2026, the mindshare of Oracle Data Integrator (ODI) in the Data Integration category stands at 2.5%, down from 4.5% compared to the previous year, according to calculations based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Oracle Data Integrator (ODI)2.5%
SSIS3.7%
Informatica Intelligent Data Management Cloud (IDMC)3.6%
Other90.2%
Data Integration

PeerResearch reports based on Oracle Data Integrator (ODI) reviews

TypeTitleDate
CategoryData IntegrationMay 8, 2026Download
ProductReviews, tips, and advice from real usersMay 8, 2026Download
ComparisonOracle Data Integrator (ODI) vs Informatica Intelligent Data Management Cloud (IDMC)May 8, 2026Download
ComparisonOracle Data Integrator (ODI) vs SSISMay 8, 2026Download
ComparisonOracle Data Integrator (ODI) vs Informatica PowerCenterMay 8, 2026Download
Suggested products
TitleRatingMindshareRecommending
Informatica Intelligent Data Management Cloud (IDMC)4.03.6%92%214 interviewsAdd to research
Teradata4.11.0%88%83 interviewsAdd to research
 
 
Key learnings from peers
Last updated Mar 29, 2026

Valuable Features

Oracle Data Integrator's most valuable features include its EL-T approach, flexibility, and extensive connectivity with various technologies like RDBMS, Hadoop, and cloud services. The Knowledge Module system simplifies integration processes through reusable modules. ODI enhances data replication and transformation, enabling real-time integration with high efficiency. Users appreciate its compatibility, which allows leveraging existing database capabilities. Its architecture eliminates the need for additional hardware, reducing costs and improving processing speed.
  • "Integration with all systems is easy with Oracle Data Integrator, and it is easy to use."
  • "ODI is very friendly to those who have been traditionally writing a scale PL/SQL."
  • "ODI's most valuable features are it utilizes the database engine and is very lightweight."

Room for Improvement

Oracle Data Integrator (ODI) requires enhancements in user interface performance, real-time integration, and multi-user development. Improvements in version control, error handling, and the initial setup process are needed. Integration with platforms like Hyperion Financial Management, streamlined project navigation, and lower pricing are also areas of concern. Strengthening compatibility with other tools and adding AI capabilities for data quality would further enhance its usability and efficiency.
  • "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."
  • "An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
  • "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."

ROI

Oracle Data Integrator (ODI) offers a significant return on investment, with many users praising its cost-effectiveness, automation, and efficiency. It reduces time and effort on custom ETL solutions, leading to tangible savings. Proper implementation is crucial for quick returns, although some experience challenges in setup. Many acknowledge the tool's stability and long-term benefits. The cloud version helps demonstrate its powerful capability in practice.

Pricing

Oracle Data Integrator’s pricing and licensing can be complex, with options like per seat or target core count. Costs vary based on usage, deployment model, and the inclusion of additional Oracle products, like cloud services. While ODI can be more expensive than other integration tools, its robust capabilities justify the cost for larger enterprises. Licensing typically involves an annual fee, making it less affordable for smaller companies, but reasonable for mid-sized ones.
  • "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

Oracle Data Integrator (ODI) is primarily used for extracting, transforming, and loading (ETL) data from diverse sources into data warehouses. It supports moving data between on-premises and cloud environments, managing large data volumes, and integrating with enterprise applications. Users leverage it for complex environments, data quality checks, transaction processing, digital health, and integration with external partners, utilizing SQL, MySQL, and Oracle databases for data migration and reporting.

Service and Support

Oracle Data Integrator (ODI) customer service scores high for its promptness and efficiency, while technical support shows mixed feedback. Users often cite efficient and knowledgeable assistance, though others mention long response times and difficulties with multi-technology issues. Support quality seems to depend on ticket severity, with high-priority issues resolved promptly. Many find self-troubleshooting effective, using Oracle's resources. While many rate support positively, some express dissatisfaction with complex ticket resolutions. Response times vary per issue priority.

Deployment

The initial setup of Oracle Data Integrator is described as straightforward by multiple users, with some noting that it is simple, particularly compared to similar tools. However, challenges arise with setting up agents and configuring repositories. The process varies in complexity based on the environment, requiring expertise for certain configurations. Documentation is regarded as helpful. Some users experienced complexities with architecture considerations, prolonged deployments, and technical requirements, but these improved significantly with version updates.

Scalability

Oracle Data Integrator (ODI) is generally scalable, successfully meeting user needs in various environments. Users report effective performance, with occasional issues linked to setup or environment conditions. Leveraging WebLogic for clustering and maintaining system configurations optimizes scalability. Resource demands can increase with multiple jobs, requiring careful management. Organizations with diverse user profiles, from occasional to heavy usage, find ODI adapts well. Version updates contribute to enhanced scalability, supporting larger user bases effectively.

Stability

Oracle Data Integrator (ODI) is considered stable with most users reporting no major issues. Many observed improvements in recent versions, though some encountered problems with specific versions or configurations. While the 12.1.2 release was noted as buggy, newer versions show enhanced performance, addressing earlier concerns. Instances of crashing or performance issues are often linked to deployment or patching. Users value its flexibility and efficiency, although a few noted slower interface performance or issues with large datasets.
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 Business21
Midsize Enterprise9
Large Enterprise36
By reviewers
By visitors reading reviews
Company SizeCount
Small Business287
Midsize Enterprise146
Large Enterprise602
By visitors reading reviews

Top industries

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

Compare Oracle Data Integrator (ODI) with alternative products

Go!

Learn more about Oracle Data Integrator (ODI)

Oracle Data Integrator leverages EL-T architecture to enhance processing by utilizing database strengths. It integrates with a wide array of technologies, including RDBMS, cloud, and big data. The software's Knowledge Modules enable customizable integration strategies, accelerating development. With a user-friendly interface and automation features, it simplifies metadata management and supports real-time data warehousing. Key areas such as UI performance, integration, and real-time data capabilities require enhancements. Challenges include error handling, initial setup, and compatibility with platforms like Git, Azure, and IoT services. Improvements in metadata management, scalability, and user-friendliness are needed.

What are the most important features of Oracle Data Integrator?
  • EL-T Architecture: Optimizes data processing by leveraging database capabilities
  • Knowledge Modules: Customizable strategies for faster development
  • Integration Support: Handles RDBMS, cloud, and big data
  • Automation: Facilitates rapid deployment and transformations
  • Real-Time Data Warehousing: Supports continuous data integration
What benefits and ROI should users consider?
  • Flexibility: Adapts to multiple data integration needs
  • Efficiency: Leverages existing database engines for optimal ETL functionalities
  • Scalability: Manages complex, large-scale environments
  • Cost-Effectiveness: Supports diverse data sources and technology platforms

Organizations utilize Oracle Data Integrator primarily in data warehousing, handling data from ERP systems, EBS, Fusion, and cloud databases. It aids in creating data lakes, OLTP migrations, digital health initiatives, and automation tasks, ensuring seamless integration with databases like MySQL and SQL Server.

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

  • 95
Which ETL tool would you recommend to populate data from OLTP to OLAP?
  • 68
Oracle ICS vs ODI
  • 38
What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)
  • 132
Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
  • 127
What Is The Biggest Difference Between ODI and OIC?
  • 50
Looking for advice on how to invoke a select script through ODI?
  • 84
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
  • 64
What is the best suitable replacement for ODI on Azure?
  • 73
When evaluating Data Integration, what aspect do you think is the most important to look for?
  • 94
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)
Teradata vs Oracle Data Integrator (ODI) Logo
Teradata vs Oracle Data Integrator (ODI)
SSIS vs Oracle Data Integrator (ODI) Logo
SSIS vs Oracle Data Integrator (ODI)
Informatica PowerCenter vs Oracle Data Integrator (ODI) Logo
Informatica PowerCenter vs Oracle Data Integrator (ODI)
Qlik Talend Cloud vs Oracle Data Integrator (ODI) Logo
Qlik Talend Cloud vs Oracle Data Integrator (ODI)
Palantir Foundry vs Oracle Data Integrator (ODI) Logo
Palantir Foundry vs Oracle Data Integrator (ODI)
Azure Data Factory vs Oracle Data Integrator (ODI) Logo
Azure Data Factory vs Oracle Data Integrator (ODI)
SAP Business Data Cloud vs Oracle Data Integrator (ODI) Logo
SAP Business Data Cloud vs Oracle Data Integrator (ODI)
Fivetran vs Oracle Data Integrator (ODI) Logo
Fivetran vs Oracle Data Integrator (ODI)
Denodo vs Oracle Data Integrator (ODI) Logo
Denodo vs Oracle Data Integrator (ODI)
SnapLogic vs Oracle Data Integrator (ODI) Logo
SnapLogic vs Oracle Data Integrator (ODI)
Oracle GoldenGate vs Oracle Data Integrator (ODI) Logo
Oracle GoldenGate vs Oracle Data Integrator (ODI)
IBM InfoSphere DataStage vs Oracle Data Integrator (ODI) Logo
IBM InfoSphere DataStage vs Oracle Data Integrator (ODI)
SAP Data Services vs Oracle Data Integrator (ODI) Logo
SAP Data Services vs Oracle Data Integrator (ODI)
Pentaho Data Integration and Analytics vs Oracle Data Integrator (ODI) Logo
Pentaho Data Integration and Analytics vs Oracle Data Integrator (ODI)
See all alternatives
 
Oracle Data Integrator (ODI) Reviews Summary
Author infoRatingReview Summary
Head of Data Services – Services Partner at 3 As Technologies4.0I've used Oracle Data Integrator for six years to streamline ETL processes with strong transformation capabilities, metadata integration, and flexible deployment. While stable and fairly priced, it could improve scalability and unify its interface for better usability.
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.
Software Engineer at a financial services firm with 10,001+ employees4.0I use ODI for data integration, appreciating its ELT architecture for optimizing data movement. Setup was straightforward, and it's stable for 500 users. I'd like to see AI capabilities added, but I haven't measured its ROI.
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.
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.
Technical lead at a transportation company with 10,001+ employees3.5I use ODI for data warehousing, valuing its strong integration and stability. I find real-time integration and broader publisher support need improvement. Setup was straightforward, and pricing is good, but technical support could be better.
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.