ODI ONLINE TRAINING
0
|
ODI COURSE CONTENT
|
|
|
1. Introduction to Oracle Data
Integrator
|
|
|
|
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
|
|
|
2. 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
|
|
|
3. 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
|
|
|
4. 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
|
|
|
5 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
|
|
|
6. Organizing ODI Models and Creating
Data Sources
|
|
|
|
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
|
|
|
7. 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
|
|
|
8. 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
|
|
|
9. 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
|
|
|
10. Using ODI Procedures
|
|
|
|
What is a Procedure?
|
|
Examples of Procedures
|
|
|
Creating Procedures
|
|
|
Adding Commands
|
|
|
Adding Options
|
|
|
Running a Procedure
|
|
|
Using Operator to View Results
|
|
|
11. 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
|
|
|
12. 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
|
|
|
13. Using Web Services in ODI
|
|
|
|
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
|
|
|
|
|
