Oracle Data Integrator (ODI) Reviews

Oracle Data Integrator (ODI) is the #6 ranked solution of our top Data Integration Tools tools. It's rated 4.3 out of 5 stars, and is most commonly compared to Informatica PowerCenter - Oracle Data Integrator (ODI) vs Informatica PowerCenter

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Brian Dandeneau
Consultant
Business Process and Strategy Specialist Advisor at NTTData
Jun 17 2020

What is most valuable?

The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull… more »

How has it helped my organization?

I have used ODI to improve run-times of many corporations' overall integration run-times. Corporations on a daily basis run integration jobs which normally take five hours or more. I have seen these… more »

What needs improvement?

Error handling can always be improved with ODI. A lot of the errors are generic, but I will say that with a little experience, you can decipher the errors to help you fix them. In fact, I find myself… more »

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

I would say that you need to pay attention to the licensing to make sure that you are not paying to much. Normally, the licensing can be your friend if you don't need ODI for anything complex. You can… more »

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

I work on all the other integration products as well as ODI. In fact, I had to compare all the integration products (ODI, SSIS, HAL, Informatica, DataStage) when we were trying to decide on the… more »

What other advice do I have?

Know what you are getting into. If you are going to use a firm to build out a solution, ask for a Proof of Concept and ask them to show you how flexible it can be. If they can't quickly come up with… more »
Ricardo Giampaoli
Consultant
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Jul 08 2020

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.
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,517 professionals have used our research since 2012.
Alan Yves
Consultant
Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
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 »
Muhammad Arif Javed
Real User
Senior Manager Software Development at Techlogix
Jun 10 2020

What is most valuable?

There are number of valuable features in this tool: * Declarative design * Client-server architecture model. * Very good user access model * Pre-built user profiles… more »

How has it helped my organization?

Oracle Data Integrator offers a declarative style ETL development, where you mainly use pre-built knowledge modules for doing integration tasks. As a developer, you don't… more »

What needs improvement?

There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice… more »

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

ODI has bit on higher end in setup and pricing but it has more power as well. So it depends on your use.

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

I didn't switch any tool. I'm a professional developer and my tool selection is based on client requirements. I've used both SSIS and ODI for different clients.

What other advice do I have?

I think different tools have their own pros and cons, so it all depends on your overall needs.

Which other solutions did I evaluate?

No, my selection was based on client's choice.
Rodrigo Radtke De Souza
Consultant
Solutions Architect at a tech consulting company with 51-200 employees
Oct 05 2020

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.
Muhammad Tahir
Real User
Assistant Manager - MIS Analyst at TCS Private Limited
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.
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.
David Barragan
User
Principal Owner at New Frontier Professionals LLC
Nov 27 2018

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 1 More Oracle Data Integrator (ODI) Reviews

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 Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros sharing their opinions.