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
Score 7 out of 10
Vetted Review
Verified User
Incentivized
For our case, we use ODI as suggested by Oracle and integrated with other Oracle products. We are an Oracle shop and it has worked well when used as intended. We use it with the Oracle Utility Suite of products and SOA as well as with Oracle Utility Analytics and extractors. In both cases, it has delivered what we need, so I do not have any examples of it not working.
December 09, 2020

An Amazing ETL Tool!

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Cameron Gable | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is well suited for any extract, transform, and load processes someone needs. It is very versatile and allows for even very large amounts of data to be uploaded and transformed. It is especially useful for big data transformations. Any cloud users will find this tool very useful.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It is best to use Oracle Data Integrator when you need a data consolidation solution. It works effectively in that sense. We have also used it for multiple data integration projects where we had to load data warehouses. It worked efficiently. I would not recommend it if you are working with multiple SDLCs. It is not the best tool for multi-user development environments.
zahit bogus | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. In the Oracle Data Integrator ETL tool, you can quickly transfer and transform data by connecting source and destination databases with ODBC. You can run your millions of data transfers separately by dividing them into multiple packages. This will give you performance results in data transfer operations. JSON can issue ODI ETL product errors with XML data or in oracle external databases. Sometimes the solution to these errors can cause serious time losses.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Let me put it this way. If you're already using an Oracle product, this is a no-brainer. These products are made to work with each other. Not only that, but if you're familiar with all the shortcuts and you're working with datasets that need visualizations, Oracle Data Integrator product masterfully incorporates large datasets into a visualizer. It by far the best I've seen to date.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is easy to integrate with all kinds of resources. Strong connectivity for all databases (Oracle, MS SQL, MySQL, etc.) and contains many alternative features. For example, It offers scheduled operating steps, email alerts, etc.
Holman Cárdenas, M.Eng, TOGAF®, ITIL® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator (ODI) is a top choice when you want to integrate data from different and/or heterogeneous sources (any known database and a lot of types of valid files). Not suitable if you don't have well qualified IT professionals in your company since it is a complex tool.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • 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
September 18, 2019

ODI User Review

Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
Ravi Krishna Gajula | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
When we need to work with different sources within the same project, we are able to integrate from the sources and load to the one target. When we need to validate multiple files and load the data immediately in a loop, a simple code does the trick via Oracle Data Integrator. Whoever needs to extract, transform and load from any source can go do that with Oracle Data Integrator.
Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.
  • Variables can help you to perform loops and conditional statements in packages for helping ETL. What else do you need?
  • It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds.
  • Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
Paolo Borghi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized

Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).

I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.

It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.

Jérôme Françoisse | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Ely Turkenitz | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Well, if you are an Oracle shop, then ODI is clearly a very good choice. It is a much better tool than OWB has ever been; it is lightning fast (which really comes handy when you have to transform massive amount of data), and it gives Informatica a run for its money. It [has the] ability to support heterogeneous databases, big data, JMS, XML, and many other flavors.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Federico Shortrede | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized

Oracle Data Integrator (ODI) is great for integration between different Oracle data bases, and it also works well taking data from sources like Excel or SQL Server.

We’re not so sure about ODI’s performance when origins are “very far away”, for instance, in different servers connected through an MPLS, or between one “on premise” server with another “cloud server”. But perhaps it is due to lack of knowledge.

Carlos Sanz Porro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator (ODI) is recommended when you want to move data from heterogeneous sources. Also the multidisciplinary development is appropriate because when an object is being used, it appears locked by another user. ODI is a mature tool on the market.

A developer without advanced knowledge of SQL, can easily use the tool and generate complex queries against the database.
Samir Patel, PMP | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Incentivized
Oracle data integrator is best suited for Oracle Hyperion environments. When it comes to moving data to essbase and planning cubes, Oracle Data Integrator is the best tool for the job since the connectors are built in. SSIS for example is limited in this regard and could not accomplish the same task.
James Parks | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Oracle Data Integrator is a good solution for daily data warehousing needs. It is less suitable for business requirements that demand frequent data updates. Accessing static data with Oracle Data Integrator is much simpler than trying to extract, transform, and load dynamic data. It requires a skilled development team to use, so it is more appropriate in long term solutions where a team will be available to manage the code than it is for a short term solution.
Return to navigation