Mastering Oracle Data Integrator (Odi)

Comprehensive ETL, Data Integration and Change Data Capture (Oracle Golden Gate)

What you'll learn

Gain expertise in Oracle Data Integrator (ODI) and its architecture

Master the use of variables, packages, and workflows for effective data integration

Learn to work with diverse databases, including MySQL, Microsoft SQL Server, Oracle Database

Understand handling flat files and integrating file data in ODI

Learn to work with Slowly Changing Dimension (SCD) techniques in ODI

Explore real-time ETL through Change Data Capture (CDC) and Oracle GoldenGate

Acquire practical skills for building ETL mappings, monitoring operations, using ODI for comprehensive data integration

Requirements

Basic knowledge of databases and SQL

Familiarity with data integration concepts

Understanding of ETL (Extract, Transform, Load) processes

Access to a computer with Oracle Data Integrator (ODI) installed (Optional)

Basic understanding of Oracle GoldenGate concepts

Access to relevant databases for hands-on exercises

Description

The "Mastering Oracle Data Integrator (ODI) - Comprehensive ETL and Data Integration" course is designed for individuals aspiring to excel in data integration and ETL processes. Throughout the course, participants will explore ODI's robust features, enabling them to create and manage ETL mappings efficiently. They will learn to define schemas, work with contexts, and reverse-engineer metadata into ODI models. Practical demonstrations will cover variable usage, package creation, and working with Knowledge Modules (KMs) for optimized data processing.The course includes a detailed exploration of working with specific databases such as MySQL, Microsoft SQL Server and Oracle Database, along with integrating file data seamlessly. Participants will master the intricacies of creating workflows, including packages and load plans, ensuring streamlined ETL processes. Furthermore, the course provides a comprehensive understanding of Slowly Changing Dimensions (SCD), a crucial aspect of data warehousing.A key focus is on real-time ETL using Change Data Capture (CDC) and Oracle GoldenGate. Participants will gain hands-on experience with CDC configurations and leveraging Oracle GoldenGate for real-time data replication. This comprehensive curriculum ensures that learners develop a proficiency in orchestrating end-to-end ETL processes, making them adept in data integration tasks across diverse database environments. Upon completion, participants will possess the skills to implement efficient and real-time data integration solutions, positioning them as valuable professionals in the realm of data management and analytics.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Materials

Section 2: Introduction to Oracle Data Integrator (ODI)

Lecture 3 Data integration usage scenarios

Lecture 4 ODI Product Overview

Lecture 5 ODI product architecture - Part 1

Lecture 6 ODI product architecture - Part 2

Lecture 7 ODI product architecture - Part 3

Lecture 8 ODI Studio - Part 1

Lecture 9 ODI Studio - Part 2

Lecture 10 ODI Agent

Lecture 11 WebLogic Enterprise Manager

Lecture 12 Execution Context - Part 1

Lecture 13 Execution Context - Part 2

Lecture 14 Knowledge Modules

Lecture 15 Models

Lecture 16 Mappings

Lecture 17 Packages & Scenarios

Lecture 18 Connect to Repository

Lecture 19 Demonstration: Introduction to Oracle Data Integrator (ODI)

Section 3: Mastering Variables and Packages

Lecture 20 Variable location and scopes

Lecture 21 Refreshing variables

Lecture 22 Assigning a value to a variable

Lecture 23 Referencing variables

Lecture 24 Variables in models

Lecture 25 Variables utilization in Package

Lecture 26 Demonstration: Mastering Variables and Packages

Section 4: ODI Sources, Targets, and Knowledge Modules

Lecture 27 ODI Sources, Targets, and Knowledge Modules

Lecture 28 Defining physical data servers

Lecture 29 Defining Physical Schemas (Data Sources)

Lecture 30 Defining Physical Schemas (Target Data Source)

Lecture 31 Defining Logical Schemas and Contexts

Lecture 32 Reverse-engineering metadata into ODI models

Lecture 33 Reverse-engineering metadata into ODI models -Example

Lecture 34 Custom reverse-engineering

Lecture 35 Knowledge Modules Using Example

Lecture 36 Detail Importing a Knowledge Module

Section 5: Working with Databases

Lecture 37 Topology configuration - Data Server, Schema, Model Reverse Engineering

Lecture 38 Create project & Do ODI Mappings

Lecture 39 Perform moving the data using an ODI Mappings

Lecture 40 Operator Navigator - Monitor ODI Mappings process

Lecture 41 Demonstration: ODI Sources, Targets, and Knowledge Modules & Working with Databa

Section 6: Working with Specific Databases

Lecture 42 Source MySQL Table example

Lecture 43 Create Data Server on Source and Target

Lecture 44 Physical Schema, Logical Schema

Lecture 45 Reverse Engineering Models

Lecture 46 Mappings

Lecture 47 Monitor Mappings running process - Operator Navigator

Lecture 48 MSSQL Database Loading by using ODI

Lecture 49 MSSQL Loading Monitor - Operator Navigator

Lecture 50 Demonstration: Working with Specific Databases - Microsoft SQL Server & Oracle

Lecture 51 Demonstration: Working with Specific Databases - MySQL & Oracle

Section 7: Integrating File Data

Lecture 52 File Loading by using ODI - Topology Configuration

Lecture 53 File Loading by using ODI - Mapping Running and Monitoring

Lecture 54 Demonstration: Integrating File Data

Section 8: Creating Workflows

Lecture 55 Packages and Load Plans - Mastering Workflows

Lecture 56 Demonstration: Creating Workflows – Packages and Load Plans

Section 9: ODI ETL with Slowly Changing Dimension (SCD) table

Lecture 57 Slowly Changing Dimension Configuration

Lecture 58 Slowly Changing Dimension Mapping

Lecture 59 Slowly Changing Dimension - Running and Monitoring

Lecture 60 Demonstration: ODI ETL with Slowly Changing Dimension (SCD)

Section 10: Real-time ETL with Change Data Capture (CDC) and Oracle GoldenGate (OGG)

Lecture 61 Oracle GoldenGate Overview

Lecture 62 Oracle GoldenGate Example with Core Banking System

Lecture 63 Oracle GoldenGate Commands

Lecture 64 Oracle GoldenGate - Demo Extract Process

Lecture 65 Oracle GoldenGate - Demo Pump Process

Lecture 66 Oracle GoldenGate - Demo Replicate Process

Lecture 67 Oracle GoldenGate - Results

Lecture 68 Oracle ODI CDC

Lecture 69 Oracle ODI CDC Realtime Movement

Lecture 70 Real-time ETL with Change Data Capture (CDC) and Oracle Golden Gate (OGG)-Part 1

Section 11: Summary

Lecture 71 Recap – what have you learnt!

Database developers and administrators seeking to master Oracle Data Integrator (ODI) for comprehensive ETL and data integration,Data engineers and integration professionals looking to enhance their skills in real-time data movement and replication,Business intelligence professionals or data architect aiming to leverage ODI for efficient data warehousing solutions,Data Engineer interested in mastering Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) techniques,Data Engineer aspiring to implement real-time ETL using Oracle GoldenGate in conjunction with ODI,Students and professionals aiming to advance their careers in data management and integration