Oracle Data Integrator 12c: Integration and Administration

Course Overview

Introduction

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

Administering ODI Repositories and Agents

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

ODI Topology Concepts

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

Describing the Physical and Logical Architecture

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

Setting Up a New ODI Project

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

Oracle Data Integrator Model Concepts

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

Organizing ODI Models and Creating Data stores

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

ODI Mapping Concepts

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

Designing Mappings

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

Mapping: Monitoring and Debugging

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

Designing Mappings: Advanced Topics 1

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

Designing Mappings: Advanced Topics 2

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

Using ODI Packages

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

Step-by-Step Debugger

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

Managing ODI Scenarios

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

Using Load Plans

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

Enforcing Data Quality with ODI

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

Advanced ODI Administration

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

Integrating ODI with Subversion

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

Integrating Big Data with ODI

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

Integrating ODI with Subversion

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

Integrating Big Data with ODI

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

Prerequisites

• Basic knowledge of ELT data processing