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
