Oracle Data Integrator
by Oracle · ETL & Data Extraction
Oracle's E-LT data integration platform that moves and transforms ERP and database data at scale.
Updated August 2026 · By the ERP Research Editorial Team · Independent and vendor-neutral.
- Works with
SAP
Oracle E-Business SuiteJD Edwards EnterpriseOneJD Edwards WorldOracle PeopleSoftOracle Siebel CRMOracle- Deployment
- On-premise, Cloud
- Pricing
- Quote-based (perpetual on-premises license or OCI cloud subscription)
- Founded
- 1977
Overview
Oracle Data Integrator (ODI) is Oracle's data integration platform for building, deploying and managing complex data warehouses and data-centric architectures. Rather than routing data through a separate ETL transformation server, ODI uses an Extract-Load-Transform (E-LT) approach: it extracts data from source systems, loads it into the target platform, and then executes the transformation logic as native code (SQL or big-data code) inside the target database or platform. Oracle positions this as reducing network traffic and middleware overhead compared with conventional mid-tier ETL engines, while still supporting traditional ETL-style flows where needed.
ODI's architecture is built around Knowledge Modules (KMs) — reusable, technology-specific templates that encapsulate how to reverse-engineer metadata, extract, check, and load data for a given source or target. Oracle ships Knowledge Modules and dedicated Application Adapters for Oracle E-Business Suite, Oracle PeopleSoft, JD Edwards EnterpriseOne, JD Edwards World and Oracle Siebel CRM, plus SAP ABAP ERP and SAP ABAP BW adapters that connect via SAP's Java Connector (JCo). Oracle's data sheet also states out-of-box integration with 100+ other databases, applications, flat files, XML, JSON, LDAP and JDBC sources, and the platform integrates with Oracle GoldenGate for real-time/CDC-driven data warehousing and with Oracle Enterprise Data Quality for profiling, cleansing and matching.
ODI Enterprise Edition deploys on Oracle Fusion Middleware / WebLogic Server, on-premises or on Oracle Cloud Infrastructure (it is listed on the OCI Marketplace), and supports clustered, high-availability runtime agents. Oracle describes Data Transforms — a native OCI service available through Autonomous Database Serverless and OCI GoldenGate — as the newest evolution of ODI's data integration technology, and offers current ODI customers a migration path to it.
Features & capabilities
E-LT Architecture & Data Movement
Extract-Load-Transform processing that runs transformations natively inside the target platform.
- E-LT architecture: extract, load, then transform using native code on the target RDBMS
- Support for both traditional ETL-style and E-LT-style data flows
- Out-of-box integration with 100+ databases and applications, flat files, XML, JSON, LDAP and JDBC sources
- Rich ETL for Oracle databases including Oracle Exadata, with complex dimension and cube loading
- Big data support with added parallelism for data integration processes (12c+)
- Interoperability with Oracle Warehouse Builder (OWB) for migration to ODI
Knowledge Modules & Declarative Design
A modular, extensible framework of reusable integration templates.
- Knowledge Modules (RKM/LKM/IKM/CKM) that generate technology-tuned code for reverse-engineering, extraction, integration and data-quality checks
- Declarative, flow-based mapping designer for describing source/target formats and transformations
- Automatic reverse-engineering of source and target metadata into ODI models
- Data flow visualization and automatic documentation generation, including data lineage
- Reusable mapping logic across projects for faster development
- Python-based custom Knowledge Module scripting (Jython deprecated as of 14.1.2)
Enterprise Application Adapters
Prebuilt adapters that read and write through applications' own interface tables rather than raw physical tables.
- Oracle E-Business Suite adapter: RKM reverse-engineers EBS objects; IKM E-Business Suite (Open Interface) loads data through EBS Open Interface tables
- JD Edwards EnterpriseOne adapter: RKMs for Oracle, SQL Server, DB2 UDB and DB2 AS/400-hosted JDE; IKM writes via Z-tables and the RunUBE batch command
- JD Edwards World adapter: RKM plus IKM JDE World Control Append, writing via Z-tables and an RPG program on the iSeries server
- Oracle PeopleSoft adapter: RKMs (Oracle and Microsoft SQL Server) for read-only, data-level extraction from PeopleSoft Business Objects tables
- Oracle Siebel CRM adapter: RKM for Business Components (read-only) and RKM/LKM/IKM for EIM (Enterprise Integration Manager) tables supporting bidirectional data exchange
- SAP ABAP ERP and SAP ABAP BW adapters: RKMs and LKMs connect via SAP JCo/RFC to reverse-engineer and extract SAP tables, InfoCubes, InfoObjects, ODS/DSO objects and OpenHubDestinations
Deployment, Administration & Monitoring
Studio, console and runtime-agent tooling for developing, operating and scaling integration jobs.
- ODI Studio with Topology, Designer, Operator and Security navigators for infrastructure, development, execution and access-control
- Web-based ODI Console (Oracle ADF/Ajax) for production users to run topology configuration, monitor sessions, diagnose errors and generate lineage reports
- Standalone, Standalone Colocated and Java EE runtime agents supporting load balancing across the information system
- High availability via WebLogic Server clustering, JDBC connection pooling, and connection-retry recovery against Oracle RAC-backed repositories
- Integration with Oracle Enterprise Manager Fusion Middleware Control for unified monitoring alongside other Fusion Middleware components
- Deployment on Oracle Cloud Infrastructure via the OCI Marketplace, with a migration path to the cloud-native Data Transforms service
Data Quality & Governance
Controls for isolating, recycling and governing data as it moves through integration flows.
- Data integrity control features that flag and isolate invalid data before it reaches the target
- Integration with Oracle Enterprise Data Quality for advanced profiling, cleansing, matching and data governance
- Error-table isolation and recycling of faulty records during Check Knowledge Module (CKM) execution
- Edition-Based Redefinition (EBR) support (14.1.2+) for zero-downtime upgrades of Oracle Database objects
Common use cases
- Extracting SAP ABAP ERP or SAP ABAP BW data (tables, InfoCubes, InfoObjects, ODS/DSO objects) into an Oracle data warehouse for enterprise reporting
- Migrating historical data from Oracle E-Business Suite, PeopleSoft, JD Edwards, or Siebel CRM into a new ERP or analytics platform ahead of a system cutover
- Loading transformed data back into Oracle E-Business Suite, JD Edwards, or Siebel CRM through their native Open Interface, Z-table, or EIM staging tables
- Running high-volume, high-performance data warehouse and BI loads with incremental loads and slowly changing dimensions
- Pairing with Oracle GoldenGate for real-time, change-data-capture-driven data warehousing
- Synchronizing data across hybrid Master Data Management (MDM) systems with SOA process integration and BPEL compositions
- Feeding Oracle Autonomous Database or OCI GoldenGate as a migration path toward the cloud-native Data Transforms service
Strengths & considerations
Strengths
- Heterogeneous E-LT architecture pushes transformation logic into the target database instead of a separate mid-tier ETL engine, which Oracle states reduces network traffic and infrastructure cost
- Dedicated application adapters (not just generic database connectors) for Oracle E-Business Suite, PeopleSoft, JD Edwards, and Siebel CRM that read and write through each application's own interface/staging tables
- SAP ABAP ERP and SAP ABAP BW adapters connect directly via SAP JCo/RFC, extracting tables, InfoCubes, InfoObjects and ODS/DSO objects without a third-party middleware layer
- Knowledge Module framework lets customers capture and reuse integration best practices and extend generated code, rather than being locked into fixed, opaque connectors
- Deep integration with the wider Oracle Data Integration portfolio (GoldenGate for CDC, Enterprise Data Quality, Enterprise Manager) plus an official migration path to the cloud-native Data Transforms service
Considerations
- The documented SAP ABAP ERP and SAP ABAP BW Knowledge Modules are extraction-only (RKM/LKM); Oracle does not publish an Integration Knowledge Module for writing data back into SAP
- SAP adapters only support ordered joins; full outer joins and right outer joins are not supported, and SAP BW MultiCubes cannot be extracted directly
- Dialog-mode (RFC) execution for SAP extraction jobs is deprecated in favor of background job processing as of the current SAP adapter guide
ERP integrations
Extracts SAP tables, InfoCubes, InfoObjects, ODS/DSO objects and OpenHubDestinations via background ABAP report execution or a shared-folder/FTP file transfer
Reads via standard Oracle Database LKMs; writes to EBS through Open Interface tables and Concurrent Processing programs, not physical tables directly
Reads JDE data tables directly; writes via Z-tables and the RunUBE batch command
Reads JDE World tables on IBM DB2 for iSeries; writes via Z-tables and an RPG program run on the iSeries server
Data-level access to PeopleSoft Business Objects tables on an Oracle or Microsoft SQL Server backend
Only EIM tables should be used to write into Siebel; writing directly to Siebel physical tables is not supported
GoldenGate integration adds real-time/CDC-driven data warehousing; Enterprise Data Quality adds profiling, cleansing and matching
Pricing
Available as an on-premises Oracle Data Integrator Enterprise Edition license, and as Oracle Data Integrator Cloud Service on Oracle Cloud Infrastructure, billed per OCPU-hour or under Bring Your Own License (BYOL) terms, per Oracle's published OCI price list. Oracle does not publish on-premises list pricing; exact cost requires a quote from Oracle. Get an independent shortlist with pricing guidance below.
Technical & security
- Hosting
- Self-managed on Oracle WebLogic Server, deployable on-premises or on Oracle Cloud Infrastructure (available via OCI Marketplace)
About the vendor
- Founded
- 1977
- Employees
- ~141,000
- Ownership
- Public (NASDAQ: ORCL)
Alternatives to Oracle Data Integrator in ETL & Data Extraction
Oracle Data Integrator — frequently asked questions
What ERPs and applications does Oracle Data Integrator connect to?
ODI ships dedicated Application Adapters for Oracle E-Business Suite, Oracle PeopleSoft, JD Edwards EnterpriseOne, JD Edwards World, and Oracle Siebel CRM, plus SAP ABAP ERP and SAP ABAP BW adapters that connect over SAP's Java Connector (JCo). Oracle's data sheet also states out-of-box integration with 100+ other databases and applications.
How does ODI's E-LT architecture differ from traditional ETL?
Instead of routing data through a separate mid-tier transformation server, ODI extracts and loads data into the target first, then executes the transformation as native code inside that target database or platform. Oracle states this reduces network traffic and middleware overhead versus a conventional ETL engine, while ODI still supports ETL-style flows where needed.
Can Oracle Data Integrator write data back into SAP?
No. The SAP ABAP BW and SAP ABAP ERP Knowledge Modules Oracle documents are extraction-only (Reverse and Loading Knowledge Modules); there is no published Integration Knowledge Module for loading data back into SAP, so SAP is used strictly as a data source.
Is Oracle Data Integrator still being developed, or has it been replaced?
ODI remains a supported, actively updated product; 14c (14.1.2) is the current release, with 100+ new connectors and Python-based Knowledge Modules replacing deprecated Jython scripting. Oracle also offers Data Transforms, a cloud-native OCI service, as the newest evolution of ODI's technology, with a migration path for existing ODI customers.
How is Oracle Data Integrator priced?
Pricing is quote-based. The on-premises Enterprise Edition is licensed under Oracle's standard technology metrics, and it is also available as Oracle Data Integrator Cloud Service on Oracle Cloud Infrastructure, billed per OCPU-hour or via Bring Your Own License (BYOL), per Oracle's published OCI price list.
Evaluating ETL & Data Extraction?
Tell us your ERP and requirements and we'll send an independent shortlist — including Oracle Data Integrator and the best-fit alternatives — with honest pros and cons.