2016-04-14T06:40:00Z

What needs improvement with Oracle Data Integrator (ODI)?


Please share with the community what you think needs improvement with Oracle Data Integrator (ODI).

What are its weaknesses? What would you like to see changed in a future version?

Guest
99 Answers

author avatar
Real User

The performance of the user interface is in need of improvement.

2019-07-12T20:52:00Z
author avatar
Top 20Real User

Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.

2019-05-05T21:16:00Z
author avatar
Top 5Real User

* ETL process registry solution is missing. * To manage dependencies between loading packages. * Versioning logic and release process are not well supported.

2019-01-24T16:35:00Z
author avatar
User

* Click intensive on mapping * Lots of mouse clicking * GUI could be improved.

2018-11-25T02:07:00Z
author avatar
User

It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.

2018-08-02T16:51:00Z
author avatar
Real User

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.

2018-03-01T08:21:00Z
author avatar
Top 5Consultant

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).

2016-05-04T06:03:00Z
author avatar
Top 5LeaderboardConsultant

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.

2016-05-01T11:30:00Z
author avatar
Consultant

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.

2016-04-14T06:40:00Z
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.