Oracle Data Integrator (ODI) Reviews

Ricardo Giampaoli

EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees

Feb 05 2020

We can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools.

What is most valuable?

It's the best tool for data integration. It can do anything you want, but the only downside is that you need to know what you are doing. You can take 10 times longer to do the same thing if you don't… more»

How has it helped my organization?

For the EPM environment, the ODI is the key to transforming a good project into a great project. With ODI, we can make all the EPM tools work together as one and we can create a puzzle that will… more»

What needs improvement?

Right now, we have two very different GUIs - 11g and 12c. 11g is faster to develop than 12c as it takes more steps to do exactly the same as 11g, but you have a lot of things that you need to do… more»

What's my experience with pricing, setup cost, and licensing?

All tools are expensive, but I think ODI is the most expensive since it depends on your sources and target databases. I think the best way to go is by doing packages and try to include free tools (if… more»

What other advice do I have?

Because Oracle products are development frameworks, your final results are as good as the people that implemented it. Make sure that your implementation team is the best it could be, at least for the… more»

Which other solutions did I evaluate?

I'm a consultant and my only evaluation was on the database. I decided on Oracle because of the database and during my career, their other tools are starting to come naturally.

4 comments

See Entire Oracle Data Integrator (ODI) Review (875 Words) »

Alan Yves

Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees

Mar 18 2019

All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.

What is most valuable?

There are several very important features that we use daily. * All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration. * ODI is really… more»

How has it helped my organization?

All projects where I have implemented ODI solution highly benefited of high data volume integration.

What needs improvement?

There is always room for improvement, even when something is really good, but I think ODI is one of the best ETL tools in the market. However, I've always waited for the web service feature to be… more»

What's my experience with pricing, setup cost, and licensing?

oracle would better provide these kind of information .

Which solution did I use previously and why did I switch?

Besides ODI I have used SSIS and Power Center Informatica, both are similar and typical ETL tools, ODI up until 11g version had some differences, for example in ODI 11g we call the integration object… more»

What other advice do I have?

The setup of the environment requires experts on site, but it is very worth it since at first for customers it can be quite complex. The vendor needs to enable the customer on a frequent basis during… more»

1 comment

See Entire Oracle Data Integrator (ODI) Review (695 Words) »

Download Free Report

Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: February 2020.

Download now

397,408 professionals have used our research since 2012.

Rodrigo Radtke De Souza

Solutions Architect at a tech consulting company with 51-200 employees

Dec 05 2019

If it doesn't connect out-of-the-box to a specific technology, we can add a new technology into it.

What is most valuable?

ODI has the ability to connect to virtually any technology out there. If it does not connect out-of-the-box, we can very easily add a new technology into it. This flexibility gives a tremendous developmental advantage to its users, which… more»

How has it helped my organization?

We use ODI to integrate all Oracle EPM suite used in our financial area. ODI is the core engine used to move data across different applications every day. It’s by far the most important architectural element in our BI/EPM environment since… more»

What needs improvement?

In my opinion, ODI should connect to ALL Oracle products out-of-the-box, but currently that’s not the case for all of them. Hyperion Financial Management (HFM) is one of the Oracle products for which Oracle decided to remove its ODI support… more»

Which solution did I use previously and why did I switch?

I've always worked with ODI for ETL development.

Which other solutions did I evaluate?

ODI was the only option we considered.

1 comment

See Entire Oracle Data Integrator (ODI) Review (613 Words) »

Muhammad Tahir

Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees

May 08 2019

A reduction in manual work during data integration is a welcomed improvement

What is most valuable?

We can easily create ETL processes and schedules. We can check logs on a daily basis. It handles multiple routines very smartly.

How has it helped my organization?

Before adopting this solution we used to work hard. We now feel better because our manual work is completely over.

What needs improvement?

Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.

What's my experience with pricing, setup cost, and licensing?

We found that the cost compared to other integration tools is a little high, but the solution works great.

Which solution did I use previously and why did I switch?

Before this solution, we were using SQL Server.

Which other solutions did I evaluate?

We evaluated SQL Server prior to choosing this solution.

1 comment

See Entire Oracle Data Integrator (ODI) Review (283 Words) »

Dava Wang（汪燊）

Data engineer at realestate.pingan.com

Aug 01 2018

Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.

What is most valuable?

Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.

How has it helped my organization?

In our DW/BI solution, ODI is the main tool to integrate the data as a daily batch. Besides loading data, we do most of our transformations in ODI. ODI is quick to use.

What needs improvement?

The ODI scheduler for agent sometime fails with no sign, which impact the ETL solution severely. The property window in the ODI studio always does not refresh as it should. Sometimes, the mapping or package automatically gets edited.

Which solution did I use previously and why did I switch?

Informatica and SSIS are also good ETL tools besides ODI.

Which other solutions did I evaluate?

Basically the ETL tools is determined by the database.

3 comments

See Entire Oracle Data Integrator (ODI) Review (257 Words) »

Business Analyst at Paunaste OÜ

Jan 29 2019

Knowledge modules can be modified to fix small issues

What do you think of Oracle Data Integrator (ODI)?

What is our primary use case?

To have a common ETL tool in the DW team, start a common way of ETL development, set up a process registry, and daily process flow.

How has it helped my organization?

It increased ETL development efficiency 1/3 in time. It has a short learning curve for newcomers, compared to previous MS DTS packages and scripting.

What is most valuable?

Reusing existing ETL development pattern in the next similar tasks. It's flexible to add new common procedures. Knowledge modules can be modified to fix small issues.

What needs improvement?

ETL process registry solution is missing. To manage dependencies between loading packages. Versioning logic and release process are not well supported.

For how long have I used the solution?

Three to five years.

See Entire Oracle Data Integrator (ODI) Review (137 Words) »

Jill Corcoran

User

Aug 05 2018

It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses. It does have the ability to easily load slowly changing dimensions

What do you think of Oracle Data Integrator (ODI)?

What is our primary use case?

High volume batch loads to move data from transactional systems into the decision support warehouse.

How has it helped my organization?

It worked fine, but we needed a tool that would include quality and master data seamlessly. This is more of a standalone ETL tool.

What is most valuable?

I found nothing overly amazing about this tool, although I appreciate its ability to easily load slowly changing dimensions.

What needs improvement?

It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.

For how long have I used the solution?

Less than one year.

See Entire Oracle Data Integrator (ODI) Review (136 Words) »

David Barragan

Principal Owner with 11-50 employees

Nov 27 2018

I like the separate environments for dev, test and prod from one management facility, though the GUI could be improved.

What do you think of Oracle Data Integrator (ODI)?

What is our primary use case?

Multiple data sources: "Most" of them, Oracle databases (some MS SQL, some Sybase, lots of files and some web services). Because the environment was overwhelmingly Oracle, ODI (we started from OWB) was a much better and cost-effective solution for us than Informatica.

How has it helped my organization?

Far more efficient and robust than OWB, (it was the natural evolution for us).

What is most valuable?

Separate environments for dev, test and prod from one management facility.

What needs improvement?

Click intensive on mapping Lots of mouse clicking GUI could be improved.

For how long have I used the solution?

Three to five years.

See Entire Oracle Data Integrator (ODI) Review (131 Words) »

See 1 More Oracle Data Integrator (ODI) Reviews

Articles

User Assessments By Topic About Oracle Data Integrator (ODI)

Download Free Report

Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: February 2020.

Download now

397,408 professionals have used our research since 2012.

Oracle Data Integrator (ODI) Questions

What is Oracle Data Integrator (ODI)?

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Also known as

ODI

Oracle Data Integrator (ODI) customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University

Read Archived Reviews