Data Integration

Easily extract, transform, and load (ETL) data for data science and analytics. Design code-free data flows into data lakes and data marts. Part of Oracle’s comprehensive portfolio of integration solutions.

OCI Data Integration Service overview (2:35)
Oracle is a Leader in Gartner Magic Quadrant for Data Integration Tools for 15 consecutive years

Oracle has continued to deliver enhancements to its data integration tools, which is just one of the reasons why we have been recognized as a Leader for 15 consecutive years.

Integrating and Preparing Data for Data Science

Watch the Oracle Developer Live Event and see how to utilize Data Integration and Data Flow to optimize how data used.

OCI Data Integration product features

No-code data flow design

Simplify ETL/ELT processes

Intuitive user interface helps you configure integration parameters and automate data mapping between sources and targets.

Powerful transformations

Use one of the out-of-the-box operators, such as a join, aggregate, or expression to shape your data.

Flexible data integration

Maintain your processes centrally and use parameters to override specific configuration values at runtime.


Create complex data orchestrations for loading data lakes and data warehouses

Visually define orchestration flows in an intuitive interface and automatically manage dependencies between parallel runs on data entities. Schedule and orchestrate any task in a data processing pipeline.

Service integration

Build end-to-end, data-driven orchestrations using any task, including all OCI tasks, such as OCI Data Flow, Data Science, and Container Instances. You can also integrate with OCI Events Service for triggering tasks on events and managing by exception.

Advanced monitoring and high resiliency

Supports error handling and resubmission of failed tasks.


Data-immersive experience

Visually preview data

Users can interactively prepare their data and view transformation results to validate their processes.

Modify integrations

Boost productivity and fine-tune data flows on the fly, without waiting for an execution to complete.


Automated schema drift protection

Rule-based integration flow

Avoid broken integration flows and reduce maintenance complexities when data schemas evolve.

Pattern-based data mapping

Leverage best practices to map data instead of matching by data fields.


Hybrid data execution

Spark ETL

Elastically scale by parallel processing large data volumes.

E-LT processing

SQL push-down execution to leverage native database capabilities.

Built-in optimizer

Generate the best executable code to move data using the most efficient systems resources that provide the best performance.

Optimized for Oracle Cloud

Consistent performance

Native integration with Oracle Cloud Infrastructure for best-of-breed computing, networking, scalability, and security.

Scalable

Leverage Oracle Cloud resources to build data lakes at scale and quickly spin-up the required resources for any new project.

SQL pushdown

Pushdown ELT leverages native database capabilities to process transactional data efficiently.

Pay As You Go pricing

Reduce your capital expenditure

Oracle’s Pay As You Go pricing minimizes the major initial investment usually needed for IT infrastructure, because you only pay for what you need.

Save energy and money

Streamlined data integration helps you eliminate redundant servers, reducing your utility costs.

Financial Services
kompany delivers leading regulatory solutions 3X faster with Oracle Cloud Infrastructure (OCI) modern lakehouse analytics
Media
Hearst transforms back office for new era using Oracle Cloud
Transportation
Victoria Department of Transport manages 154 integrations with Oracle Cloud

Use cases for OCI Data Integration

  • Data integration for big data, data lakes, and data science

    Ingest data faster and more reliably into data lakes for data science and analytics. Create high-quality models more quickly.

  • Data integration for data marts and data warehousing

    Load and transform transactional data at scale. Create an organized view from large data volumes.

OCI Data Integration pricing

Product
Unit Price
Metric
Oracle Cloud Infrastructure Data Integration: Workspace

Workspace Usage Per Hour—UCM
Oracle Cloud Infrastructure Data Integration

Gigabyte of Data Processed Per Hour—UCM
Pipeline Operator Execution for the Pipeline (orchestration) execution
Annual Flex/Pay As You Go: Priced at $0.30 per Hour. The first 30 hours of Execution Hour per tenant per month is free.

Related cloud products and solutions

Oracle Cloud Infrastructure Data Science

Deploy machine-learning models

Oracle Cloud Infrastructure Data Catalog

Metadata management service to find and govern data assets

Oracle Cloud Infrastructure Data Flow

A fully managed big data service to run Apache Spark applications
The Oracle Playbook series

We've compiled the secrets to our people, process, and systems strategy. And we want to share them with you.

Get started with Data Integration


Documentation

Explore Oracle Cloud documentation, tutorials, and videos.


Data integration overview

Learn how you can harness the power of your data.


Data Integration blog

Get current tips and product news.


Contact us

Chat live with sales or support.