Oracle

Oracle Data Integrator

Composite Score

7.8 /10

CX Score

8.0 /10

82 Reviews Write a Review

Claim Software

What is Oracle Data Integrator?

Oracle Data Integrator (ODI) is a best-of-breed data integration platform focused on fast bulk data movement and handling complex data transformations. Oracle Data Integrator loads and transforms data faster into data warehouses by leveraging the power of the target database instead of relying on a conventional ETL server. Pre-built connectors simplify integration by automating manual integration tasks needed to connect databases and big data.

Company Details

Need Assistance?

We're here to help you with understanding our reports and the data inside to help you make decisions.

Get Assistance

Oracle Data Integrator Ratings

Real user data aggregated to summarize the product performance and customer experience.
Download the entire Product Scorecard to access more information on Oracle Data Integrator.

Product scores listed below represent current data. This may be different from data contained in reports and awards, which express data as of their publication date.

82 Likeliness to Recommend

3
Since last award

97 Plan to Renew

82 Satisfaction of Cost Relative to Value

1
Since last award

{y}

{name}

Emotional Footprint Overview

Product scores listed below represent current data. This may be different from data contained in reports and awards, which express data as of their publication date.

+85 Net Emotional Footprint

The emotional sentiment held by end users of the software based on their experience with the vendor. Responses are captured on an eight-point scale.

How much do users love Oracle Data Integrator?

6% Negative

8% Neutral

86% Positive

Pros

Trustworthy
Enables Productivity
Performance Enhancing
Respectful

Feature Ratings

Average 79

Metadata Management

Exception Handling and Notifications

API Management and Orchestration

Data Security

Data Quality Profiling and Cleansing

Multi Channel Support

Real Time Integration

iPaaS

Synchronization and Replication

Administrative Features

Batch Integration

Vendor Capability Ratings

Average 78

Product Strategy and Rate of Improvement

Ease of Data Integration

Quality of Features

Ease of IT Administration

Ease of Implementation

Breadth of Features

Availability and Quality of Training

Business Value Created

Vendor Support

Usability and Intuitiveness

Ease of Customization

Oracle Data Integrator Reviews

Vishaldeep P.

Role: Information Technology
Industry: Communications
Involvement: End User of Application

Validated Review

Verified Reviewer

Submitted Jan 2025

Scalable ELT tool with advanced features.

Likeliness to Recommend

8 /10

What differentiates Oracle Data Integrator from other similar products?

It's ELT (Extract, Load, Transform) architecture, enabling high performance and scalability by leveraging the database's processing power.

What is your favorite aspect of this product?

My favorite aspect of Oracle Data Integrator is its declarative design approach, which simplifies complex data integration processes through reusable mappings and automation.

What do you dislike most about this product?

What I dislike most about Oracle Data Integrator is its steep learning curve, which can make it challenging for new users to get started quickly.

What recommendations would you give to someone considering this product?

I recommend investing time in proper training and leveraging Oracle's extensive documentation to fully harness Oracle Data Integrator's powerful features.

Pros

Helps Innovate
Saves Time
Respectful
Fair

Ashka P.

Role: Sales Marketing
Industry: Other
Involvement: Business Leader or Manager

Validated Review

Verified Reviewer

Submitted Jan 2025

We use it weekly and it’s effective…love this prod

Likeliness to Recommend

10 /10

What differentiates Oracle Data Integrator from other similar products?

It’s is reliable and effective

What is your favorite aspect of this product?

Everything

What do you dislike most about this product?

Nothing really

What recommendations would you give to someone considering this product?

This product is amazing, efficient and easy to use

Pros

Reliable
Performance Enhancing
Enables Productivity
Trustworthy

Deep M.

Role: Information Technology
Industry: Technology
Involvement: Business Leader or Manager

Validated Review

Verified Reviewer

Submitted Jan 2025

ODI: The oracle integration powerhouse

Likeliness to Recommend

9 /10

What differentiates Oracle Data Integrator from other similar products?

Oracle Data Integrator (ODI) stands out primarily due to its Extract Load Transform (E-LT) architecture. Unlike traditional ETL tools that extract and transform data in a separate engine before loading, ODI pushes transformations down to the target system leveraging the power of the database for faster processing, especially with large datasets. Plus, ODI's "Knowledge Modules" provide a declarative approach to development, allowing for reusable code and easier maintenance. The combination of E-LT and declarative design is highly efficient and adaptable for complex data warehousing and integration scenarios.

What is your favorite aspect of this product?

I particularly appreciate its declarative design approach and this "declare, don't code" philosophy simplifies the development and maintenance of complex data integration processes. The knowledge modules (KMs) encapsulate technical details, allowing developers to focus on the business logic and data transformations and it not only reduces development time but also makes it easier to adapt to changes in underlying technologies or data sources.. The focus on performance and simplified development through declarative design makes ODI a powerful and efficient tool for complex data integration projects.

What do you dislike most about this product?

The most frustrating part of Oracle Data Integrator is its cumbersome and unintuitive user interface. Editors and configuration options are quite complex, especially for intricate integration scenarios. A smooth and user-friendly interface with improved drag-and-drop capabilities and clearer visual representations of data flows would definitely enhance the overall user experience. The interface requires excessive clicking and navigating through nested menus, which hinders productivity. Therefore, they should work on this aspect to make it a more enjoyable tool to work with on a daily basis.

