Selecting the best Data Integration tool – A guide to Oracle Data Integrator editions

May 3, 2023 | 6 minute read
Jayant Mahto
Senior Principal Product Manager
Text Size 100%:

Oracle Data Integrator (ODI) has been a leading data integration tool for many years, featuring flexible connectivity, high performance and intelligent ‘pushdown’ processing for multiple environments.

To adapt to recent developments in cloud computing and enterprise data lakes, the product has now evolved into the following three editions:

  • Oracle Data Integrator, deployable either on-premises or on cloud infrastructure
  • Oracle Data Integrator Web Edition, available on Oracle Cloud Infrastructure
  • Data Transforms, built into the Oracle Autonomous Database

This post explains the three editions and outlines how to select the appropriate one for your requirements.

 

Brief Guide

All editions of Oracle Data Integrator use the same architecture and engine, so all benefit from the performance-optimized Extract – Load – Transform and pushdown processing approach to data integration.

The following table summarizes the main purpose and target user roles of each edition:

Edition

Main Purpose

Target User Roles

Oracle Data Integrator

On-premises or hybrid data integration

Developer

Oracle Data Integrator Web Edition

Customer-managed data integration for Oracle cloud database targets

Line of Business User or Developer

Data Transforms

Data integration in an Oracle Autonomous Database

Line of Business User or Developer

 

Licensing and Management

 

Oracle Data Integrator

Oracle Data Integrator normally requires licenses. Licensing is based on the available processing cores in the target database where the transformations will run. The only exception to this is that if you choose to deploy Oracle Data Integrator from the Oracle Cloud Infrastructure Marketplace, and you are loading only cloud Oracle database targets (such as Oracle Autonomous Database or Database Cloud Service). In this case, you should use the ‘Data Integrator Classic (free)’ listing, which does not require a license. You will only need to pay for the cost of the OCI resources used for running the software.

If you are loading other cloud databases, or perhaps a mixture of on-premises and cloud systems, you can still deploy Oracle Data Integrator on Oracle Cloud Infrastructure, on a Bring Your Own License (BYOL) basis. In this case, the ‘Data Integrator Classic (BYOL)’ listing should be used.

In all cases, instances of Oracle Data Integrator are customer-managed, so responsibility for maintenance of the software resides with customers, and upgrades and patches are not automated.

 

Oracle Data Integrator Web Edition

Oracle Data Integrator Web Edition is deployed on Oracle Cloud Infrastructure using the ‘Data Integrator: Web Edition’ listing. It does not require licenses, but targets are limited to Oracle cloud databases, such as Oracle Autonomous Database or Oracle Database Cloud Service.

Like Oracle Data Integrator, all instances of Oracle Data Integrator Web Edition are customer-managed.

 

Data Transforms

Data Transforms is deployed as a functional capability of the Oracle Autonomous Database. No additional licensing is required.

Note that Data Transforms is designed and intended for loading the Oracle Autonomous Database. There is no licensing restriction for loading other targets, but connectivity may not be possible.

Data Transforms is managed by Oracle so is patched and upgraded automatically, as with all other Oracle Autonomous Database features.

 

Full Edition Details

The following table provides a more detailed guide to the capabilities of each Oracle Data Integrator edition:

Feature

Oracle Data Integrator

Oracle Data Integrator Web Edition

Data Transforms

User Interface

Studio (thick client)

Browser-based

Browser-based

Target Databases

Any

Oracle cloud databases only

Any supported target (See guide)

Source Connectivity

See guide

See guide

See guide

Custom JDBC Driver support

Yes

Yes

No

Knowledge Module customization support

Yes

No

No

Clustering support for High Availability

Yes

No

No

GIT integration for source code control

Yes

No

No

Network and environment customization

Yes

No

No

Licensing

Required unless loading Oracle cloud databases only

Not required

Not required

Management

Customer-managed

Customer-managed

Oracle managed

 

 

Selecting the right Oracle Data Integrator edition

Use the simple flowchart below to select the right Oracle Data Integrator edition for your requirements:

 

 

Conclusion

Oracle provides highly effective and cost-efficient data loading and transformation capabilities, all utilizing the well-proven Oracle Data Integrator technology. Use this guide to identify the best edition for you, and begin your data integration journey today!

Jayant Mahto

Senior Principal Product Manager

Jayant Mahto is a Senior Principal Product Manager for Database Server Technologies at Oracle. He has been developing tools and applications for Data Warehousing and Business Intelligence for more than two decades. Currently he is involved in Database tools development of Autonomous Database as primary focus.


Previous Post

Introducing Data Studio

Mike Matthews | 3 min read

Next Post


Introducing Data Transforms: Built in Data Integration for Autonomous Database

Jayant Mahto | 7 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider