Skip to main content
TrustRadius
Oracle Data Integrator (ODI)

Oracle Data Integrator (ODI)

Overview

What is Oracle Data Integrator (ODI)?

Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.

Read more
Recent Reviews

An Amazing ETL Tool!

9 out of 10
December 09, 2020
Incentivized
As a number of our back end databases are Oracle based, so an ETL tool was required to handle all the data pipelining. Earlier it was …
Continue reading

ODI User Review

7 out of 10
September 18, 2019
Incentivized
I think that Oracle Data Integrator is effective in terms of keeping a database of financial information and it is also helpful since it …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Connect to traditional data sources (11)
    9.9
    99%
  • Complex transformations (11)
    9.9
    99%
  • Simple transformations (11)
    9.9
    99%
  • Business rules and workflow (11)
    9.1
    91%
Return to navigation

Pricing

View all pricing
Oracle Data Integrator (ODI)

Oracle Data Integrator (ODI)

N/A
Unavailable

What is Oracle Data Integrator (ODI)?

Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

10 people also want pricing

Alternatives Pricing

SolarWinds Task Factory

SolarWinds Task Factory

N/A
Unavailable
What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…

Dataloader.io

Dataloader.io

$99
per month
What is Dataloader.io?

Dataloader.io delivers a cloud based solution to import and export information from Salesforce.

Return to navigation

Product Demos

Oracle Data Integrator(ODI)|| Oracle Data Integrator Strategy

YouTube

Oracle Data Integrator(ODI) || ODI XML to DataBase Part-1

YouTube

Oracle Data Integrator(ODI) demo video | ODI Tutorials

YouTube

Oracle Data Integrator(ODI)|| ODI Interview questions

YouTube

ODI INTRODUCTION Demo: RR ITEC, Hyderabad, India

YouTube

Oracle Data Integrator(ODI) || Introduction

YouTube
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

9.6
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

9.9
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

9.2
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

9.1
Avg 8.2
Return to navigation

Product Details

What is Oracle Data Integrator (ODI)?

Oracle Data Integrator offers Bulk Data Movement and Data Transformation. It offers extract load and transform (ELT) technology that operates even across heterogeneous systems.

Features include :

-ELT architecture
-Heterogeneous platform support for enterprise data integration
-Knowledge modules for optimized developer productivity and extensibility
-Service-oriented data integration and management for SOA environments


Oracle Data Integrator (ODI) Video

What is Oracle Data Integrator?

Oracle Data Integrator (ODI) Competitors

Oracle Data Integrator (ODI) Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.

IBM InfoSphere Information Server, Talend Data Fabric, and Informatica Cloud Data Integration are common alternatives for Oracle Data Integrator (ODI).

Reviewers rate Connect to traditional data sources and Simple transformations and Complex transformations highest, with a score of 9.9.

The most common users of Oracle Data Integrator (ODI) are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(125)

Attribute Ratings

Reviews

(1-4 of 4)
Companies can't remove reviews or game the system. Here's why
November 07, 2017

Data Warehouse Architect's Review of Oracle Data Integrator

