Oracle Data Integrator (ODI) Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
Paolo Borghi
Consultant
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
Aug 24 2017

What is most valuable?

It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from… more»

How has it helped my organization?

My organization develops solutions using all the Oracle EPM products, and ODI has helped us to integrate all the different technologies.

What needs improvement?

I think that the product as an overall solution is good. I would only point out some minor bugs or glitches in the development interface (ODI… more»

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

Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good.

What other advice do I have?

Always keep in mind that ODI offers a huge number of solutions to any task you are developing. There is not a best practice in solving a problem… more»
Ricardo Giampaoli
Consultant
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
Nov 05 2018

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… 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… 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… 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… 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… more»
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: February 2019.
316,786 professionals have used our research since 2012.
Magda Barska
Consultant
Consultant at a tech consulting company with 1,001-5,000 employees
Jan 28 2018

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

The new release of Oracle Data Integrator (ODI 12c) is now available. Let´s find out what the new features of ODI12c are that this version includes. First, is there anything fancy in the installation process? Just one note here: to be able to use ODI Studio, the enterprise installation needs to be selected (instead of the Standalone option) while launching the ODI installation program. For the configuration part, creating a new login to ODI repository you are requested to specify a new wallet password. ODI12c provides you with a possibility to store your credentials in a wallet that is protected by a password. How much it helps to protect and manage your credentials with a single password! Goodbye Interfaces, Welcome Mappings First of all, we do not deal with…
Alan Yves
Consultant
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
Oct 17 2018

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… 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… more»

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

oracle would better provide these kind of information .

If you previously used a different solution, which one did you use and why did you switch?

Besides ODI I have used SSIS and Power Center Informatica, both are similar and typical ETL tools, ODI up until 11g… 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… more»
Rodrigo Radtke De Souza
Consultant
Sr. Consultant - Software Development at a tech company with 10,001+ employees
Jan 21 2019

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… 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… 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… more»

If you previously used a different solution, which one did you use and why did you switch?

I've always worked with ODI for ETL development.
Gurcan Orhan
Consultant
Data Quality Software Development Manager at Yapı Kredi Bank
Mar 24 2017

What is most valuable?

Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of… more»

How has it helped my organization?

It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds… more»

What needs improvement?

They need to work on the multiuser development environment and include the ability to comply with different kinds of… more»

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

There are various options in licensing, either per seat or per target core count. It depends how you want to use it.

If you previously used a different solution, which one did you use and why did you switch?

We switched because of ODIs impressive increasement in development productivity.

What other advice do I have?

If you want a robust, flexible solution with no extra hardware that is easy to learn, then ODI is the right product for… more»
Anonymous User
User
Development Manager
Nov 22 2017

What is most valuable?

It is an ETL tool, which does the extract, transform, and load.

What needs improvement?

At this point we are seeing what we need, so I don't know if there is anything, any big improvements that are needed. This is basically just transforming and loading the data. It's… more»

If you previously used a different solution, which one did you use and why did you switch?

We chose ODI because we have the Oracle Stack and we wanted to be in the Oracle space. We wanted a tool that will work long-term for Oracle, so that's why we chose ODI.

What other advice do I have?

I would definitely recommend the ODI. The reason is that now Oracle, after a long time, has put its weight behind an ETL tool, which is ODI, and so Oracle is going to stand behind it… more»
Jérôme Françoisse
Consultant
Consultant - Oracle ACE with 51-200 employees
Aug 25 2017

What is most valuable?

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… more»

How has it helped my organization?

Thanks to the flexbility of the tool, we could build 3 mappings using variables and the substitution API in replacement of 300 mappings in Oracle Warehouse Builder. It's much easier… more»

What needs improvement?

- Development Lifecycle - native REST integration - Easier security

If you previously used a different solution, which one did you use and why did you switch?

I used Oracle Warehouse Builder (OWB) which is now at the end of its life. ODI is much more flexible and has the great advantage to be able to connect to a lot of different source or… more»
See 8 More Oracle Data Integrator (ODI) Reviews

Articles

User Assessments By Topic About Oracle Data Integrator (ODI)

Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: February 2019.
316,786 professionals have used our research since 2012.

Oracle Data Integrator (ODI) Questions

Oracle Data Integrator (ODI) Projects By Members

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

BUYER'S GUIDE
Download our free Data Integration Tools Report and find out what your peers are saying about Oracle, Informatica, Microsoft, and more!

Sign Up with Email