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.

Try Oracle Cloud Free Tier

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.

View the report

Ebook: Enterprise Data Mesh

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

Read the data mesh ebook (PDF)

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.

Oracle Enterprise Metadata Management

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.

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.

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.