• Overview of ODI Components
• Overview of Oracle Data Integrator Repositories
• Identifying the Course Units
• Types of ODI Agents
• Overview of ODI Architecture
• About Graphical Modules
• Why Oracle Data Integrator?

Module 2: Administering ODI Repositories and Agents

• Creating a Wallet to Securely Store Credentials
• Administrating the ODI Repositories
• Creating Repository Storage Spaces
• Creating and Connecting to the Work Repository
• Managing ODI Agents
• Creating and Connecting to the Master Repository

Module 3: ODI Topology Concepts

• Overview of ODI Topology
• Defining a Topology
• Planning the Topology
• About Data Servers and Physical Schemas
• Mapping Logical and Physical Resources
• Defining the Logical Architecture
• Defining Agents
• Defining the Physical Architecture

Module 4: Describing the Physical and Logical Architecture

• Creating Logical Architecture
• Testing a Data Server Connection
• Overview of Logical Architecture and Context Views
• Creating a Physical Schema
• Creating Physical Architecture
• Creating a Data Server
• Overview of Topology Navigator
• Linking the Logical and Physical Architecture

Module 5: Setting Up a New ODI Project

• Overview of ODI Projects
• Creating and Maintaining Folders
• Creating and Labeling with Markers
• Exporting and Importing Objects
• Creating a New Project
• Understanding Knowledge Modules
• Exchanging ODI Objects and Sharing Global Objects
• Organizing Projects and Folders

Module 6: Oracle Data Integrator Model Concepts

• Creating Data stores
• Organizing Models
• Understanding Metadata in ODI
• What is a Model?
• Creating Models
• Creating Keys and References
• Understanding Reverse Engineering
• Configuring Constraints in ODI

Module 7: Organizing ODI Models and Creating Data stores

• What is a Filter?
• What is a Constraint?
• Creating a Basic Mapping
• Business Rules for Mappings
• What is a Mapping?
• What is a Join?
• What is a Staging Area?

Module 8: ODI Mapping Concepts

• Mapping with Knowledge Modules (KM)
• Execution Location
• Creating an Intermediate Mapping
• What is a Staging Area?
• What is a Mapping, a Filter, a Join?
• What is a Mapping?
• Overview of Integration Process
• Business Rules for Mapping

Module 9: Designing Mappings

• Creating Joins
• Filtering Data
• Multiple Source Data stores
• Designing a Mapping
• Overview of the Flow
• Selecting Knowledge Modules
• Disabling Transformations
• Specifying the Staging Area

Module 10: Mapping: Monitoring and Debugging

• How to Troubleshoot a Session
• Tips for Preventing Errors
• Monitoring Mappings
• Keys to Reviewing the Generated Code
• Working with Errors
• Viewing Sessions and Tasks
• How to Monitor Execution of a Mapping
• Creating Objects with Operator

Module 11: Designing Mappings: Advanced Topics 1

• Mapping with Business Rules
• Creating User Functions
• Mapping Substitution Methods
• Modifying a KM
• Showing Variable Values in Log
• Creating and Tracking Variables
• Customizing Reverse Engineering Using RKM
• Overview of Business Rule Elements

Module 12: Designing Mappings: Advanced Topics 2

• Using Substitution Methods
• Developing Your Own Knowledge Module
• Using User Functions
• Reusable Mappings
• Creating a User Function
• Using Partitioning in a Mapping
• Derived Select (Subselect) for Reusable Mappings

Module 13: Using ODI Procedures

• What is a Procedure?
• Adding Commands
• Examples of Procedures
• Viewing Results with Operator Navigator
• Running a Procedure
• Adding Options
• Creating Procedures

Module 14: Using ODI Packages

• Variable Steps
• Controlling the Execution Path
• Error Handling
• Review of Package Steps
• Executing a Package
• What is a Package?
• Creating Model, Submodel and Datastore Steps
• Creating a Package

Module 15: Step-by-Step Debugger

• Menu Bar Icons
• Screen Step Numbering
• Control Execution Flow
• Specifying Debug Properties
• New Functionality
• Starting a Session in Debug mode

Module 16: Managing ODI Scenarios

• Generating a Scenario
• What is a Scenario?
• Scheduling the ODI Scenario
• Managing Schedules
• Executing a Scenario
• Automating Scenario Management

Module 17: Using Load Plans

• Defining the Restart Behavior
• What Are Load Plans?
• Load Plan Editor
• Load Plan Steps
• Benefits of Using Load Plans
• Handling Failed Load Plans

Module 18: Enforcing Data Quality with ODI

• Why Data Quality? When to Enforce Data Quality?
• Data Quality in Source Applications
• Enabling Static or Flow Control for a Mapping
• Data Quality Business Rules
• Data Quality Control in the Integration Process
• Data Quality in the Target Applications
• Setting the Options, Selecting Which Constraints to Enforce
• Reviewing Erroneous Records

Module 19: Working with Changed Data Capture (CDC)

• Journalizing
• Oracle GoldenGate Integration
• Changed Data Capture in ODI
• Viewing Data/Changed data
• CDC Strategies and Infrastructure
• Why Changed Data Capture? Techniques of Changed Data Capture
• CDC Consistency
• Creating Change Data Capture (CDC)

Module 20: Advanced ODI Administration

• Generating Topology Reports
• Integration of ODI with Enterprise Manager
• Java EE Agent and Enterprise Manager Configuration with WebLogic Domain
• Defining Password Policies
• Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User
• Introduction to ODI Security Navigator. Security Concepts: Overview, Defining Security Policies
• Implementing External Authentication
• Using ODI Console

Module 21: Integrating ODI with Subversion

• Configuring the Subversion Repository with ODI
• Creating Full or Partial Tags in the Subversion Repository
• SVN Connections
• Performing a Branch Merge
• Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN
• ODI: VCS Integration
• Creating a New Version for an Object. Creating Full or Partial Tags in the Subversion Repository
• ODI: Selecting the Required VCS

Module 22: Integrating Big Data with ODI

• Emergence of Apache Hadoop. Hadoop Ecosystem
• Big Data Concepts
• ODI: Hadoop Integration Process
• Big Data Knowledge Modules Matrix
• Apache HBase, Apache Hive, Apache Pig. Apache Spark, Apache Sqoop, Apache Oozie
• Hadoop Data Integration: Overview