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?

9 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

(126)

Attribute Ratings

Reviews

(1-25 of 29)
Companies can't remove reviews or game the system. Here's why
Ojas Elawadhi | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use this Data Integrator tool to handle ETL(Extract, Transform and Load) part of large volume of data to fulfil our stakeholder requirements. This tool does a really great job to handle good amount of data from various sources and maintain the business intelligence system. This tool is being used in specific departments for now.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Currently, ODI is used within a few departments of our organization. We utilize it with other Oracle Utility Applications and Middleware (SOA) as an ETL tool. We have a number of interfaces linked with our Oracle Databases and the ODI layer is used to do transformations. We also use it as part of Oracle Utility Analytics with their extractors and it is integrated with part of our GoldenGate Setup.
December 09, 2020

An Amazing ETL Tool!

Score 9 out of 10
Vetted Review
Verified User
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 being done through PL/SQL which was bit complex to learn for everyone. So it was decided to use Oracle Data Integrator as a formal ETL Tool. This is being used in specific departments as of now. This is an amazing tool to implement different transformation logics in an easier way and is quite efficient in handling the data which ends up in saving user's time.
Lakhan Suri | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use data integrator to handle large amount of data, bulk batch loads,use it for data transformation and integration with different platforms. We use this for our client request to fulfill their requirement. We are working in insurance industry in which lots of data from different sources needs to be handled. It solve our purpose to mange large volume of data from different sources.
Cameron Gable | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
There are many products that do extract, transform, and load on data sets. It is a core task for any data engineer or data analyst. Alongside Oracle Cloud, we use Oracle Data Integrator to run ETL processes on our data. We use it widely to maintain our business intelligence systems.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is a very good ETL tool that can be used for many different business cases. We currently use it as an ETL application that ties into many of our backend systems. It helps us connect with many systems with the great integrations it has and gives us the ability to closely tie our data together. We use this for our data teams currently which then gets used for reports, etc. to make workflow and processes more streamlined.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We often work with Oracle database products and Oracle Data Integrator has been really useful for EPMA integration. It allows us to have a vivid understanding of topological data. It helps us clarify loose ends as it concerns the plotting of data modules. It provides a significant improvement in clarity that helps us identify issues at job locations. It has been really helpful in visualizing the data set and centralizing company data.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is used in enterprise projects designed for data warehouse and ETL. It makes sense for us to use the ODI ETL product, especially since the databases we work with are usually oracle products. You can create individual ETL packages with the Oracle Data Integrator ETL product. You can schedule these ETL packets at certain time intervals. You can generate summary tables using aggregate functions in an Oracle Data Integrator product. In this way, you can create data march tables to be used in the data warehouse. The end-user interface of the Oracle Data Integrator product has an intricate appearance. The ETL design screen needs to be more straightforward and more user-friendly. Also, connections to databases other than Oracle can fail after certain periods of time.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are currently using the Oracle Data Integrator in order to fully understand and visualize topological data. We find the visualizations are quite wonderful for presentations and has recently been used to identify issues in certain locations of our jobsite. I highly recommend plotting the data in the module as it has done wonders for our field staff. If you're have repeat issues in a certain location but have not been able to find the continuity along a dataset. I beg you to try using this module.
Holman Cárdenas, M.Eng, TOGAF®, ITIL® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator (ODI)is probably the best ETL tool in the market. We use it in order to integrate data from several different sources (mainly Oracle and SQL Server) and load the processed data into our Data Warehouse, applying some basic data quality rules (not the main function of ODI, but it has some small data quality features).
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use many Oracle products and Oracle Data Integrator provides a graphical environment to do an overall process unlike other ETL tools in the market. This is simple to connect with Oracle databases and the inbuilt functions/features is very useful to overcome the common issues.

It handles a large quantity of data with ease and is powerful for processing ETL.
September 18, 2019

ODI User Review

