Oracle Data Integrator (ODI) pros and cons

4.1 out of 5

70 reviews
83% willing to recommend

3,913 followers

Pros & Cons summary

Oracle Data Integrator (ODI) enhances data integration through customizable data types and comprehensive Knowledge Modules for reusable strategies. It ensures connectivity with new technologies and supports big data like Cassandra and Hadoop. Its robust error management aids analytics, while compatibility facilitates development across languages. Challenges include high costs, complex setup, real-time integration improvements, limited publisher integration, and stability issues. Offering scalability, ODI aids seamless data workflows despite concerns over expense and technical hurdles.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Get the report

Prominent pros & cons

PROS

Oracle Data Integrator offers a comprehensive integration with various technologies, making it suitable for different environments and systems such as transactional systems, data warehouses, and B2B integration.

The Knowledge Module approach is highly valued for its ease and reusability, enabling efficient creation of integration strategies and the ability to connect seamlessly with Oracle and non-Oracle technologies.

It provides strong support for ETL processes, enhancing data movement and streamline data integration workflows, particularly for companies invested in Oracle's ecosystem.

ODI is renowned for its scalability, allowing distributed teams to work efficiently and supporting a growing number of users while maintaining performance.

It facilitates integration with emerging technologies and databases like Cassandra and Hadoop, showcasing robust support for big data and making it adaptable to modern data management needs.

CONS

Oracle Data Integrator lacks integration with more publishers and subscribers, rather than just database integrations.

There is a steep learning curve in using Oracle Data Integrator, which can be challenging for newcomers.

Oracle Data Integrator requires easier real-time integration, as current solutions are workarounds.

Oracle Data Integrator pricing is too high, making it unsuitable for small and medium projects.

Oracle support services for Oracle Data Integrator are not satisfactory.

Oracle Data Integrator (ODI) Pros review quotes

AshokSharma

Applications Support Manager at a marketing services firm with 1,001-5,000 employees

Nov 18, 2021

The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful.