Course Topics
1. Introduction
- Overview of ODI Components
- Overview of Oracle Data Integrator Repositories
- Identifying the Course Units
- Types of ODI Agents
- Overview of ODI Architecture
- About Graphical Modules
- Why Oracle Data Integrator?
2. Administering ODI Repositories and Agents
- Creating a Wallet to Securely Store Credentials
- Administrating the ODI Repositories
- Creating Repository Storage Spaces
- Creating and Connecting to the Work Repository
- Managing ODI Agents
- Creating and Connecting to the Master Repository
3. ODI Topology Concepts
- Overview of ODI Topology
- Defining a Topology
- Planning the Topology
- About Data Servers and Physical Schemas
- Mapping Logical and Physical Resources
- Defining the Logical Architecture
- Defining Agents
- Defining the Physical Architecture
4. Describing the Physical and Logical Architecture
- Creating Logical Architecture
- Testing a Data Server Connection
- Overview of Logical Architecture and Context Views
- Creating a Physical Schema
- Creating Physical Architecture
- Creating a Data Server
- Overview of Topology Navigator
- Linking the Logical and Physical Architecture
5. Setting Up a New ODI Project
- Overview of ODI Projects
- Creating and Maintaining Folders
- Creating and Labeling with Markers
- Exporting and Importing Objects
- Creating a New Project
- Understanding Knowledge Modules
- Exchanging ODI Objects and Sharing Global Objects
- Organizing Projects and Folders
6. Oracle Data Integrator Model Concepts
- Creating Data stores
- Organizing Models
- Understanding Metadata in ODI
- What is a Model?
- Creating Models
- Creating Keys and References
- Understanding Reverse Engineering
- Configuring Constraints in ODI
7. Organizing ODI Models and Creating Data stores
- What is a Filter?
- What is a Constraint?
- Creating a Basic Mapping
- Business Rules for Mappings
- What is a Mapping?
- What is a Join?
- What is a Staging Area?
8. ODI Mapping Concepts
- Mapping with Knowledge Modules (KM)
- Execution Location
- Creating an Intermediate Mapping
- What is a Staging Area?
- What is a Mapping, a Filter, a Join?
- What is a Mapping?
- Overview of Integration Process
- Business Rules for Mapping
9. Designing Mappings
- Creating Joins
- Filtering Data
- Multiple Source Data stores
- Designing a Mapping
- Overview of the Flow
- Selecting Knowledge Modules
- Disabling Transformations
- Specifying the Staging Area
10. Mapping: Monitoring and Debugging
- How to Troubleshoot a Session
- Tips for Preventing Errors
- Monitoring Mappings
- Keys to Reviewing the Generated Code
- Working with Errors
- Viewing Sessions and Tasks
- How to Monitor Execution of a Mapping
- Creating Objects with Operator
11. Designing Mappings: Advanced Topics 1
- Mapping with Business Rules
- Creating User Functions
- Mapping Substitution Methods
- Modifying a KM
- Showing Variable Values in Log
- Creating and Tracking Variables
- Customizing Reverse Engineering Using RKM
- Overview of Business Rule Elements
12. Designing Mappings: Advanced Topics 2
- Using Substitution Methods
- Developing Your Own Knowledge Module
- Using User Functions
- Reusable Mappings
- Creating a User Function
- Using Partitioning in a Mapping
- Derived Select (Subselect) for Reusable Mappings
13. Using ODI Procedures
- What is a Procedure?
- Adding Commands
- Examples of Procedures
- Viewing Results with Operator Navigator
- Running a Procedure
- Adding Options
- Creating Procedures
14. Using ODI Packages
- Variable Steps
- Controlling the Execution Path
- Error Handling
- Review of Package Steps
- Executing a Package
- What is a Package?
- Creating Model, Submodel and Datastore Steps
- Creating a Package
15. Step-by-Step Debugger
- Menu Bar Icons
- Screen Step Numbering
- Control Execution Flow
- Specifying Debug Properties
- New Functionality
- Starting a Session in Debug mode
16. Managing ODI Scenarios
- Generating a Scenario
- What is a Scenario?
- Scheduling the ODI Scenario
- Managing Schedules
- Executing a Scenario
- Automating Scenario Management
17. Using Load Plans
- Defining the Restart Behavior
- What Are Load Plans?
- Load Plan Editor
- Load Plan Steps
- Benefits of Using Load Plans
- Handling Failed Load Plans
18. Enforcing Data Quality with ODI
- Why Data Quality? When to Enforce Data Quality?
- Data Quality in Source Applications
- Enabling Static or Flow Control for a Mapping
- Data Quality Business Rules
- Data Quality Control in the Integration Process
- Data Quality in the Target Applications
- Setting the Options, Selecting Which Constraints to Enforce
- Reviewing Erroneous Records
19. Working with Changed Data Capture (CDC)
- Journalizing
- Oracle GoldenGate Integration
- Changed Data Capture in ODI
- Viewing Data/Changed data
- CDC Strategies and Infrastructure
- Why Changed Data Capture? Techniques of Changed Data Capture
- CDC Consistency
- Creating Change Data Capture (CDC)
20. Advanced ODI Administration
- Generating Topology Reports
- Integration of ODI with Enterprise Manager
- Java EE Agent and Enterprise Manager Configuration with WebLogic Domain
- Defining Password Policies
- Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User
- Introduction to ODI Security Navigator. Security Concepts: Overview, Defining Security Policies
- Implementing External Authentication
- Using ODI Console
21. Integrating ODI with Subversion
- Configuring the Subversion Repository with ODI
- Creating Full or Partial Tags in the Subversion Repository
- SVN Connections
- Performing a Branch Merge
- Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN
- ODI: VCS Integration
- Creating a New Version for an Object. Creating Full or Partial Tags in the Subversion Repository
- ODI: Selecting the Required VCS
22. Integrating Big Data with ODI
- Emergence of Apache Hadoop. Hadoop Ecosystem
- Big Data Concepts
- ODI: Hadoop Integration Process
- Big Data Knowledge Modules Matrix
- Apache HBase, Apache Hive, Apache Pig. Apache Spark, Apache Sqoop, Apache Oozie
- Hadoop Data Integration: Overview
