Oracle

Oracle Data Integrator

7.3 /10

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.

80 Likeliness to Recommend

1
Since last award

97 Plan to Renew

81 Satisfaction of Cost Relative to Value

{y}

{name}

Emotional Footprint Overview

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

8% Negative

9% Neutral

83% Positive

Pros

Trustworthy
Enables Productivity
Performance Enhancing
Respectful

Feature Ratings

Average 78

Metadata Management

Multi Channel Support

API Management and Orchestration

Exception Handling and Notifications

Data Security

Data Quality Profiling and Cleansing

Real Time Integration

iPaaS

Synchronization and Replication

Batch Integration

Data Virtualization

Vendor Capability Ratings

Average 77

Product Strategy and Rate of Improvement

Ease of Data Integration

Ease of IT Administration

Quality of Features

Ease of Implementation

Availability and Quality of Training

Vendor Support

Business Value Created

Usability and Intuitiveness

Breadth of Features

Ease of Customization

Oracle Data Integrator Reviews

Sriharsha K.

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

Validated Review

Verified Reviewer

Submitted Oct 2024

Oracle Data Integrator Powerful ELT Tool for flex

Likeliness to Recommend

9 /10

What differentiates Oracle Data Integrator from other similar products?

Oracle data integrator provides knowledge Modules (KMs) are modular, reusable templates that handle various integration tasks like data loading, transformation, and integration with various systems and is highly technology-agnostic. It can connect to a wide variety of relational databases, NoSQL systems, cloud environments, big data technologies.

What is your favorite aspect of this product?

My favorite aspect of Oracle Data Integrator (ODI) is its ELT architecture. This design leverages the processing power of the target database to perform data transformations, which eliminates the need for intermediary transformation servers and it works efficiently in environments with a mix of different databases and technologies.

What do you dislike most about this product?

One potential downside of Oracle Data Integrator (ODI) is its steep learning curve, especially for users new to the tool or data integration.

What recommendations would you give to someone considering this product?

orcale data integrator evaluates approach is optimal if you work with large datasets or need to leverage the power of your target databases for transformations and give your team time to experiment in a non-critical environment and knowledge Modules are powerful but require in-depth knowledge of both the source and target systems

Pros

Helps Innovate
Enables Productivity
Trustworthy
Unique Features

Omer E.

Role: Student Academic
Industry: Technology
Involvement: IT Development, Integration, and Administration

Validated Review

Verified Reviewer

Submitted Aug 2024

Clear cut, nice and smooth

Likeliness to Recommend

9 /10

What differentiates Oracle Data Integrator from other similar products?

Oracle Data Integrator (ODI) differentiates itself from other data integration products with several unique features: ELT (Extract, Load, Transform) Architecture: ODI’s use of ELT, rather than the traditional ETL (Extract, Transform, Load) approach, leverages the power of target databases for data transformation, which can improve performance and scalability. Comprehensive Integration with Oracle Ecosystem: ODI offers deep integration with Oracle’s suite of products, including Oracle databases, Oracle Cloud, and Oracle’s business applications, providing seamless data connectivity and management within the Oracle ecosystem.

What is your favorite aspect of this product?

My favorite aspect of Oracle Data Integrator (ODI) is its ELT (Extract, Load, Transform) architecture. This approach leverages the target database's processing power for data transformation, which can lead to improved performance and efficiency, especially when dealing with large volumes of data. By offloading transformation tasks to the database, ODI minimizes data movement and optimizes resource utilization, resulting in faster and more scalable data integration processes.

What do you dislike most about this product?

The main drawback of Oracle Data Integrator (ODI) is its complexity and steep learning curve. The tool's extensive feature set and advanced configurations can be challenging for new users to master. The user interface, while powerful, can be complex and require significant training and experience to navigate effectively. This complexity may lead to longer implementation times and potentially higher costs for training and support, which could be a barrier for smaller teams or organizations new to data integration.

What recommendations would you give to someone considering this product?

you’re considering Oracle Data Integrator (ODI), here are some recommendations to ensure you make the most of the product: Invest in Training and Resources: Due to ODI’s complexity, investing in comprehensive training for your team is crucial. Utilize Oracle’s training resources, documentation, and support to build proficiency and effectively leverage the tool’s features. Assess Integration Needs: Evaluate how well ODI aligns with your existing data infrastructure and Oracle environment. ODI’s strengths are particularly pronounced in Oracle-centric setups, so ensure it fits your specific integration requirements.

Pros

Effective Service
Client's Interest First
Helps Innovate
Continually Improving Product

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

Oracle Data Integrator

What is Oracle Data Integrator?

Company Details

Need Assistance?

Oracle Data Integrator Ratings

80 Likeliness to Recommend

1 Since last award

97 Plan to Renew

81 Satisfaction of Cost Relative to Value

Emotional Footprint Overview

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

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

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

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

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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

Sriharsha K.

Oracle Data Integrator Powerful ELT Tool for flex

Likeliness to Recommend

Pros

Omer E.

Clear cut, nice and smooth

Likeliness to Recommend

Pros

Faizan T.

Well built. Great customer support.

Likeliness to Recommend

Pros

Cons

Most Popular Oracle Data Integrator Comparisons

Microsoft SQL Server

Zapier

Microsoft Azure Data Factory

Altova MapForce

SAP Data Services

Cleo Integration Cloud

1
Since last award

Feature Ratings

Metadata Management

Multi Channel Support

API Management and Orchestration

Exception Handling and Notifications

Data Security

Data Quality Profiling and Cleansing

Real Time Integration

iPaaS

Synchronization and Replication

Batch Integration

Data Virtualization

Vendor Capability Ratings

Product Strategy and Rate of Improvement

Ease of Data Integration

Ease of IT Administration

Quality of Features

Ease of Implementation

Availability and Quality of Training

Vendor Support

Business Value Created

Usability and Intuitiveness

Breadth of Features

Ease of Customization