Oracle Data Integrator (ODI) Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Consultant
Technical Advisor at Gluent Inc
Oct 31 2016

What is most valuable?

The biggest feature for ODI is the fact that it uses the power of the source or target database to actually perform the ETL processing. So a typical data integration tool might have its own ETL engine, and that would be an additional server, additional costs, something else you have to maintain. ODI actually has the ability to create and generate code that runs... more»

What needs improvement?

One thing that is included, and it's going to improve, is the integration with a configuration management tool. Right now, they integrate with Subversion. And we know in the future, there's going to be more tools implemented there for configuration management and some new features there. So right now, it's kind of one of those features that, it's been released,... more»
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 non-Oracle vendors.

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 studio), but I do not think that any of them are worthy to be reported here.
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
291,145 professionals have used our research since 2012.
Consultant
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
Jun 04 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 take 10 times longer to do the same thing if you don't know how to use the tool. You have to know... 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 increase the performance and capability of all... 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 yourself. 12c implemented some things for which... more»
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...
Consultant
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
May 09 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 transactional systems, our data warehouses, and B2B integration. * ODI is really powerful for BI projects with traditional... 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 improved in next versions, so at last the 12C... more»
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 instead of Informatica. Relatively, I do not have a lot experience with a lot of VARs, but I've... 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 very efficient; very fast. We can easily customize and review even out-of-the-box analytics that... 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 been out for 4-5 years, there are still a lot of people who aren't using it or have opted to stay... more»
Consultant
Principal and Owner at Sandwich Analytics
Sep 28 2016

What is most valuable?

The most important aspect of the product is the ability to work with almost any data source or target. I can readily develop processes that use relational, file, XML, JMS messaging, web and big data sources or targets. I can control the style... more»

How has it helped my organization?

It allows a single skill set to handle virtually all of the data transport and transformation needs of a company. It moves the ETL processing to where the data resides and saves network traffic and the need for dedicated transformation... more»

What needs improvement?

There needs to better support of external version control software, currently only SVN is present, but I hear the GIT is planned in future patch. From a DevOps point of view it would be useful to add better separation between ‘code’ and... more»
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 implemented a script to bounce the agent nightly and this... more»
See 11 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.
291,145 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