Oracle Data Integrator Enterprise Edition

Oracle Data Integrator (ODI) 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.

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.

Ebook: Enterprise Data Mesh

Explore the principles, use cases, and examples of Oracle customers deploying a data mesh.

Oracle Data Integrator Enterprise Edition features

High-performance data transformation

Powerful Extract, Transform, Load (ETL)

Push-down transformation to the database to minimize performance impact on source systems.

Lower cost

Use the power of the database system CPU and memory to execute transformations instead of a separate, conventional ETL transformation server.

Native big data support

Generate Apache Spark code following big data standards to transform and execute data mappings.

Out-of-the-box integrations

Comprehensive, prebuilt connectors

Large library of knowledge modules simplifies integrating sources and targets. Oracle Data Integrator’s modular design gives developers more flexibility when connecting multiple systems.

Declarative design

Reuse data-mapping rules to accelerate development of integration logic and increase productivity.

Guided integration

ODI Studio uses best practices to simplify data mapping between systems.

Heterogeneous system support

Big data integration

Prebuilt big data connectors for Hadoop, Spark Streaming, Hive, Kafka, HBase, Sqoop, Pig, Cassandra, NoSQL databases, and more allow users to integrate any data from any source.

Popular databases and other technologies

Extensive database support, including Oracle Autonomous Database, ERP and CRM systems, B2B systems, flat files, XML, JSON, LDAP, JDBC, ODBC, SaaS, and third-party appliances.

Integrates with Oracle GoldenGate

Unify data load and synchronization

Enhance ETL with data replication to keep databases and data warehouses synchronized.

Real-time data warehouse

Faster data load and transformation of real-time data into a data warehouse or big data system.

Integration with Oracle Enterprise Metadata Management

Governance and transparency

Harvest metadata for exploration, search, and data lineage from Oracle and third-party technologies for greater confidence in data.

Model versioning

Compare metadata models for compliance.

Integration with Oracle Enterprise Manager

Centralize data management

Oracle Enterprise Manager addresses monitoring and management from one location, improving productivity.

Oracle Management Pack for ODI

Monitor and manage your ETL and integration activities within the Oracle Enterprise Manager platform.

GoldeGate logo

Raymond James Financials chose Oracle Data Integrator to consolidate data for an enterprise data warehouse

Raymond James integrated easily with Oracle GoldenGate to load data and generate client performance reports in seconds, not minutes. This enabled thousands of financial advisors to help clients make better decisions and improve customer satisfaction.

Oracle Data Integrator solutions

  • Data load into data warehouses

    Import and prepare data for analysis in data warehouses with automatic transformation capabilities.

  • Ingest data into data lakes

    Ingest unstructured and object data into data lakes from many sources

  • Integrate with big data for machine learning (ML) and analytics

    Import and prepare data for use in modeling and big-data analytics with Hadoop, Kafka, JMS, NoSQL databases for ML and AI.

  • Modernize data infrastructure

    Enjoy native support for big data by leveraging the Spark engine for integrations.

Related cloud products

Oracle Data Integrator

Oracle Data Integrator Enterprise Edition delivers high-performance data

Oracle Data Integrator Technology Network

Find answers from the certification matrix, technical, and licensing information

Oracle Departmental Data Warehouse

Discover the complete solution for business users and IT teams
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 Integrator


Find more Oracle Data Integrator technical information

Oracle Data Integrator on Oracle Marketplace

Pre-configured Oracle Data Integrator simplifies data load and transformation in Oracle Cloud.

Download Oracle Data Integrator

Try the latest Oracle Data Integrator release on various platforms.