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