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.
Modules & capabilities
Oracle Data Integrator covers 24 of 52 capabilities we track in this category (+1 partial)
46%- Pre-built connector library100+ databases and applications, flat files, XML, JSON, LDAP and JDBC sourcesCore strength
- Dedicated ERP-specific connectorsDedicated adapters for E-Business Suite, JD Edwards, PeopleSoft, Siebel and SAP ABAP ERP/BWCore strength
- Custom connector SDK / builderPython-based custom Knowledge Module scriptingSupported
- Generic database & API accessJDBC connectivity to third-party databasesSupported
- Legacy ERP application adaptersRKM/IKM adapters for JD Edwards EnterpriseOne, JD Edwards World, Oracle PeopleSoft and Oracle Siebel CRMCore strength
- Community vs. vendor-maintained connector tiersNot evidenced
“Not evidenced” means our research found no public documentation of this capability — the vendor may still offer it. Confirm on a demo.
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
Used Oracle Data Integrator with your ERP? Rate it in 30 seconds — it helps every buyer after you.
Rate itERP integrations
Native connectivity to Oracle Database (including Exadata), Oracle GoldenGate, Oracle Enterprise Data Quality and Oracle Enterprise Manager.
RKM E-Business Suite reverse-engineers EBS objects; IKM E-Business Suite (Open Interface) writes through Open Interface tables, not raw tables directly.
Reads JDE EnterpriseOne 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.
Read-only, data-level extraction from PeopleSoft Business Objects tables on an Oracle or Microsoft SQL Server backend; no documented write-back.
RKM/LKM connect via SAP JCo/RFC to reverse-engineer and extract SAP tables, InfoCubes, InfoObjects, ODS/DSO objects and OpenHubDestinations; extraction only, no documented write-back IKM.
Connector details independently verified against vendor marketplaces and documentation; last checked 2026-08-20.
Pricing
Full Oracle Data Integrator pricing breakdown — cost at 25/100/500 seats, competitor rates & FAQs
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.
What does Oracle Data Integrator cost?
Oracle Data Integrator prices by quote, like most of this category. Here is what actually drives your number — and what to ask before you get one.
4 of the 13 vendors we track in this category publish no list price at all.
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.
Compare Oracle Data Integrator head-to-head
The ETL & Data Extraction Buyer's Guide
Before you commit to Oracle Data Integrator, see how it sits against the 13 ETL & data extraction systems we track — on capability, ERP integration depth and what each one actually charges for.
ETL & Data Extraction Buyer's Guide
13 systems compared · 2026
ERP Research
- Oracle Data Integrator compared side-by-side with 12 alternatives
- ERP integration checklist — what to verify before you shortlist
- The pricing questions that change the quote
- A Oracle Data Integrator evaluation brief, included with the guide
ETL & Data Extraction Buyer's Guide
Get pricing for Oracle Data Integrator
Oracle Data Integrator doesn't publish a price. Tell us your ERP, seat count and must-haves and we'll come back with an independent view of what it should cost you — and which alternatives are worth quoting alongside it.