| CARVIEW |
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.
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 16 consecutive years.
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.
OCI Data Integration customer successes
kompany delivers leading regulatory solutions 3X faster with Oracle Cloud Infrastructure (OCI) modern lakehouse analytics
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 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.