Retour en haut de la page

Oracle Data Integrator - Administration and Development

4 jours - 28 heures

Objectifs

Describe architecture of Oracle Data Integrator 10g Apply ODI Topology concepts for data integration Describe ODI Model concepts Design ODI Interfaces, Procedures, and Packages to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Administer ODI resources and setup security with ODI Implement Changed Data Capture with ODI Use ODI Web services and perform integration of ODI with SOA

Participants

Business Analysts Data Modelers Data Warehouse Administrator Database Administrators SOA Architect Technical Consultant

Prérequis

Suggested Prerequisites Basic knowledge of ELT data processing Working knowledge of SQL

Pédagogie

La pédagogie est basée sur le principe de la dynamique de groupe avec alternance d'apports théoriques, de phases de réflexion collectives et individuelles, d'exercices, d'études de cas et de mises en situations observées. Formation / Action participative et interactive : les participants sont acteurs de leur formation notamment lors des mises en situation car ils s'appuient sur leurs connaissances, les expériences et mettront en œuvre les nouveaux outils présentés au cours de la session.

Profil de l’intervenant

Consultant-formateur expert. Suivi des compétences techniques et pédagogiques assuré par nos services.

Moyens techniques

Encadrement complet des stagiaires durant la formation. Espace d’accueil, configuration technique des salles et matériel pédagogique dédié pour les formations en centre. Remise d’une documentation pédagogique papier ou numérique à échéance de la formation.

Méthodes d’évaluation des acquis

Exercices individuels et collectifs durant la formation. La feuille d’émargement signée par demi-journée ainsi que l’évaluation des acquis de fin de stage sont adressées avec la facture.

Programme

Introduction

Identifying the Course Units

What is Oracle Data Integrator?

Why Oracle Data Integrator?

Overview of ODI 10g Architecture

Overview of ODI 10g Components

About Graphical Modules

Types of ODI Agents

Overview of Oracle Data Integrator Repositories

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

Using Business Rules in Interfaces

Overview of Business Rule Elements

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 a Procedure?

Examples of Procedures

Creating Procedures

Adding Commands

Adding Options

Running a Procedure

Using Operator to View Results

Using ODI Packages

What is a package?

Creating a 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 a 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 Applications

Data Quality Control in the Integration Process

Data Quality in the Target Applications

Enforcing Data Quality

Exploring Your Data

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

Administering ODI Resources: Advanced Topics

Using Open Tools

Installing Open Tools

Using Open Tools in a Package

Using Open Tools in a Procedure or in a KM

Developing Your Own Open Tools

Setting Up ODI Security

Defining Security Policies

Defining Password Policies

Using Web Services and Integration of Oracle Data Integrator with SOA

Web Services in Action

Using Data Services

Setting Up Data Services

Testing Data Services

Installing Public Web Services

Using Public Web Services

Invoking Web Services

Integrating ODI with SOA

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 WorkRepository

Managing ODI Agents

Creating a Physical Agent

Launching a Listener, Scheduler and Web Agent

Example of Load Balancing

ODI Topology Concepts

Describing the Physical and Logical Architecture

Overview of Topology Manager

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

Using Folders

Organizing Projects and Folders

Understanding Knowledge Modules

Exchanging ODI Objects

Exporting and Importing Objects

Using Markers

Oracle Data Integrator Model Concepts

What is a Model?

Understanding Metadata in ODI

Understanding Reverse Engineering

Creating Models

Organizing Models

Creating Datastores

Using Constraints in ODI

Creating Keys and References

Organizing ODI Models and Creating Datastores

What is an Interface?

Business Rules for Interfaces

What is a Mapping?

What is a Join?

What is a Filter?

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 a Mapping, Filter, Join?

Overview of Integration Process

What is a Staging Area?

About Execution Location

Using Knowledge Modules (KM) with ODI Interface

Creating a Basic Interface

Designing Interfaces

Designing an Interface

Multiple Source Datastores

Creating Joins

Filtering data

Disabling Transformations

Overview of the Flow

Specifying the Staging Area

Selecting Knowledge Modules

1203 log-523.pdf