thumbnail image
broken image
broken image
broken image
  • Home
  • Services 
    • Technology 
      • Discover
      • Services
    • About Us 
      • LCA Page
      • Careers
      • About Us
      • Contact Us
    • …  
      • Home
      • Services 
        • Technology 
          • Discover
          • Services
        • About Us 
          • LCA Page
          • Careers
          • About Us
          • Contact Us
      broken image
      broken image
      broken image
      • Home
      • Services 
        • Technology 
          • Discover
          • Services
        • About Us 
          • LCA Page
          • Careers
          • About Us
          • Contact Us
        • …  
          • Home
          • Services 
            • Technology 
              • Discover
              • Services
            • About Us 
              • LCA Page
              • Careers
              • About Us
              • Contact Us
          broken image
          • Oracle Data Integrator 
            Training Curriculum

            For Administrators and Developers

          • Check out our blog

            ODI Pundits
          • Goals

            • Describe architecture of Oracle Data Integrator 
            • Apply ODI Topology concepts for data integration
            • Describe ODI Model concepts
            • Design ODI Interfaces, Procedures, and Packages to perform ELT data transformations
            • Explore, audit data, and enforce data quality with ODI
            • Administer ODI resources and setup security with ODI
            • Implement Changed Data Capture with ODI
            • Use ODI Web services and perform integration of ODI with SOA
          • Details

            1. Introduction

            • 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. Repositories and Agents : Administration and Setup

            • 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. Topology: Overview and Concepts

            • Overview of ODI Topology
            • About Data Servers and Physical Schema
            • Defining the Physical Architecture
            • Defining the Logical Architecture
            • Mapping Logical and Physical Resources
            • Defining Agents
            • Defining a Topology
            • Planning the Topology

            4. Topology: Physical and Logical Architecture

            • Overview of Topology Manager
            • 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. Designer: Projects and Folders

            • 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

            6. Designer: 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. Designer: 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 with ODI Interface
            • Creating a Basic Interface

            8. Designer: 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. Operator: 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. Designer: Advanced Topics - Interfaces

            • 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

            11. Designer: Procedures

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

            12. Designer: 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. Operator: 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
            • Designing and creating load plans

            14. Designer: Data Quality and Auditing Data

            • 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

            15. Changed Data Capture (Optional)

            • 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

            16. Administration: 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
            • Automating tasks using SDK
          • Contact Us

            For Availability, Pricing and Customization options

          © 2021 US Software Professionals Inc,

          Terms & Conditions
          Cookie Use
          We use cookies to ensure a smooth browsing experience. By continuing we assume you accept the use of cookies.
          Learn More