What recommendations would you give to someone considering this product?

ODI's "Extract Load Transform" (ELT) architecture is very powerful for large data volumes as it leverages the database engine for transformations, minimizing data movement and maximizing efficiency. Its tight integration with Oracle databases and applications provides solid performance advantages and simplifies development. ODI's knowledge module (KM) approach adds flexibility and customization for various data sources and targets. Its metadata management capabilities are very strong and helps tracking and management of data lineage. If any organization prioritizes robust data integration, then ODI is a strong contender. Highly recommend!

Pros

Helps Innovate
Continually Improving Product
Reliable
Performance Enhancing

Oracle Data Integrator

What is Oracle Data Integrator?

Company Details

Need Assistance?

Oracle Data Integrator Ratings

82 Likeliness to Recommend

3 Since last award

97 Plan to Renew

82 Satisfaction of Cost Relative to Value

1 Since last award

Emotional Footprint Overview

+85 Net Emotional Footprint

How much do users love Oracle Data Integrator?

Pros

Feature Ratings Average rating of all product features, some of which may not be shown below

Metadata Management A metadata layer makes reporting easy and eliminates the need for coding and SQL, allowing users to see and access information in simple business language.

Exception Handling and Notifications Ability to catch, report, and handle exceptions; includes transaction logging and event viewing.

API Management and Orchestration Includes publishing, promoting and overseeing APIs and Orchestration Services.

Data Security Includes ability to hide sensitive data by masking with special characters or anonymous information.

Data Quality Profiling and Cleansing Includes data cleansing, reconciliation, and profiling across multiple sources in batch mode.

Multi Channel Support The ability to support and connect with channels including Cloud Services, Big Data Platforms, web, mobile, social, IoT, wearables, etc.

Real Time Integration Able to integrate data in near-real time and handle movement of data from a source to target. Monitoring for changes in a data source in a non-invasive manner.

iPaaS Includes iPaaS (Cloud hosting) features and other advanced integration capabilities

Synchronization and Replication Includes the ability to accurately catch, reflect, and correct changes in data across multiple data stores.

Administrative Features Includes basic aspects of data extraction, transformation, and loading. Administrative console and process viewing, interruption, restart, cancel, and rollback.

Batch Integration Includes ability to schedule integration processes to run on a periodic basis to control the movement of data from a source to target.

Vendor Capability Ratings Average rating of all vendor capabilities, some of which may not be shown below

Product Strategy and Rate of Improvement Vendors who don't stay on top of emerging needs and trends won't enable you to meet your business goals. Use this data to separate innovators from imposters.

Ease of Data Integration Use this data to determine whether the product will cause headaches or make data integration easy.

Quality of Features Feature quality is just as important as quantity. Use this data to determine if this product will do what you're purchasing it to do, easily, intuitively, reliably, and effectively.

Ease of IT Administration This data indicates whether IT personnel will be able to resolve issues and perform configurations efficiently and effectively.

Ease of Implementation Successfully implementing new software is necessary to realize its full value and promote end user adoption. This data indicates whether or not the product is easy to implement.

Breadth of Features Users prefer feature rich software that enables them to perform diverse series of tasks. This data expresses user satisfaction with the product's breadth of features.

Availability and Quality of Training Effective and readily available training enables users to get the most out of the software you've chosen. Use this section to make sure your vendor's training programs and materials measure up.

Business Value Created Software needs to create value for employees, customers, partners, and, ultimately, shareholders. This data expresses user satisfaction - or lack thereof - with the product's business value.

Vendor Support The importance of vendor support will vary for each organization depending on internal capabilities, but there will always be issues that only the vendor can resolve.

Usability and Intuitiveness End user learning curves cost the organization money. Pay attention to your end users' technical ability to determine how important UX is in your purchase.

Ease of Customization Don't get bogged down in a difficult customization; use this data to make sure you can easily achieve the functionality you need for your particular situation.

Oracle Data Integrator Reviews

Vishaldeep P.

Scalable ELT tool with advanced features.

Likeliness to Recommend

Pros

Ashka P.

We use it weekly and it’s effective…love this prod

Likeliness to Recommend

Pros

Deep M.

ODI: The oracle integration powerhouse

Likeliness to Recommend

Pros

Most Popular Oracle Data Integrator Comparisons

Microsoft SQL Server

Zapier

Microsoft Azure Data Factory

Altova MapForce

SAP Data Services

Cleo Integration Cloud

3
Since last award

1
Since last award

Feature Ratings

Metadata Management

Exception Handling and Notifications

API Management and Orchestration

Data Security

Data Quality Profiling and Cleansing

Multi Channel Support

Real Time Integration

iPaaS

Synchronization and Replication

Administrative Features

Batch Integration

Vendor Capability Ratings

Product Strategy and Rate of Improvement

Ease of Data Integration

Quality of Features

Ease of IT Administration

Ease of Implementation

Breadth of Features

Availability and Quality of Training

Business Value Created

Vendor Support

Usability and Intuitiveness

Ease of Customization