Score 7 out of 10
Vetted Review
Verified User
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 connects with financial tools such as Hyperion. I utilize Hyperion to pull data from Oracle Data Integrator and use that as a leverage to build a company's financial projections. However, I think one big issue is that it can be quite slow during busy times. I think speed is one of the most essential things for the monthly close process.
Ravi Krishna Gajula | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It's used in critical integration projects to address the problems of integrating with multiple formats of various sources. We are able to debug at different log levels. It's easy to reuse components and it's helped in avoidance of any hard coding. It's easy to develop, maintain, configure and secure. We have the ability to call scripts,. The PL/SQL routines along with its regular mappings helped to avoid use of multiple tools.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator was used along with Oracle Goldengate product to consolidate data into Oracle database from other data resources in other DBMS and ETL jobs. The data was integrated or converted into using target format using Oracle Data Integrator.
Ashwini Chandorkar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is being used in an organization that provides an online assessment platform, for which I work as a freelancer. Based on the unique E-LT architecture, the need for an ETL server sitting between the source and target server gets removed. Elimination of ETL server and ETL engine reduces the maintenance costs and thus reduced learning curve reduce the overall labor costs of the company. According to the current situation, Oracle Data Integrator supports RDBMSs such as Oracle, Sybase IQ, and Exadata.
Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.

Paolo Borghi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized

In my organization, my department develops business intelligence solutions for our worldwide customers, whose business can be in any kind of sector. In this scenario, ODI is being used to integrate data among all the pieces of the software architecture, connecting Oracle and non-Oracle technologies.

In my 6 years experience, I used ODI to:
- feed up relational environments, like Data Warehouses or Data Marts models with reporting purposes
- feed up Hyperion Planning, Hyperion Essbase, Hyperion Financial Management or INFOR applications, for our customers' controllers
- read data from Oracle and non-Oracle technologies (i.e.: SAP, SQL Server, INFOR, and many other), thanks to all ODI's connectors and interpreter
- schedule tasks and workflow, independently from the operating system, thanks to ODI's agent (the service that controls all the tool's tasks).

ODI helps integrating data across different sources and targets, executing operating systems command, managing mistakes or discards, logging all the operations performed by the integration flows and scheduling those flows.

Jérôme Françoisse | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator (ODI) enabled us to assist our customers loading their data warehouse and get insights from their data both in batch mode or in real-time. We helped customers in various fields: finance, gambling, telecom, transportation, education etc.

Ely Turkenitz | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have a large data warehouse that consolidates data from three different case management systems. We use Oracle Data Integrator (ODI) as the primary ETL tool for transporting the data into the data warehouse. Prior to ODI, we used Oracle Warehouse Builder (OWB) for Oracle databases and Microsoft SSIS for SQL Server databases. ODI replaced them both. We found ODI to be a very powerful, full-feature ETL tool, and it's lightning fast, too.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator (ODI)is a powerful ETL tool. We use this across the organization to integrate data from various sources (mainly Peoplesoft) and load the processed data into Oracle Data Warehouse. The Data Warehouse loaded by ODI acts as a single source of truth for every department within the organization. All the department's raw data is pulled by ODI and processed before loading into Data Warehouse. Though this is a backend tool, which many front end users are not aware of its existence, it does a great job integrating data from different sources.
Carlos Sanz Porro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are currently using ODI for large companies that have the need to generate and consolidate information, move data, transform and consolidate data.

The great quality of ODI, is that it is able to connect to any database and source (xml , txt, SOZ ) both source and target. ODI is all possible, we have not seen in the position of a customer asks us something that ODI can not do . Thanks to that we can modify its core, we can do anything.

ODI allows the multidisciplinary development, its own versioning, and integration with any language (Python , Groovy , t - SQL).
Samir Patel, PMP | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is being used to move meta data from our repository that sits in SQL Server to the Hyperion Planning application. It is being utilized by our Finance department and it allows them to use the planning application efficiently to create budget and forecast information for the current year.
James Parks | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is used to extract data from various manufacturing machines, transform it into a usable form, and load it into a data warehouse for use by Oracle Business Intelligence reports. In this case, it was used to attempt a "real-time data warehousing solution," which is not necessarily its intended operation. Data was provided every hour, as required by the client. It was used across the whole organization to help with various decisions, including but not limited to manufacturing quality, resource tracking, accountability, and equipment usage.
Return to navigation