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. Read The Forrester Wave™: Enterprise Data Fabric, Q2 2020 named Oracle as a leader blog.
Push-down transformation to the database to minimize performance impact on source systems.
Use the power of the database system CPU and memory to execute transformations instead of a separate, conventional ETL transformation server.
Generate Apache Spark code following big data standards to transform and execute data mappings.
Large library of knowledge modules simplifies integrating sources and targets. Oracle Data Integrator’s modular design gives developers more flexibility when connecting multiple systems.
Reuse data-mapping rules accelerate development of integration logic and increase productivity.
ODI Studio uses best practices to simplify data mapping between systems.
Prebuilt big data connectors for Hadoop, Spark Streaming, Hive, Kafka, HBase, Sqoop, Pig, Cassandra, NoSQL databases, and more allows users to integrate any data from any source.
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.
Enhance ETL with data replication to keep databases and data warehouses synchronized.
Faster data load and transformation of real-time data into a data warehouse or big data system.
Harvest metadata for exploration, search, and data lineage from Oracle and third-party technologies for greater confidence in data.
Compare metadata models for compliance.
Oracle Enterprise Manager addresses monitoring and management from one location, improving productivity.
Monitor and manage your ETL and integration activities within the Oracle Enterprise Manager platform.
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.
Import and prepare data for analysis in data warehouses with automatic transformation capabilities.
Ingest unstructured and object data into data lakes from many sources
Import and prepare data for use in modeling and big-data analytics with Hadoop, Kafka, JMS, NoSQL databases for ML and AI.
Enjoy native support for big data by leveraging the Spark engine for integrations.
Find more Oracle Data Integrator technical information
Pre-configured Oracle Data Integrator simplifies data load and transformation in Oracle Cloud.
Try the latest Oracle Data Integrator release on various platforms.