Oracle Data Integrator (ODI) Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
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... 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... 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... 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.
301,499 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...
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... more»

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

oracle would better provide these kind of information .

Which solutions did we use previously?

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»
Jose Ann Brown
Real User
Director - Special Projects at Sandals Resorts International
Dec 12 2016

What is most valuable?

The user interface for the data integrator tool is probably the most valuable piece. I'm a relatively newcomer to the ODI. We opted to use ODI... more»

How has it helped my organization?

We use ODI to extract and transform data to load into our data warehouse from our source system, which is Oracle EBS. We have found that it's... more»

What needs improvement?

Perhaps more learning resources related to ODI would be helpful. I'm not sure if that's what restricted the buy-in. Even though the product has... more»

Which solutions did we use previously?

We decided to move away from Informatica after we attended an Oracle conference about three years ago. We learned a lot more about where Oracle... more»

What other advice do I have?

You would have to evaluate what your key purpose is, and your existing, internal talent and experience. It's my belief that you should always... more»
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.

Which solutions did we use previously?

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»
it_user521922
Real User
Database Administrator at Tarrant County College
Dec 08 2016

What is most valuable?

The most valuable feature is being able to schedule the jobs, especially when they're multi-step.

How has it helped my organization?

I don't know why we have different database environments, but we do. The business wants the data to be collected in one place, so they can do reporting and so on.

What needs improvement?

I don't know if this is because of us or because of the tool, but sometimes I had a problem with the agent getting held up. I would come in and my jobs would be failing. Now I have... more»

What other advice do I have?

Good luck. I do think the training was beneficial but I know everybody doesn't have that as an option. If you do have the option to do some training, I think that could be a really... more»
it_user521808
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»

Which solutions did we use previously?

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... more»
See 7 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.
301,499 professionals have used our research since 2012.

Oracle Data Integrator (ODI) Questions

Oracle Data Integrator (ODI) Projects By Members

Oracle Data Integrator (ODI) Consultants

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
Not sure which Data Integration Tools solution is right for you?

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