Oracle Data Integrator (ODI) Room for Improvement

Ricardo Giampaoli
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
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 you have to use some specialized code automatically, like parallel data load, but it is slower to develop. For me, the best thing would be to merge the GUI from 11g into the capabilities of 12c. View full review »
Alan Yves
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
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 version the web service has been improved, some of the limitations of the 11g version were solved. Also, it would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons, although it looks like the cloud option offers some extra connectors (for example, in Salesforce CRM). View full review »
Rodrigo Radtke De Souza
Solutions Architect at a tech consulting company with 51-200 employees
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 in its last product version. In other words, if you wish to use ODI and HFM together, both from Oracle, you will need to create custom code, which does not make any sense to me. Another area to improve would be the development life-cycle, which did improve in the latest ODI version, but needs further improvements. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: October 2019.
371,062 professionals have used our research since 2012.
it_user521808
Development Manager
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 Informatica, which is a mature product. View full review »
John Kruebbe
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
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 them for me, then I might be interested in that as it provides me value. I can see a great deal of value of ODI plus an add-on solution that might know how to avoid performance issues on the target database with, for example, the proper use of SQL functions. View full review »
Muhammad Tahir
Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts. View full review »
Dava Wang(汪燊)
Data engineer at realestate.pingan.com
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. View full review »
Business677
Business Analyst at Paunaste OÜ
* ETL process registry solution is missing. * To manage dependencies between loading packages. * Versioning logic and release process are not well supported. View full review »
Jill Corcoran
User
It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses. View full review »
David Barragan
Principal Owner with 11-50 employees
* Click intensive on mapping * Lots of mouse clicking * GUI could be improved. View full review »
Rüdiger KOch
Team Leader Development with self employed
The performance of the user interface is in need of improvement. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: October 2019.
371,062 professionals have used our research since 2012.
Sign Up with Email