Oracle ODI Online Training

Oracle ODI Online Training at SMC details on how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, you create and manage ODI repositories, which stores configuration information about the IT infrastructure, the meta data for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

Training Duration
4 Weeks

Who Can Get Benefit From Oracle ODI Online Training

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

Details about Oracle ODI Training Course Content.

1. Introduction to Oracle ODI Training 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

2. 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

3. 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

4. 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

5. Setting up a New ODI Project

  • Overview of ODI Projects
  • Creating a New Project
  • Using Folders
  • Organizing Projects and Folders
  • Understanding Knowledge ModulesExchanging ODI Objects
  • Exporting and Importing Objects
  • Using Markers

6. 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

7. 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

8. 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

9. 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

10. Interfaces : Monitoring and Debugging

  • Monitoring Interfaces
  • Using Operator
  • Viewing Sessions and TasksHow to Monitor Execution of an Interface
  • How to Troubleshoot a Session
  • Keys to Reviewing the Generated Code
  • Working with Errors
  • Tips for Preventing Errors

11. Using ODI Procedures

  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Using Operator to View Results

12. 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

13. 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

14. 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

Why should you prefer learning at SMC?

  • First two classes are absolutely FREE!
  • Facilitated with Experienced and Real Time expert trainers!
  • Two way interactive mode
  • Post training support via chat, email, forum available!
  • Online help is provided – we attend to your every query
  • Students have the option to record the session

To check the training schedule and register – Click Here

TAGS