ODI High Level Objectives:
Ø Overview of the
architecture of the complete Oracle Data Integrator system
Ø Define the
Information System architecture
Ø Get started with
projects in Oracle Data Integrator and release your work for deployment
Ø An overview of
models, reverse-engineering model metadata from your database, and how and why
to flesh out models with missing metadata
Ø Manage metadata in
Oracle Data Integrator: models and data quality
Ø Create simple
interfaces and add multiple sources to an interface
Ø Launch a session to
run an interface
Ø Enforce data
quality constraints in an interface
Ø Manage packages
Ø Add more advanced
integration components
Ø Customize data flow
and get the best performance out of your system
Ø An overview of
sessions, use Operator to monitor, stop and start sessions, and basic
troubleshooting.
Introduction :
Ø Identifying the
Course Content
Ø What is Oracle Data
Integrator?
Ø Why Oracle Data
Integrator?
Ø Overview of ODI 11g
Architecture
Ø Overview of ODI 11g
Components
Ø About Graphical
Modules
Ø Types of ODI Agents
Ø Overview of Oracle
Data Integrator Repositories
Installations & Configurations :
Ø Oracle 11G
Database.
Ø ODI 11G
Ø Weblogic Server 11G
Ø Configurations
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
Ø Managing ODI Agents
Ø Creating a 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 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
Ø 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 Data
stores
Ø Using Constraints
in ODI
Ø Creating Keys and
References
Organizing ODI Models and Creating Data stores :
Ø 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
Data stores
Ø Creating Joins
Ø Filtering data
Ø Disabling
Transformations
Ø Overview of the
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 :
Ø 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
