Coming October 25: PeerSpot Awards will be announced! Learn more
Julia Frohwein - PeerSpot reviewer
Senior Director of Delivery at PeerSpot (formerly IT Central Station)
  • 1
  • 9

What advice do you have for others considering Oracle Data Integrator (ODI)?

Hi community,

If you were talking to someone whose organization is considering Oracle Data Integrator (ODI), what would you say?

How would you rate it and why? Any other tips or advice?

PeerSpot user
10 Answers
Phil Wilkins - PeerSpot reviewer
Enterprise Integration Architect at Capgemini
Top 5Leaderboard
02 June 21

Like any product I'd try to understand how that product's roadmap might fit with your technology journey. If you're looking at ODI strategically, and get time to talk with Oracle Product Management. Whilst I can speak for all PMs in the organization those that I have dealt with are interested in understanding your needs, journey - you may express a unique position, or actually find that you're not the only one with the need.

Suruj  Nawosah - PeerSpot reviewer
Head of ICT at AfrAsia Bank Limited
Real User
Top 20
25 August 22

My advice to other people implementing this solution would be it is good as long as the context of the systems that they are using it. For example, if they are using a lot of Oracle technologies, then it makes sense to have ODI, otherwise, there are other tools that could make more sense. I rate ODI a seven out of ten.

Pujitha Gade - PeerSpot reviewer
Senior Plsql & ODI Developer at Infosys
30 April 22

Everything is good, and I would rate it an eight out of ten.

Technical Lead at Cognizant
Real User
Top 5
15 February 22

I would recommend using ODI if we are using an Oracle Database as your data warehouse, or as your primary database only. If not then I wouldn't recommend ODI to be used. I have seen the newer cloud version and I think it is more user-friendly than the older versions. I rate Oracle Data Integrator an eight out of ten.

Principal Consultant at a tech services company with 501-1,000 employees
Top 5
24 January 22

ODI is very friendly to those who have been traditionally writing a scale PL/SQL. It has lots of connectors to many different sources, although the target databases it supports are relatively limited compared to Informatica. It's also easier to understand, very developer-friendly, and has a big forum community and lots of documentation for support. I would rate it as nine out of ten.

Applications Support Manager at a marketing services firm with 1,001-5,000 employees
Real User
Top 20
18 November 21

I would recommend it if they were an Oracle house mostly. It works very well with other Oracle products. If a business is not an Oracle shop, I would not recommend it. OBI understands Oracle E-business, Oracle CRM, and other Oracle products well. However, if you were to go to another company that had different products, ODI would struggle. I rate Oracle Data Integrator an eight out of ten.

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
632,779 professionals have used our research since 2012.
Mohamed Ahmed Fouad - PeerSpot reviewer
Banking Excellence - Predictive Analysis at a financial services firm with 11-50 employees
Real User
Top 20
28 October 20

We're simply an Oracle customer. We don't have a business relationship with the company. There's no specific version of the solution that we use. I wouldn't recommend any other services above Oracle. Overall, I would rate the solution eight out of ten.

Muhammad Arif Javed - PeerSpot reviewer
Senior Manager Software Development at Techlogix
Real User
03 June 20

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

Alan Yves - PeerSpot reviewer
Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
04 May 16

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 implementation, but the results are great.

Ricardo Giampaoli - PeerSpot reviewer
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Top 5Leaderboard
01 May 16

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 first implementation. If something is implemented incorrectly at the start, it'll cost you a lot more to fix than to build a new system from scratch. Sometimes it can be so badly designed that it is impossible to fix. I've been working on implementations for 21 years and I have seen bad implementations everywhere. In fact, I have seen the same tools implemented in the same team by two different people, with one being a success and the other a failure. In the same company, one department says that the tool does not work for them and another says that the tool is the best. The only difference was the implementer. Make sure you get a good team to implement it. The tool has its flaws but most of time (99%) it is the implementer's fault that you have a bad or slow model.

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Nov 08, 2021
Why choose one over the other?
See 2 answers
Phil Wilkins - PeerSpot reviewer
Enterprise Integration Architect at Capgemini
03 November 21
Integration Cloud is more focused on event-driven integration models. It is also an OCI native service.  ODI is primarily suited to bulk data activities such as data loads, data migration. Now ODI has two flavours: native OCI with a small feature set aimed at enabling cloud migration and then the traditional ODI.  The traditional version is the same product as used on-premise but packaged to run a VM. As a result, it is offered on the Oracle cloud marketplace.
Dovid Gelber - PeerSpot reviewer
Tech blogger
08 November 21
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that come up, though, as far as integrating and maintaining the system. Organizations that choose this product will need to bring experts on board to oversee the security and system administration. Those aspects are so complex that to keep the system running smoothly and effectively, you need to employ people who know the proper IT procedures to manage them. Ultimately, an organization will have to make additional investments to get proper use out of Oracle Integration Cloud Service. Oracle Data Integrator offers a comparable level of set up complexity to Oracle Integration Cloud Service. The program for the initial setup does offer step-by-step instructions which make deployment easier. However, additional software such as Agent Setup is required for ODI to function fully. Therefore, while an organization can follow a guide to set up ODI, additional steps beyond the initial deployment are necessary before one can use the product fully. Oracle Integration Cloud Service offers different pricing models for their licenses. Among the easiest for businesses to deal with is a pay-as-you-go option. This provides organizations with great flexibility in choosing what they want to pay and the type of services that they want to receive. Organizations will be able to spend their resources more effectively when they control the prices that they are paying. ODI has a price which is not exactly the most expensive solution on the market. However, it is not the cheapest either. There is no flexibility in ODI’s pricing like there is for Oracle Integration Cloud Service. Organizations really only have two options: they can pay the price or use another product. ODI does not allow for the kind of customization that Oracle Integration Cloud Service offers. Conclusion Oracle Integration Cloud Service and Oracle Data Integrator are comparable as far as the difficulty that an organization might have in setting them and deploying them. In both cases additional resources are needed after the initial setup stages in order to get them set up properly. The area in which they truly differ is in the ability of Oracle Integration Cloud Service to be customized, both in terms of price and in terms of services obtained. ODI lacks this flexibility.
Ariel Lindenfeld - PeerSpot reviewer
Director of Content at PeerSpot (formerly IT Central Station)
Jul 08, 2021
Hi peers, When evaluating Data Integration tools, what aspects do you think are the most important to look for? Let the community members know what you think.  Thank you for sharing your knowledge!
2 out of 24 answers
PeerSpot user
Database And BI Developer at a tech consulting company
22 December 14
Data Quality, Data Volume, Frequency Of Update (Schedule) and Cross Object communication In an overview. There could other factors as well but primarily I will go to evaluate this.
PeerSpot user
Project Manager / Team Leader / Siebel Expert / Technical Architect at a tech vendor
10 March 15
Easy to use, Easy to manage
Download Free Report
Download our free Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
632,779 professionals have used our research since 2012.