Oracle

Oracle Data Integrator

Composite Score

7.8 /10

CX Score

8.1 /10

87 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

98 Plan to Renew

1
Since last award

84 Satisfaction of Cost Relative to Value

2
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.

+86 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?

5% Negative

6% Neutral

89% Positive

Pros

Performance Enhancing
Enables Productivity
Respectful
Acts with Integrity

Feature Ratings

Average 79

Metadata Management

Exception Handling and Notifications

Data Quality Profiling and Cleansing

API Management and Orchestration

Multi Channel Support

Real Time Integration

Data Security

iPaaS

Synchronization and Replication

Batch Integration

Data Virtualization

Vendor Capability Ratings

Average 78

Product Strategy and Rate of Improvement

Ease of Data Integration

Quality of Features

Ease of Implementation

Ease of IT Administration

Vendor Support

Breadth of Features

Business Value Created

Availability and Quality of Training

Usability and Intuitiveness

Ease of Customization

Oracle Data Integrator Reviews

Faizan T.

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

Validated Review

Verified Reviewer

Submitted Mar 2024

Well built. Great customer support.

Likeliness to Recommend

7 /10

What differentiates Oracle Data Integrator from other similar products?

Very responsive team, Great community out there.

What is your favorite aspect of this product?

easy of integration

What do you dislike most about this product?

Pricing could be better

What recommendations would you give to someone considering this product?

Go for it.

Pros

Trustworthy
Generous Negotitation
Includes Product Enhancements
Friendly Negotiation

Cons

Commodity Features
Less Efficient Service
Less Inspiring

Evans F.

Role: Information Technology
Industry: Shipping
Involvement: IT Development, Integration, and Administration

Validated Review

Verified Reviewer

Submitted Feb 2025

Powerful integration tool

Likeliness to Recommend

10 /10

What differentiates Oracle Data Integrator from other similar products?

1. High-Performance ELT Architecture: Oracle Data Integrator focuses on ELT (Extract, Load, Transform), allowing faster data processing by leveraging the target database’s power for transformations. 2. Broad Connectivity: It supports a wide range of data sources, including both on-premises and cloud environments, offering flexibility in diverse IT infrastructures. 3. Tight Integration with Oracle Ecosystem: Seamlessly integrates with other Oracle products like Oracle Database, Oracle Cloud, and Oracle Autonomous Data Warehouse, optimizing performance and ease of use within the Oracle ecosystem.

What is your favorite aspect of this product?

My favorite aspect of Oracle Data Integrator is its high-performance ELT architecture, which speeds up data processing by shifting transformations to the target database, making it more efficient for large-scale data integration.

What do you dislike most about this product?

What I dislike most about Oracle Data Integrator is its steep learning curve, which can be challenging for new users or those without a deep background in data integration and Oracle's ecosystem.

What recommendations would you give to someone considering this product?

1. Familiarize yourself with Oracle's ecosystem for seamless integration and better performance. 2. Invest time in training to overcome the steep learning curve and fully leverage its capabilities. 3. Ensure you have the infrastructure to support high-performance ELT processing for optimal results.

Pros

Helps Innovate
Continually Improving Product
Trustworthy
Efficient Service

Fatima R.

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

Validated Review

Verified Reviewer

Submitted Mar 2024

Simple to use yet a little expensive.

Likeliness to Recommend

8 /10

What differentiates Oracle Data Integrator from other similar products?

E-LT Architecture: In contrast to the more popular Extract-Transform-Load (ETL) methodology, Oracle Data Integrator uses an Extract-Load-Transform (E-LT) architecture. In order to apply transformations using the capabilities of the target database engine, data must first be extracted from the source systems and imported into the target database via E-LT. Better performance and scalability are possible with this architecture, especially for large-scale data integration projects. Comprehensive Integration with Oracle Products: Oracle databases, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Fusion Middleware, and Oracle Cloud.

What is your favorite aspect of this product?

Versatile Development Environment: The Oracle Data Integrator offers a versatile development environment that supports both code-based and graphical development techniques. Because of this flexibility, customers can select the best approach for planning and executing data integration operations based on their needs and preferences.Incremental Data Loading and Change Data Capture (CDC): Users greatly appreciate Oracle Data Integrator's support for incremental data loading and CDC capabilities. Especially for big datasets with frequent updates, these features allow effective processing of only the modifications made to the source data, saving.

What do you dislike most about this product?

Cost of Ownership: Some organizations, especially smaller ones or those with tighter budgets, may find it costly to license Oracle Data Integrator and related Oracle technologies. The total cost of ownership (TCO), which includes initial licensing fees, recurring maintenance costs, and hardware infrastructure needs, may be greater for users of ODI than for competing data integration options. Restricted Cross-platform Support: Although Oracle Data Integrator is compatible with many other data sources and targets, you may feel that it does not support as many non-Oracle platforms and technologies as other data integration products do.

What recommendations would you give to someone considering this product?

Invest in Training and Education: Invest in training and education for administrators and developers to build expertise in Oracle Data Integrator. Oracle offers official training courses, certification programs, and documentation to help users learn ODI's features, best practices, and optimization techniques. Start with Pilot Projects: Start with pilot projects or smaller-scale implementations to gain hands-on experience with Oracle Data Integrator before tackling larger and more complex deployments.

Pros

Reliable
Inspires Innovation
Caring
Saves Time

Cons

Less Effective Service

Oracle Data Integrator

What is Oracle Data Integrator?

Company Details

Need Assistance?

Awards & Recognition

Oracle Data Integrator Ratings

82 Likeliness to Recommend

98 Plan to Renew

1 Since last award

84 Satisfaction of Cost Relative to Value

2 Since last award

Emotional Footprint Overview

+86 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.

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

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

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.

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

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.

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.

Data Virtualization Includes ability to create views joining disparate data sources without the need for persistence.

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 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.

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

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.

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.

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.

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.

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

Faizan T.

Well built. Great customer support.

Likeliness to Recommend

Pros

Cons

Evans F.

Powerful integration tool

Likeliness to Recommend

Pros

Fatima R.

Simple to use yet a little expensive.

Likeliness to Recommend

Pros

Cons

Most Popular Oracle Data Integrator Comparisons

Microsoft SQL Server

Zapier

Microsoft Azure Data Factory

SAP Data Services

Altova MapForce

Cleo Integration Cloud

1
Since last award

2
Since last award

Feature Ratings

Metadata Management

Exception Handling and Notifications

Data Quality Profiling and Cleansing

API Management and Orchestration

Multi Channel Support

Real Time Integration

Data Security

iPaaS

Synchronization and Replication

Batch Integration

Data Virtualization

Vendor Capability Ratings

Product Strategy and Rate of Improvement

Ease of Data Integration

Quality of Features

Ease of Implementation

Ease of IT Administration

Vendor Support

Breadth of Features

Business Value Created

Availability and Quality of Training

Usability and Intuitiveness

Ease of Customization