Oracle OBIEE/ODI Training

Course Content

• 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
• Administrating 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
• ODI 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 Data Sources
  • What is an Interface?
    

    Business Rules for Interfaces

    What is a Mapping?

    What is a Join?

    What is a Filter?

    What is 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
• 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 the 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
• 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