Oracle Data Integrator Reviews & Product Details

The ELT (Extract, Load, Transform) architecture is a major advantage because it leverages the processing power of the target database rather than relying on a separate ETL server. I also highly value the Knowledge Modules (KMs), which provide reusable, plug-and-play templates for common integration tasks, significantly speeding up development time Review collected by and hosted on G2.com.

The learning curve is quite steep, especially for developers transitioning from traditional ETL tools, as the declarative design and KM structure require deep technical knowledge. Additionally, the Java-based UI (ODI Studio) can feel sluggish at times, and Oracle’s technical support can be slow to resolve complex troubleshooting tickets Review collected by and hosted on G2.com.

The fact that it is an Oracle product and its seamless to get integrated with other oracle products is one of the best thing about this. Its very robust as a platform and very stable interms of performance as well. And the fact that it solves the problem makes it a good choice Review collected by and hosted on G2.com.

The development experience on odi is very complex in comparison to modern technologies like Informatica Cloud or powercenter as well. There too much of code complexity as well when developing even a simple project with odi. Also the setup process and installation are quite complex in nature. Review collected by and hosted on G2.com.

ELT process rather ETL which reduces intermediate server needs Review collected by and hosted on G2.com.

A bit non-friendly UI, takes time to learn and adjust with the UI Review collected by and hosted on G2.com.

Code development and administration is easy. It is powerful and can connect to most databases and systems. Easy access and easy load for complex data based in xml for web service-based integrations. Review collected by and hosted on G2.com.

It might be possible to improve user experience. Code services migration and version control can also be improved and streamlined for individual components due to numerous development items. Review collected by and hosted on G2.com.

Oracle is incredibly easy to use and integrates perfectly with so many software programs. It's the perfect go between to connect and simplify programs. Review collected by and hosted on G2.com.

Oracle definitely requires a certain skill level to understand and manipulate. It could be made more intuitive. Review collected by and hosted on G2.com.

Oracle Data Integrator (ODI)is a good ETL tool for integrating data from Oracle and SQL Server. Review collected by and hosted on G2.com.

It's not for novice users. Reporting requests have to go through IT support. Review collected by and hosted on G2.com.

This is an easy system to use and or integrate with other third parties! Easy to navigate after set up as well. Review collected by and hosted on G2.com.

The initial time it took to set up and go live was much too longer. Need more info to start off with and better guidance from the reps. Review collected by and hosted on G2.com.

Easy to use. Works with the cloud services. I like the data integration. I like that it can be monitored from a single solution along with other Oracle technologies and applications. Review collected by and hosted on G2.com.

Nothing really. I am still new to the product. Review collected by and hosted on G2.com.

Odi is user friendly tool with lot of possibilities for developers and data analysts. It is simple for data integration and migration between different sources. Review collected by and hosted on G2.com.

I would like that there is a easy way to migrate odi11g scenarios to new versions of odi12c. Everything else is ok :) Review collected by and hosted on G2.com.

It is ability to create native code for the underlying data management technology. Flexibility of adding new technology stack by writing custom knowledge modules. Review collected by and hosted on G2.com.

In 11g it was difficult to create multi step transformation logic. 12c is addressing this gap. Review collected by and hosted on G2.com.