Oracle Data Integrator (ODI) Review

Enhances the strategic usage of data which compromises more reliability for large data warehouses

Valuable Features:

 Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting.  Built-in dimensional modeling tools are included in Oracle Data Integrator to simplify Oracle Data Warehouse Integration.  Oracle Data Integrator ensures automatic detection and recycling of faulty data before insertion in the target application and is performed through data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.  In order to ensure real-time data integration, Oracle Data Integration suite provides all key components required to enable real-time data warehousing and operational data hubs.

Room for Improvement:

 As with any big tool, truly mastering ODI may take months.

Other Advice:

 Oracle Data Integrator separates the declarative rules from the implementation details. It can run entirely within a Service Oriented Architecture. ODI is the most integrated ETL product for running data integration as a service, accessing web services and writing to web services as a target.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Oracle Data Integrator (ODI) reviews from users
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
523,372 professionals have used our research since 2012.
Add a Comment
ITCS user