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
Ricardo Giampaoli
Consultant
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
Sep 05 2019

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.
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…
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: November 2019.
383,725 professionals have used our research since 2012.
Alan Yves
Consultant
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
Mar 18 2019

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»
Rodrigo Radtke De Souza
Consultant
Solutions Architect at a tech consulting company with 51-200 employees
Dec 05 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 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.
John Kruebbe
Real User
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
Jan 21 2018

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»
Muhammad Tahir
Real User
Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees
May 08 2019

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.
Dava Wang(汪燊)
Real User
Data engineer at realestate.pingan.com
Aug 01 2018

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.
Real User
Business Analyst at Paunaste OÜ
Jan 29 2019

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 3 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: November 2019.
383,725 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
Sign Up with Email