Oracle Data Integrator Online Training

Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.

ODI Online Training Course Content
  • Introduction
    • Identifying the Course Units
    • What is Oracle Data Integrator?
    • Why Oracle Data Integrator?
    • Overview of ODI Architecture
    • Overview of ODI Components
    • About Graphical Modules
    • Types of ODI Agents
    • Overview of Oracle Data Integrator Repositories
  • 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
    • Creating and Maintaining Folders
    • Organizing Projects and Folders
    • Understanding Knowledge Modules
    • Exchanging ODI Objects and Sharing Global Objects
    • Exporting and Importing Objects
    • Creating and Labeling with Markers
  • Oracle Data Integrator Model Concepts
    • What is a Model?
    • Understanding Metadata in ODI
    • Understanding Reverse Engineering
    • Creating Models
    • Organizing Models
    • Creating Data stores
    • Configuring Constraints in ODI
    • Creating Keys and References
  • Organizing ODI Models and Creating Data stores
    • What is a Mapping?
    • Business Rules for Mappings
    • Creating a Basic Mapping
    • What is a Join?
    • What is a Filter?
    • What is a Constraint?
    • What is a Staging Area?
  • ODI Mapping Concepts
    • What is a Mapping?
    • Business Rules for Mapping
    • What is a Mapping, a Filter, a Join?
    • Overview of Integration Process
    • What is a Staging Area?
    • Execution Location
    • Mapping with Knowledge Modules (KM)
    • Creating an Intermediate Mapping
  • Designing Mappings
    • Designing a Mapping
    • Multiple Source Data stores
    • Creating Joins
    • Filtering Data
    • Disabling Transformations
    • Overview of the Flow
    • Specifying the Staging Area
    • Selecting Knowledge Modules
  • Mapping: Monitoring and Debugging
    • Monitoring Mappings
    • Creating Objects with Operator
    • Viewing Sessions and Tasks
    • How to Monitor Execution of a Mapping
    • How to Troubleshoot a Session
    • Keys to Reviewing the Generated Code
    • Working with Errors
    • Tips for Preventing Errors
  • Designing Mappings: Advanced Topics
    • Mapping with Business Rules
    • Overview of Business Rule Elements
    • Creating and Tracking Variables
    • Creating User Functions
    • Mapping Substitution Methods
    • Modifying a KM
    • Showing Variable Values in Log
    • Customizing Reverse Engineering Using RKM
  • Creating and Running ODI procedures
    • What is a Procedure?
    • Examples of Procedures
    • Creating Procedures
    • Adding Commands
    • Adding Options
    • Running a Procedure
    • Viewing Results with Operator
  • Creating and Running 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 with Load Plans
    • Preparing Scenarios for Deployment
    • Automating Scenario Management
    • Scheduling the ODI Scenario
    • Overview of ODI version management
    • 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
    • Creating Change Data Capture (CDC)
    • Viewing Data/Changed data
    • 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
  • Creating Web Services and Integration of ODI with SOA
    • 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
    • Integrating ODI with SOA
  • Extending ODI with the SDK
    • Coding SDK Public Interfaces
    • Integrating through ODI SDK
    • Examining SDK examples

Please Register with us