Oracle Data Integrator | ODI | 100% vendor neutral comparison
Passionned Group is a leading analyst and consultancy firm specialized in Business Analytics and Business Intelligence. Our passionate advisors assist many organizations in selecting the best Business Analytics Software and applications. Every two years we organize the election of the smartest company.

Integrating data

Oracle Data Integrator Enterprise Edition 11g delivers high-performance data movement and transformation among enterprise platforms with its open and integrated E-LT architecture. Including built-in connectivity to all major databases, data warehouses, service oriented architectures, business intelligence, Oracle Data Integrator Enterprise Edition helps lower total cost of ownership among data-centric architectures.

other ETL tools

Which features does Oracle Data Integrator (ODI) support?

If you want to know how Oracle Data Integrator scores on different key selection criteria and exactly which functionality it provides. We did all the work for you. Suppliers will often tell you only the strengths of their product(s). In our vendor neutral survey, all the features are revealed, including the weak points. Why buy our 100% independent survey?

Information from the vendor

How easy is the product to use?

Oracle Data Integrator provides a declarative rules driven approach that greatly reduces the learning curve of the product and increases developer productivity while facilitating ongoing maintenance. The approach separates the definition of the processes from their actual implementation, and separates the declarative rules (the ‘what’) from the data flows (the ‘how’). Training is only 4 days, and developers tout about how easy it is to use.

Declarative rules

ODI seperates the logical design from the pyhsical implmentation allowing the ETL developer to develop on mapping for many physical implementations. ODI’s metadata is stored in an open relational repository which could be extracted and consumed by CWM compliant tool.  MITI provides bridges for ODI which are CWM compliant.


Oracle Data Integrator provides a full debugger for development where the ELT steps can be run step by step. Oracle Data Integrator processes can be run row by row by using the row by row knowledge modules. Overall, records can be processed in row by row, in batch or near real time as required by the enterprise. For production systems it is recommended to process records in set processing mode for Oracle Data Integrator’s ELT architecture performance edge. Records from multiple and diverse sources can be processed simultaneously.

Data Quality

Oracle Data Integrator supports referential integrity and basic cleansing. Due to its architecture, the product can validate referential integrity before loading the data, as part of the loading process, providing clean data. This process provides analysis of the data quality based upon the validation of the usability of the data according to criteria defined by the end user. Some examples of data quality checks used to enforce data standardization include: simple reference (foreign key), complex references (based on data in other tables), mandatory (not null), data type, uniqueness (primary key/ unique key), etc.

Data cleansing in the name/address scrubbing, fuzzy logic sense can be done through the integration of Oracle Enterprise Data Quality, or other external products.

ODI helps improve productivity

An easy-to-use interface combined with a rich extensibility framework helps improve productivity and lower development costs. Oracle Data Integrator Enterprise Edition is fully integrated with Oracle Fusion Middleware, Oracle Database, and Exadata to put data at the center of your enterprise. In addition, Oracle Data Integrator Enterprise Edition is open and standards-based to work with 3rd party applications as well as Oracle’s applications.


“Oracle sites will no longer (have to) look outside”

Rick van der Linden, senior analyst and author of the ETL Tools & Data Integration Survey said about Oracle Data Integrator (ODI): “Our expectation is that many of the existing Oracle sites will no longer (have to) look outside for solutions to their Data Integration problems.” Find out more and order now the ETL Tools & Data Integration Survey 2018.

100% vendor independent research

In the ETL Tools & Data Integration Survey 2018 you’ll find the list of ETL tools in the market, including for each ETL solution an expert review, many comparison graphs and a comparison matrix with all the details. And a thorough 100% vendor independent evaluation of Oracle Data Integrator (ODI) and all the major ETL tools with all their features.

to the etl tools survey

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with oracle data integrator (odi) or other things that will make you smarter.

Daan van Beek, Managing Director


Managing Director

contact me directly

Fact sheet

Number of organizations serviced
Number of training courses
Number of participants trained
Overall customer rating
Number of consultants & teachers
Number of offices
Number of years active