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

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?

16 people also want pricing

Alternatives Pricing

Astera Data Pipeline Builder (Centerprise)

Astera Data Pipeline Builder (Centerprise)

N/A
Unavailable
What is Astera Data Pipeline Builder (Centerprise)?

Astera Data Pipeline Builder is a no-code solution for designing and automating data pipelines. It allows users to read and write data across various file formats, databases, and applications. Users can execute ETL and ELT pipelines manually, schedule automated reruns, or integrate them into…

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

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
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 15)

ODI User Review

Rating: 7 out of 10
Incentivized
September 18, 2019
Verified User
Analyst in Finance and Accounting
Internet Company, 201-500 employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
4 years of experience
Use Cases and Deployment Scope
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.
Pros
  • They connect to financial tools such as Hyperion.
  • Holds financial data very well and easily retrieved when needed.
  • All the support teams are very helpful and there when you need them
Cons
  • Speed can sometimes be very slow.
  • You need many technical support individuals to maintain.
  • N/A
Likelihood to Recommend
Oracle Data Integrator is a great tool to use when you do detailed financial planning and analysis. You can create multiple scenarios. For example, you can create best case, reasonable case, and worst case scenarios on Hyperion and use that to understand different scenarios in order to hedge for risk in your forecast.

Oracle Data Integrator--a great tool for Oracle users

Rating: 8 out of 10
Incentivized
December 04, 2020
Verified User
Manager in Engineering
Hospitality Company, 51-200 employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
5 years of experience
Use Cases and Deployment Scope
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.
Pros
  • It is well integrated within the Oracle ecosystem
  • Great product for data cleansing and virtualization
  • Can have everything done in one tool in most cases
  • It has great scalability/performance
Cons
  • Oracle support is not the best when needing help with the system
  • The documentation is also very poor and takes very long to generate
  • Some parts of it are not intuitive to use and get hard to troubleshoot
  • Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
  • Like all Oracle products, cost is high
Likelihood to Recommend
Oracle Data Integrator is best used for data warehousing, master data management, data migration, big data integration, and application integration. If you have an environment that is in the Oracle platform, this tool also works great with it. We have been using it as an ETL tool to get data from the different Oracle systems we have, and it works great. However, it does not work great with different environments if you have multiple types of systems. You will find yourself buying more than one application to satisfy your needs.

ODI Review

Rating: 5 out of 10
Incentivized
July 29, 2014
Verified User
Team Lead in Information Technology
Government Relations Company, 501-1000 employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
11 years of experience
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
  • Incremental data loads
  • Complex Transformations
  • Detailed documentation of LKM/IKM
  • Troubleshooting of failed jobs
Cons
  • 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.

An Amazing ETL Tool!

Rating: 9 out of 10
Incentivized
December 09, 2020
Verified User
Employee in Information Technology
Banking Company, 10,001+ employees
Vetted Review
Verified User
Oracle Data Integrator (ODI)
2 years of experience
Use Cases and Deployment Scope
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.
Pros
  • It is very easy to integrate with Oracle data sources at backend.
  • Plenty of transformation options and reverse engineering is bit easier.
  • The interface is very simple and user friendly.
Cons
  • Real time integration is bit of a hassle.
  • Customer Support could be improved to some extent.
  • Data ingestion with variety of data sources could be difficult to implement.
Likelihood to Recommend
This is an amazing ETL Tool if you have multiple Oracle source databases. But could be hassle if there are multiple other data sources as it's bit complicated to integrate with them. Overall this is a tool that will optimize and facilitate the integration of data in a fairly simple and integrated way.

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.
Return to navigation