Oracle Data Integrator (ODI) 12c

6 Saturdays (9am to 11am) | Intermediate to Advanced | Course Notes

Course Content

Overview of Oracle Data Integrator 12c architecture and key components
Understanding the difference between ETL and ELT with ODI's declarative design
Installing and configuring ODI Studio, Master Repository, and Work Repository
Setting up the Topology: Physical and Logical architectures, Data Servers, and Agents
Configuring contexts, languages, and schemas for multi-environment deployments
Managing database connections (Oracle, SQL Server, MySQL, etc.) and file systems
Navigating the ODI Studio interface: Designer, Operator, Topology, and Security Manager
Best practices for repository backup, versioning, and environment setup

Creating projects, folders, and models using the Designer navigator
Reverse-engineering database schemas and working with datastores
Building basic and intermediate Interfaces (mappings) using the graphical flow editor
Understanding Knowledge Modules (KMs): Loading, Integration, Control, and Service KMs
Deep dive into IKM (Integration Knowledge Module) and LKM (Loading Knowledge Module)
Configuring CKM (Check Knowledge Module) for data quality and error handling
Implementing incremental data loading strategies (CDC and journalization)
Performance tuning of interfaces using optimized ELT techniques

Implementing Type 1, Type 2, and Type 3 Slowly Changing Dimensions in ODI
Using IKM SCD and IKM Incremental Update for dimension management
Handling complex source-target mappings and multi-table joins
Implementing expressions, filters, and transformations using the expression editor
Working with variables, sequences, and user-defined functions
Integrating multiple data sources (relational, flat files, XML, JSON)
Building reusable mappings and modular ETL components
Implementing referential integrity and constraint validation

Navigating the Operator navigator for execution monitoring and session management
Understanding the execution lifecycle: Design, Flow, and Data control phases
Monitoring sessions, steps, and tasks in real-time with graphical views
Managing error logging, debugging, and troubleshooting failed sessions
Implementing custom error handlers and recovery mechanisms
Optimizing memory, temporary tables, and bulk-loading performance
Implementing data quality and record deduplication using CKM
Creating exception tables and reporting bad records for data stewardship

Designing load plans for end-to-end data integration orchestration
Defining sequences, conditionals, and parallel execution within load plans
Configuring ODI Agents for scheduling and automating job execution
Integrating ODI with enterprise schedulers (Oracle Scheduler, Control-M, etc.)
Managing runtime parameters, variables, and dynamic context switching
Implementing rollback, restart, and recovery strategies for production workflows
Exporting and importing projects using Smart Export/Import and XML archives
Version control integration with Git/SVN for collaborative development

Integrating ODI with Big Data ecosystems: Hadoop (Hive, HDFS) and Spark
Using Oracle Big Data Connectors and advanced KMs for distributed processing
Implementing real-time data integration using ODI's CDC and web services
Deploying ODI projects across development, test, and production environments
Using OdiLite and standalone agents for lightweight deployments
Managing security, credential management, and encryption in production
Performance monitoring, capacity planning, and high-availability configurations
Capstone Project: Build a complete enterprise data warehouse integration pipeline from source extraction to target loading with full CDC and scheduling

Project: Design and implement a full data integration pipeline for a real-world data warehousing scenario using Oracle ODI 12c.

Starting Date: 4th July 2026
Course Fee: £2990