Skip to main content
TrustRadius: an HG Insights Company
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

Learn from top reviewers

ODI Tool for Huge Data

Rating: 8 out of 10
June 4, 2021
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
Ojas Elawadhi
Analyst - Information Technology
Data Analyst
Paytm
Oracle Data Integrator (ODI)2 years of experience

What i think about Oracle Data Integrator

Rating: 8 out of 10
December 9, 2020
IncentivizedVetted ReviewVerified User
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 req...
Continue reading
Lakhan Suri
Engineer - Information Technology
SQL AND BI Developer
Carmen Solutions
Oracle Data Integrator (ODI)2 years of experience

Oracle Data Integrator is great for any ETL use cases

Rating: 8 out of 10
December 4, 2020
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
Cameron Gable
Engineer - Research & Development
Software Engineer III
Serimmune Inc.
Oracle Data Integrator (ODI)1 year of experience

Oracle Data Integrator review

Rating: 9 out of 10
February 28, 2020
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
zahit bogus
Consultant - Information Technology
Business Intelligence Consultant
EMO A.Åž
Oracle Data Integrator (ODI)1 year of experience

Oracle Data Integrator enthusiast!

Rating: 10 out of 10
October 25, 2019
IncentivizedVetted ReviewVerified User
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...
Continue reading
Holman Cárdenas, M.Eng, TOGAF®, ITIL®
Strategist - Information Technology
CIO (Chief Information Officer)
Mutual Ser EPS
Oracle Data Integrator (ODI)1 year of experience
Log in with LinkedIn to see content from your network
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?

17 people also want pricing

Alternatives Pricing

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.

Toad Data Point

Toad Data Point

$365
What is Toad Data Point?

Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and…

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

Data Transformations

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

9.9
Avg 8.2

Data Modeling

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

9.2
Avg 7.9

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

Compare with

Oracle GoldenGate

Oracle GoldenGate

Compare
SQL Server Integration Services

SQL Server Integration Services

Compare
Matillion

Matillion

Compare
Informatica PowerCenter (legacy)

Informatica PowerCenter (legacy)

Compare
Talend Data Integration

Talend Data Integration

Compare
Oracle Data Integration Platform Cloud (DIPC)

Oracle Data Integration Platform Cloud (DIPC)

Compare
SolarWinds Task Factory

SolarWinds Task Factory

Compare
Azure Data Factory

Azure Data Factory

Compare
dbt

dbt

Compare
Astera Data Pipeline Builder (Centerprise)

Astera Data Pipeline Builder (Centerprise)

Compare
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 19)

Oracle Data Integrator - The real data integrator

Rating: 8 out of 10
Incentivized
November 21, 2016
Verified User
Consultant in Information Technology
Higher Education Company, 5001-10,000 employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
4 years of experience
Use Cases and Deployment Scope
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.
Pros
  • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
  • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
  • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
  • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
Cons
  • The Java framework does not stand up to the mark. It crashes frequently. There is a long [list] of improvements required in terms of client tools framework.
  • Though Oracle Data Integrator lets people login from a web browser to monitor different activities, it crashes and performs very poorly when logged in out of network. Even Oracle Data Integrator client tools don't perform well on a remote desktop. Increasing Java buffer is one of the workarounds, that might work. So, a better client tools and interface is a big advantage.
  • Navigation is another pain area. It is very difficult to find out the precise error, in case of a failure, in Oracle Data Integrator. In Informatica, it is a cake walk to pull out a session log that shows up the exact reason for failure. Although Oracle Data Integrator is tightly integrated to database, it is very poor in providing the exact error at high level. One has to dig through to get it.
Likelihood to Recommend
I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator.
1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc.
2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools.
3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations.
4. Speeds up the development and maintenance by reducing the code that developers need to write.

ODI: Flexibility, reusability and performance for data integration with various source and target technologies.

Rating: 9 out of 10
Incentivized
June 22, 2017
Use Cases and Deployment Scope
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.

Pros
  • The EL-T approach that will first load into the target dataserver before doing the transfer is a great architecture improvement compared to standard ETL tools that use a staging area and usually process the data in Java. With ODI, almost all the job is pushed down on the underlying technology, for instance the Oracle Database or the Spark server.
  • The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance.
  • ODI is really the tool for any kind of integration because it speaks the language of the technology we connect. We can work with RDBMS but also in Hadoop, cloud services, flat files, web services, etc.
Cons
  • Continuous integration is missing and would be a really nice feature to enforce a good development lifecycle.
  • Better handling of files and folders, to be able to easily go through all the files of a folder.
  • Security setup is not easy to maintain.
Likelihood to Recommend
ODI can access a large range of technologies as source or target so it's suited for most of the loadings. For efficient change data capture and streaming, I would recommend other tools for the ingestion part though, like Oracle Golden Gate and Apache Kafka which are dedicated to that. File processing is not that easy in ODI so if it's your main use case you might want to look at another tool.

Oracle Data Integration (ETL for Huge Data)

Rating: 8 out of 10
Incentivized
September 19, 2019
Verified User
Team Lead in Information Technology
Computer Software Company, 10,001+ employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
2 years of experience
Use Cases and Deployment Scope
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.
Pros
  • It has a graphical environment which is easy to understand
  • Lightweight designer which is very easy to view and edit the objects with ease
  • All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
Cons
  • It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are depreciated simply for commercial reasons, although it looks like the cloud option offers some extra connectors.
  • It is not very good for real time data integrations.
Likelihood to Recommend
  • When we use Oracle JDE, EBS, Hyperion with lot of customizations
  • When huge data integrations are needed but there is no need for real time integration
  • Error monitoring required unlike Flat File Integrations which won't have good error monitoring
  • Complementary products like Hyperion are already in place with ODI licenses included

Oracle Data Integrator - used for data consolidation and integration project.

Rating: 9 out of 10
Incentivized
December 13, 2018
Verified User
Employee in Information Technology
Information Technology and Services Company, 10,001+ employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
2 years of experience
Use Cases and Deployment Scope
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.
Pros
  • Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
  • Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
  • Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.
Cons
  • Still complex product to use for ETL developers. Needed lot of training and testing before it could be implemented in production data conversion.
  • Initial set up was resource intensive on machine and manpower used on this project.
  • Better GUI interface with less options should be designed for Big data integration tool.
Likelihood to Recommend
Well suited for data consolidation into data warehouse type of database from multiple sources in real time.

Oracle Data Integration: A Data Connectivity tool

Rating: 8 out of 10
Incentivized
November 14, 2017
Use Cases and Deployment Scope
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.
Pros
  • It supports all platforms, hardware and OSs with the same software.
  • It utilizes the source and target server to perform complex transformations without the need of ETL server sitting between source and target server which makes architecture more simple and efficient.
  • Data Connectivity is very good as it supports all RDBMSs.
Cons
  • When you develop on ODI studio, you need to restart the program as it occupies a lot of RAM.
  • It is not meant for real time data integration.
  • It is hard to maintain the security setup.
Likelihood to Recommend
ODI data transformation capabilities are saving our development time as compared to previous projects.
Return to navigation