Oracle Data Integrator (ODI) Room for Improvement

Brian Dandeneau
Business Process and Strategy Specialist Advisor at NTTData
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 not using the debugger that came out with 12c, just because I have learned to read "ODI-login-eze." If there was a way to keep the basic user from creating a monster SQL that kills a system on execution, that would be great as well. View full review »
Ricardo Giampaoli
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
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 DWgrain (Client Health BIS)
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 »
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,164 professionals have used our research since 2012.
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
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 to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue. Error descriptions should be easy and specific to actual problems rather than generic lengthy descriptions. Also, another main feature that should be readily available is that there should be a source component available that can extract data from a source based on the custom query rather than giving a source data store only in the mapping. 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 »
Mohamed Ahmed Fouad
Banking Excellence - Predictive Analysis at a financial services firm with 11-50 employees
The resource management aspect of the solution could be improved. The migration process could be easier. Technical support could be better. They're okay, however, their service could improve a bit. The solution could be more reliable. View full review »
Muhammad Tahir
Assistant Manager - MIS Analyst at TCS Private Limited
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts. 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 »
Rüdiger KOch
Team Leader Development at DB Systel
The performance of the user interface is in need of improvement. View full review »
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,164 professionals have used our research since 2012.