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

Data Transformations

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

9.9
Avg 8.3

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

(26-29 of 29)
Companies can't remove reviews or game the system. Here's why
December 14, 2015

ODI - not necessarily an enterprise solution, but good enough for smaller financial systems implementations

Peter Shepherd | TrustRadius Reviewer
Peter Shepherd
Manager
Collaborative Solutions, LLC (Information Technology and Services, 201-500 employees)
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
In my prior role, I primarily used ODI as the ETL tool to transform data from relational systems or flat files into Hyperion Essbase. It was also the extraction tool from Essbase to various data marts/warehouses. ODI was used to map multiple source files/tables together, transform the data appropriately to align with Essbase nomenclature/naming conventions. ODI was also used as a scheduling tool to kick off command-line utilities specific to the Hyperion toolset and to manage interdependent data processing jobs for a given organization.
Pros and Cons
  • Transforms and loads large amounts of data (gigabyte and up).
  • Stores complex transformation logic in an understandable way that is easily updated after the fact.
  • Managed multiple ETL user groups/credentials to segment data availability and execution pathways.
  • ODI has a very arduous process for migrating components from one environment to another. I've found it to be error prone unless migrating a full schema which is not always a viable option.
  • ODI has no web-based administration panel, all admin tasks must be handled via hard install.
  • The scheduler tool is difficult to initially set up and not intuitive to manage. Takes a while to stand up properly.
Likelihood to Recommend
Oracle Data Integrator (ODI) is good when large amounts of data are to be processed and the ETL logic is maintained by a team of IT professionals. Where it loses out against other tools, is it cannot be managed by the data owner (i.e. finance) as the tool relies on SQL logic which is not always understood by the data owner. Coupled with the fact that it is not managed via the web but through hard install, it makes it difficult to diffuse ETL tasks from IT to the core business.
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.
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?
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 to navigation