Oracle Data Integrator (ODI) Pros and Cons
Oracle Data Integrator (ODI) Pros
All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.View full review »
It's completely user-friendly.View full review »
The installation of the client ODI Studio is easy.
Besides loading data, we do most of our transformations in ODI.
In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.
Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.View full review »
It has the ability to easily load slowly changing dimensions.View full review »
The most valuable feature that we use is the Knowledge Modules.View full review »
Oracle Data Integrator (ODI) Cons
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasonsView full review »
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.View full review »
The stability of the software could be improved. Sometimes, the software just crashes. View full review »
It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.View full review »
The performance of the user interface is in need of improvement.View full review »