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

Sep 05 2019

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 (864 Words) »

Magda Barska

Consultant at a tech consulting company with 1,001-5,000 employees

Jan 28 2018

The enhanced security model and debugger are nice new features while the new layout is an advantage and disadvantage

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…

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

Download Free Report

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

Download now

366,918 professionals have used our research since 2012.

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 .

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 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 (701 Words) »

Rodrigo Radtke De Souza

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

Jul 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»

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.

Which other solutions did I evaluate?

ODI was the only option we considered.

1 comment

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

Development Manager

Nov 22 2017

Extracts, transforms and loads the data, does the job for us

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 doing its job. I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to… 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, which means that it has a long life. That's another reason which we chose it. Informatica is a gold standard in ETL… more»

1 comment

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

John Kruebbe

Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees

Jan 21 2018

Could use an add-on solution that might know how to avoid performance issues. Benefits from not having to maintain a separate ETL instance.

What is most valuable?

It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases. Going forward, that is very important.

How has it helped my organization?

The tool is declarative, and it only runs on the target staging databases, so I have full control over it and I can change the SQL that the tool generates. I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.

What needs improvement?

When I do a BI type of project, I like to pick the simplest declarative solution that I can find. So ODI appeals to me at a base solution level, but that sometimes puts a lot of burden on me personally to fix all of the nuances of the platform that I am integrating to and from. Some might argue this is just a part of the job, but if there is an add-on tool to hide the performance issues and solve… more»

See Entire Oracle Data Integrator (ODI) Review (298 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.

If you previously used a different solution, which one did you use and why did you 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 (289 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.

If you previously used a different solution, which one did you use and why did you 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 (252 Words) »

See 5 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: August 2019.

Download now

366,918 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

BUYER'S GUIDE

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

Download Now