LIT ODI Contents

Oracle Data Integrator

Introduction

·         Identifying the course content

·         What is Oracle Data Integrator?

·         Why Oracle Data Integrator?

·         Overview of ODI11g Architecture

·         Overview of ODI11g Components

·         About Graphical Modules

·         Types of ODI Agents

·         Overview of ODI Repositories

Installations & Configurations

·         Oracle 11g Database

·         ODI 11g

·         Weblogic Server 11g

·         Configurations

Administering ODI Repositories and Agents:

·         Administrating ODI Repositories

·         Creating Repository Storage Spaces

·         Creating and Connecting to Master Repository

·         Creating and Connecting to Work Repository

·         Managing ODI Agents

·         Creating Physical Agent

·         Launching a Listener, Scheduler and Web Agent

·         Example of Load Balancing

ODI Topology Concepts:

·         Overview of ODI Topology

·         About Data Servers and physical schemas

·         Defining Physical Architecture

·         Defining 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 Data Server

·         Testing Data Server Connection

·         Creating a Physical Schema

·         Creating Logical Architecture

·         Overview of Logical Architecture and Context Views

·         Linking the Logical and Physical Architecture

6.Setting Up New ODI Project

·         Overview of ODI Projects

·         Creating a New Project

·         Using Projects

·         Organizing Projects and Folders

·         Understanding Knowledge Modules

·         Exchanging ODI Objects

·         Exporting and Importing Objects

·         Using Markers

ODI Model Concepts

·         What is a Model?

·         Understanding Metadata in ODI

·         Understanding Reverse Engineering

·         Creating Models

·         Organizing Models

·         Creating Data Stores

·         Using Constraints in ODI

·         Creating Keys and References

Organizing ODI Models and creating Data stores

·         What is Interface?

·         Business Rules for Interfaces

·         What is Mapping?

·         What is Filter?

·         What is Join?

·         What is a Constraint?

·         What is a Staging Area?

·         Creating a basic Interface

ODI Interface Concepts

·         What is an Interface

·         Business Rules for Interfaces

·         What is Mapping, Filter, Join?

·         Overview of Integration Process

·         What is Staging Area?

·         About Execution Location

·         Using Knowledge Modules (KM)  with ODI Interface

·         Creating a Basic Interface

Designing Interfaces

·         Designing Interfaces

·         Multiple Source Data Stores

·         Creating Joins

·         Filtering Data

·         Disabling Transformations

·         Overview of Flow

·         Specifying the Staging Area

·         Selecting Knowledge Modules

Interfaces: Monitoring and Debugging

·         Monitoring Interfaces

·         Using Operator

·         Viewing sessions and Tasks

·         How to Monitor Execution of an Interface

·         How to Troubleshoot a session

·         Keys to Reviewing  the Generated code

·         Working with Errors

·         Tips for Preventing Errors

Designing Interfaces: Advanced Topics

·         Use Business Rules in Interfaces

·         Overview of Business Interfaces

·         Using Variables

·         Using User Functions

·         Using Substitution Methods

·         Modifying a KM

·         Developing your own KM

·         Using RKM for Customized Reverse Engineering

Using ODI Procedures

·         What is Procedure?

·         Examples of Procedures

·         Creating Procedures

·         Adding commands

·         Adding Options

·         Running a Procedure

·         Using Operator to view Results

Using ODI Packages

·         Using Package?

·         Creating Package

·         Executing a Package

·         Creating Advanced Packages

·         Error Handling

·         Controlling an Execution path

·         Creating a Loop

·         Using the Advanced Tab

Managing ODI Scenarios and Versions

·    What is Scenario?

·    Managing Scenarios

·    Preparing Scenarios for Deployment

·    Automating Scenario Management

·    Scheduling the ODI Scenario

·    Overview of ODI Version Management

·    Using Version Browser and Version Comparison Tool

·    Handling Concurrent changes

Enforcing Data Quality and Auditing Data with ODI

·    Why Data Quality?

·    When to Enforce Data Quality?

·    Data Quality in Source Application

·    Data Quality control in the Integration Process

·    Data Quality in the Target Applications

·    Enforcing Data Quality

·    Exploring Data Quality

·    Auditing Data Quality

Working with Changed Data Capture

·    Overview of ODI Version management

·    Techniques of changed Data Capture

·    Changed Data Capture in ODI

·    CDC Strategies and Infrastructure

·    CDC Consistency

·    Using CDC

·    Viewing Data/Changed data

·    Using Journalizing

Administrating ODI Resources: Advanced Topics

·    Using Open Tools

·    Installing Open Tools

·    Using Open Tools in a procedure or in a KM

·    Developing your own Open Tools

·    Setting up ODI Security

·    Defining Security Policies

·    Defining Password Polocies