Gurcan Orhan | TrustRadius Reviewer
Gurcan Orhan
Senior Solutions Architect
Ekol Logistics (Information Technology and Services, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Oracle Data Integrator (ODI) is used to integrate applications, bulk data movement and of course to load a data warehouse environment.

ODI helped me to reduce a slowly changing dimension type 2 with the same output, from 22,000 seconds to 168 seconds. [I] Manage to load 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300 GB of data per day.

Pros and Cons
  • ODI is a tool that can talk or learn how to talk, with any database or operating system in its own language, this is the power of ODI!
  • I managed to connect to an Ingress Database, within 3 days of time (it is not supported out of the box).
  • When a new version of source and/or target database supports new data types, it takes my 5 minutes to implement it into ODI and immediately start using it.
  • Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step.
  • Easy to learn & develop. It takes your 3 days to learn ODI and be an "intermediate ODI Developer", if you know how to write SQL.
  • Big data connectors are implemented since ODI 11.1.1.7 (out-of-the-box) and upper version that support many well-known Big Data architecture.
  • Knowledge Module architecture helps you to build your data integration activities with less effort.
  • They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
Likelihood to Recommend
  • You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.
  • Variables can help you to perform loops and conditional statements in packages for helping ETL. What else do you need?
  • It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds.
  • Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
Oracle Data Integrator (ODI) Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
98%
9.8
Data model creation
100%
10.0
Metadata management
100%
10.0
Business rules and workflow
100%
10.0
Collaboration
90%
9.0
Testing and debugging
100%
10.0
Data Governance (2)
100%
10.0
Integration with data quality tools
100%
10.0
Integration with MDM tools
100%
10.0
Return on Investment
  • It made a tremendous job, all the developers across the organisation learnt ODI rapidly and started to develop. ODI became the strategic ETL tool and data integration tool for my company.
Alternatives Considered
Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment.
  • Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler.
  • BI Tools: OBIEE, Cognos, Microstrategy, Business Objects, Qlikview, Tableau.
  • ETL Tools: ODI, OWB, IBM Data Stage, SAP Data Services, Informatica, Microsoft SSIS, Pentaho, Talend.
Other Software Used
Users and Roles
50
Architect and developer.
Support Headcount Required
50
Knowledge of intermediate SQL language makes an intermediate ODI developer after 2 days of training. Straight forward design and easy to learn.
Business Processes Supported
  • Loading Data Warehouse
  • Performing Data Quality
  • Scheduling
  • On the fly incremental update for different database technologies
  • Fully customized depending on the business needs.
Innovative Uses
  • Connecting and receiving data from very very old database management systems.
  • Calling operating system routines to output for OLTP tasks.
Future Planned Uses
  • Enhancements in multiuser development environment
Likelihood to Renew
10
ODI is your power to any kind of database, operating system, big data or others.
April 29, 2015

My days with ODI

Verified User
Team Lead in Information Technology
Retail Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Use Cases and Deployment Scope
Its been used as part of the Integration team. The tool is used to move data between any two systems. It helps moving large volumes of data among systems in batch mode.
Pros and Cons
  • You need not worry about technology, it basically supports anything under the sun which has a JDBC or ODBC driver.
  • Has enough key metrics (KMs) that come with the tool, that we can change and customize it as required to the organization.
  • It supports batch loads to most databases which improves time and efficiency.
  • Its not like other ETL tools where it resides on its own world. The transformations happen on the either the source or target and we can use what best suits the technology we are working on.
  • It does not have all bells and whistles. Needs more integration with Mainframe.
  • Currently it does not have any KMs that load binary files in batch mode to any database.
  • There can be lot of change to the UI, which are normal stuff.
Likelihood to Recommend
It is best suited for large volumes of data in batch mode.
Return on Investment
  • Oracle support is not productive when it comes to ODI
  • Getting resources is a pain
  • Quick turn around time in building code
Likelihood to Renew
9
It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
Implementation Rating
7
August 04, 2014

Only ETL tool I know that works the way it is claimed

Verified User
Professional in Information Technology
E-Learning Company, 1001-5000 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
ODI is used in our team to deliver Data warehouse reporting data.
Pros and Cons
  • ELT functionality to improve the performance of the data load
  • Able to work with different rdbms and file structures without any issue.
  • Adaptability to learning the tool and implementing the projects required by the company.
  • The GUI or ODI studio has Garbage Collector problems like freezing up if used for a long time without closing the studio.
  • ODI 12c has got it, but 11g has a restriction in terms of loading data into multiple targets in the same interface.
Likelihood to Recommend
The whole knowledge of how ODI works and what customizations can be done using ODI's key metrics. Some key questions to ask are:
Which objects do what in ODI?
How are objects migrated between different environments?
How are agents set up and what are their uses? How do you schedule scenarios?
What different types repositories does ODI use?
Return on Investment
  • ODI is a low money tool compared to other ETL tools in the market.
  • Over all product development becomes efficient as a result of these low cost tools.
Alternatives Considered
IBM Infosphere, Informatica. I worked on the mentioned tools as well as ODI. I liked ODI because it is easy to use with great features that every other ETL tool has in the market.
Likelihood to Renew
10
The only reason for this rating is I guess the usability of the tool .
July 29, 2014

ODI Review

Verified User
Team Lead in Information Technology
Government Relations Company, 501-1000 employees
Score 5 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Oracle Data Integrator was used to pull the Oracle BPM data into data mart. It was being used across the whole organization. It pulled the data from various sources and pushed it to a single source with very complex transformations. Master and incremental data was being loaded into the data warehouse.
Pros and Cons
  • Incremental data loads
  • Complex Transformations
  • Detailed documentation of LKM/IKM
  • Troubleshooting of failed jobs
  • More user friendly interface
  • Hierarchy flattening transformations
  • Integration issues with SAP HANA
Likelihood to Recommend
For simple transformation and small business it is very good ELT tool but if you look for the big business and the complex transformation it has gaps to fill for example Hierarchy flattening jobs or multi language translation jobs etc. will make this tool good to use in big organizations.
Return on Investment
  • LKM/IKL customization is complex
  • Processing speed issues in complex transformations
  • Easy troubleshooting
Alternatives Considered
Our organization was using the Oracle BPM and the Oracle Data Integrator has good integration with BPM. We got good support from Oracle in setting up the integrated environment.
Likelihood to Renew
5
ODI is very good tool for the small business and less complex transformation but when I have a big client and their requirement is complex then chances are that I would recommend Informatica instead of ODI.
Return to navigation