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

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…

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) 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-25 of 29)
Companies can't remove reviews or game the system. Here's why
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
  • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
  • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
December 09, 2020

An Amazing ETL Tool!

Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Data processing is faster now.
  • Scheduling and managing batch jobs are easier which results in fewer failures.
  • Plenty of talent available in the market who can work on this tool.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • It has been cost-effective. It comes with a wide range of functionalities so we no longer need individual applications to handle individual tasks. We just need to run Oracle Data Integrator. So we save costs in that regard.
  • It has also simplified the process of learning ODI across my organization.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • I think it's a useful product to be able to make data warehouse and ETL designs. It is exceptionally compatible with Oracle databases.
  • I think the data transfer performance is adequate. With different scenarios, it is possible to increase data transfer performance with Oracle Data Integrator product.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • This is certainly within the budget and able to handle our ETL operations
  • Most of the errors can be monitored and cleared
  • We don't require real time integration but we always wanted the huge data to be processed which is a very good use for us
Ravi Krishna Gajula | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Fast development of integrations helped in getting projects done at a lower cost
  • Easy development and reuse of code helped developers and testers
  • Automatic code generation facility with knowledge modules helped developers with easy implementation of changes.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up.
  • Reduced lead time helped in reducing project cost as less resources were spent in data conversion project.
  • Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.
Paolo Borghi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • It's a quite expensive product, and its costs can be absorbed in some time, but it grants stability and great flexibility.
  • It can be used as a main tool to integrate data on different platforms and purposes, granting a greater Return on Investment by limiting the expenses on other more specialized products.
Jérôme Françoisse | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Thanks to the flexbility of the tool, we could build 3 mappings using variables and the substitution API in replacement of 300 mappings in Oracle Warehouse Builder. It's much easier to maintain.
Ely Turkenitz | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • With ODI, we are able to run our nightly ETL process at less than half the time it took before with OWB. This enables us to have the data warehouse updated and our BusinessObjects environment up and running 2 to 3 hours earlier than what we were used to.
  • For new projects, the ODI Data Transformation capabilities are saving us development time compared to what we had to do before with OWB.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Oracle Data Integrator has a positive impact on Return on Investment. The # 1 reason behind this is - Oracle Data Integrator replaces the need of other ETL tools used by individual departments with in our organization. This is a cost-effective solution with more benefits and a centralized solution.
  • Oracle Data Integrator requires less hardware resources compared to other comparable ETL tools. As this uses the processing power of source / target database, this requires less investment. Databases in any big organizations are highly powered and under-utilized at times.
  • As Oracle Data Integrator supports almost all the Operating Systems, this software doesn't require a special Operating System and maintenance team. This software can fit into the existing infrastructure, in most cases.
James Parks | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes.
  • Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment.
  • Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money.
Return to navigation