Oracle Data Integrator Course Topics

• Architecture
• Architecture Overview
• What Is Oracle Data Integrator?
• The Oracle Data Integrator Architecture
• Components
• Graphical Modules
• Run-Time Components

Topology Concepts

• Overview of the Topology
• What Is the Topology?
• Data Servers and Physical Schemas
• What Is a Data Server?
• Important Note
• What Is a Physical Schema?
• Properties of Physical Schemas
• The Physical Architecture in Oracle Data Integrator

Connecting to Your Data

• Topology Manager
• What Is the Topology?
• What Topology Manager Contains
• The Physical Architecture View
• Data Servers and Physical Schemas
• Prerequisites for Connecting to a Server
• Creating a Data Server
• Some Examples of Drivers and URLs

Defining the Logical Architecture

• Topology Manager
• Overview of Topology Manager
• Logical Architecture/Context Views
• Defining Contexts
• Defining a Context
• Declaring Logical Schemas and Agents
• Creating a Logical Schema
• Linking the Logical and Physical Architecture

Setting Up a New Project

• What Is a Project?
• Overview of Oracle Data Integrator Projects
• What Does a Project Represent?
• Creating a New Project
• Folders
• What Is a Folder?
• What Is a Knowledge Module?
• Exporting and Importing

Oracle Data Integrator Model Concepts

• What Is a Model?
• The Relational Paradigm
• Relational Model Support in Oracle Data Integrator
• Additional Metadata in Oracle Data Integrator
• Reverse-Engineering
• What Is Reverse-Engineering?
• Methods for DBMS Reverse-Engineering
• Standard Versus Customized Reverse-Engineering

Creating and Reverse-Engineering Models

• What Is a Model?
• What Is Reverse-Engineering?
• Methods for DBMS Reverse-Engineering
• How to Create a Model by Reverse-Engineering
• How to Start the Reverse-Engineering Process
• Selective Reverse-Engineering

Fleshing Out Data Models

• Organizing Models
• What Is a Model Folder?
• Creating a Model Folder
• Organizing Datastores into Sub-Models
• Setting Up Automatic Distribution
• Creating a Datastore in a Model
• Adding Columns to a Datastore
• Constraints in Oracle Data Integrator

Enforcing Data Quality with Oracle Data Integrator

• Why Data Quality
• When to Enforce Data Quality
• Data Quality in the Source Applications
• Data Quality Control in the Integration Process
• Data Quality in the Target Applications
• Business Rules for Data Quality
• From Business Rules to Constraints
• Overview of the Data Quality System

Exploring and Auditing Your Data

• Exploring Your Data
• Displaying the Contents of a Datastore
• Viewing the Distribution of Values
• Analyzing the Contents of a Datastore
• Constructing Business Rules
• Defining Business Rules in Oracle Data Integrator
• Deducing Constraints from Data Analysis
• Auditing Data Quality

Interface Design: One-to-one Interfaces

• Creating a One-to-One Interface
• Creating and Naming a New Interface
• Defining the Target Datastore
• Defining the Source Datastore
• What Is a Mapping?
• Defining the Mappings
• Valid Mapping Types
• Saving the Interface

Interface Design 2

• Multiple Sources & Joins
• Multiple Source Datastores
• Manually Creating a Join
• Advanced Joins
• Types of Joins & Setting Up a Join
• Filtering Data
• Filters in Oracle Data Integrator
• Defining a Filter Manually

Executing and Debugging Interfaces

• How to Execute an Interface
• What Happens at Run Time
• Monitoring Interfaces
• Operator: Viewing the Log
• Sessions, Steps, Tasks: The Hierarchy
• Viewing Sessions and Tasks
• How to Monitor Execution of an Interface
• Troubleshooting a Session

Interface Design

• Essential Concepts in Data Quality
• What Is a Constraint?
• Defining and Enforcing Data Quality
• Overview of the Data Quality System
• Properties of Data Quality Control
• Static/Flow Control Differences
• How to Enforce Data Quality for an Interface
• Differences Between Control Types

Defining Simple Procedures

• What Is a Procedure? & Procedure Examples
• Using Procedures: Overview
• How to Create a New Procedure
• Creating a New Command
• Arranging Steps in Order
• Which Parameters Should be Set?
• Valid Types of Commands
• Types of Options

Variables and Sequences

• What Is a Variable?
• Variable Scope
• Value Persistence: Action Types
• Refreshing a Variable with SQL
• Binding Versus Substitution
• How to Create a Variable Step
• Properties of Sequences
• Using Oracle Data Integrator Sequences in Mappings

User Functions

• What Is a User Function?
• Creating User Functions
• Properties of User Functions
• How to Create a User Function
• Defining an Implementation
• Syntax and Implementations
• Using User Functions
• User Functions at Design Time & Run Time

Package Design 1

• What Is a Package?
• How to Create a Package
• Package Diagram Toolbar
• How to Create an Interface Step
• How to Create an Oracle Data Integrator Tool Step
• A Simple Package
• How to Sequence Package Steps
• Executing a Package

Package Design 2

• Types of Package Steps
• Basic & Advanced Step Types
• How to Create a Procedure Step
• Model, Sub-Model and Datastore Steps
• Models, Sub-Models, and Datastore Steps
• How to Create a Variable Step
• Controlling the Execution Path
• Controlling Execution

Releasing Projects

• What Is a Scenario?
• Properties of Scenarios
• Managing Scenarios
• Generating a Scenario
• Generation Versus Regeneration
• Executing a Scenario from the GUI
• Executing a Scenario from a Project
• Preparing Scenarios for Deployment