- Oracle Data IntegratorTraining CurriculumFor Administrators and Developers
Check out our blog
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
×
Terms & Conditions
All rights reserved by USSP