Oracle Data Integrator Integation And Administration Student Guide
User Manual:
Open the PDF directly: View PDF
Page Count: 466 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Oracle Data Integrator 11g: Integration and Administration - Student Guide - Volume I
- Table of Contents
- Lesson 1: Introduction to Integration and Administration
- Course Objectives
- Lesson Objectives
- Agenda of Lessons
- Oracle Data Integrator: Introduction
- Why Oracle Data Integrator?
- Conventional Integration Process: ETL
- ELT
- ODI Architecture and Components
- ODI Architecture
- ODI Components: Overview
- Using ODI Studio
- Designer Navigator (Work Repository)
- Operator Navigator (Work Repository)
- Topology Navigator (Master Repository)
- Security Navigator (Master Repository)
- What Is an Agent?
- ODI Agents
- Two Types of Agents: Java EE and Standalone
- Using the Two Types of Agents
- Example of Standalone Agent
- ODI Console
- Enterprise Manager Console
- Oracle Data Integrator Repositories
- ODI Repositories
- Master and Work Repositories
- Repository Setup: Example
- Repository Setup: Multiple Master Repositories
- Components: A Global View
- Possible ODI Methodology
- Checklist of Practice Activities
- Starting Oracle Data Integrator
- Using Online Help
- Quiz
- Summary
- Practice 1-1: Overview
- Lesson 2: Administering ODI Repositories
- Objectives
- Administering the ODI Repositories
- Initial Repository Administration Tasks
- Steps to Set Up ODI Repositories
- 1. Creating Repository Storage Spaces
- 2. Creating the Master Repository
- 3. Connecting to the Master Repository
- Importing the Master Repository
- Exporting the Master Repository
- 4. Creating a Work Repository
- 5. Connecting to the Work Repository
- Changing the Work Repository Password
- Creating Repositories with the RCU
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 2-1: Overview
- Lesson 3: ODI Topology Concepts
- Objectives
- ODI Topology: Overview
- What Is Topology?
- What Is in the Topology?
- Data Servers and Physical Schemas
- What Is a Data Server?
- Important Guideline 1
- What Is a Physical Schema?
- Physical Schemas: Properties
- Technology Terminology Among Vendors
- Important Guideline 2 and Recommendations
- Defining Topology: Example
- Example: Infrastructure for Two Production Sites
- ODI Design: Physical Architecture of the Two Production Sites
- Logical Schemas and Contexts
- What Is a Logical Schema?
- Important Guideline 3
- Logical Versus Physical Architecture
- Note: Design Time Versus Run Time
- What Is a Context?
- A Context Maps a Logical to a Physical Schema
- Defining Contexts
- Mapping Logical and Physical Resources
- Agents in Topology
- ODI Physical Agents
- Creating a Physical Agent
- ODI Agent Parameters
- Launching a Standalone Agent: Examples
- Stopping the ODI Agent
- Deploying and Configuring a Java EE Agent
- Deploying and Configuring Java EE Agent
- Load Balancing: Example
- Important Guideline 5
- Infrastructure with Agents: Example
- Defining Agents: Example
- Special Case: Fragmentation Problem
- Special Case: Important Guideline 6
- Special Case: Defining the Physical Architecture
- Special Case: The Infrastructure
- Special Case: Physical Architecture in ODI
- Defining a Topology: Best Practices
- Planning the Topology
- Matrix of Logical and Physical Mappings
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 3-1: Overview
- Lesson 4: Describing the Physical and Logical Architecture
- Objectives
- Topology Navigator
- What Topology Navigator Contains
- Topology Navigator: Overview
- Review: Context Connects Logical to Physical
- Objects You Create in the Practice
- Defining a Context
- Creating Physical Architecture
- Physical Architecture View
- Prerequisites for Connecting to a Server
- Important Note
- Creating a Data Server
- Creating a Data Server: JDBC
- JDBC Driver
- JDBC URL
- Creating a Data Server: JNDI
- Testing a Data Server Connection
- Creating a Physical Schema
- Creating Logical Architecture
- Logical Architecture and Context Views
- Creating a Logical Schema
- Creating a Logical Agent
- Editing a Context to Link the Logical and Physical Agents
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 4-1: Overview
- Lesson 5: Setting Up a New ODI Project
- Objectives
- ODI Projects
- What Is a Project?
- Oracle Data Integrator Projects: Overview
- How to Use ODI Projects in Your Work
- Creating a New Project
- Using Folders
- What Is a Folder?
- Creating a New Folder
- Organizing Projects and Folders
- Understanding Knowledge Modules
- What Is a Knowledge Module?
- Types of Knowledge Modules
- Which Knowledge Modules Are Needed?
- Knowledge Modules: Examples
- Importing Knowledge Modules
- Replacing Existing KMs
- Knowledge Module Editor
- Editing a Knowledge Module
- Exporting and Importing Objects
- Exporting and Importing
- Exporting an Object
- Importing an Object
- ID Numbers: Overview
- Import Types
- Choosing the Import Mode
- Import Report
- What Is a Marker?
- Tagging Objects with Markers
- Removing Markers
- Marker Groups
- Project and Global Markers
- Creating a Marker Group
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 5-1: Overview
- Lesson 6: Oracle Data Integrator Model Concepts
- Objectives
- What Is a Model?
- Understanding the Relational Model
- Relational Model
- Relational Model: Tables and Columns
- Relational Model: Keys
- Relational Model: Foreign Keys
- Relational Model: Constraints
- Relational Model: Indexes
- Relational Model Support in ODI
- Additional Metadata in ODI
- FlexFields
- Understanding Reverse-Engineering
- What Is Reverse-Engineering?
- Methods for DBMS Reverse-Engineering
- Other Methods for Reverse-Engineering
- Standard Versus Customized Reverse- Engineering
- Note
- Creating Models
- How to Create a Model by Reverse-Engineering
- Step 1: Creating and Naming a New Model
- Note About Creating and Naming a New Model
- Step 2: Defining a Reverse-Engineering Strategy
- Step 3: Starting the Reverse-Engineering Process
- Using RKM for Customized Reverse-Engineering
- Selective Reverse-Engineering
- Step 4: Fleshing Out Models
- Shortcuts
- Smart Export and Import
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 6-1 Overview: Results of Reverse-Engineering into Models
- Lesson 7: Organizing ODI Models and Creating ODI Datastores
- Objectives
- Organizing Models
- What Is a Model Folder?
- Creating a Model Folder
- What Is a Submodel?
- Creating a Submodel
- Organizing Datastores into Submodels
- Setting Up Automatic Distribution
- Creating Datastores
- Creating a Datastore in a Model
- Adding Columns to a Datastore
- Constraints in ODI
- What Is a Constraint in ODI?
- Constraints in ODI
- Creating a Mandatory Column
- Creating Keys and References
- Creating a Key
- Checking a Key
- Creating a Reference
- Creating a Simple Reference
- Creating a Complex Reference
- Checking a Reference
- Creating Conditions
- Creating a Condition
- Checking a Condition
- Overview
- When and Why?
- An Overview of the Process
- Exploring Your Data
- Displaying the Contents of a Datastore
- Viewing the Distribution of Values
- Analyzing the Contents of a Datastore
- Constructing Business Rules
- Defining Business Rules in ODI
- From Business Rules to Constraints
- Deducing Constraints from Data Analysis
- Testing a Constraint
- Auditing a Model or Datastore
- How to Review Erroneous Records
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 7-1: Overview
- Lesson 8: ODI Interface Concepts
- Objectives
- ODI Interfaces
- What Is an Interface?
- Business Rules for Interfaces
- Where Are the Rules Defined?
- Mapping
- What Is a Mapping?
- What Is a Join?
- What Is a Filter?
- What Is a Lookup?
- What Is a Data Set?
- Behind the Rules
- How Does ODI Implement Business Rules?
- A Business Problem
- Implementing the Rules
- Integration Process
- Process Details
- Process Implementation: Example 1
- Process Implementation: Example 2
- Process Implementation: Example 3
- Staging Area and Execution Location
- What Is the Staging Area?
- Execution Location
- Understanding Knowledge Modules
- From Business Rules to Processes
- Knowledge Modules
- What Is a Knowledge Module?
- Code Generation
- KM Types Used in Interfaces
- Interfaces: An Overview
- The Purpose of an Interface
- Creating a One-to-One Interface
- Creating and Naming an Interface
- Defining the Target Datastore
- Important Note
- Defining the Source Datastore
- What Is a Mapping?
- Defining the Mappings
- Valid Mapping Types
- Saving the Interface
- Executing the Interface
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 8-1: Overview
- Lesson 9: Designing Interfaces
- Objectives
- Multiple Sources and Joins
- Multiple-Source Datastores
- Creating a Join Manually
- Advanced Joins
- Types of Joins
- Setting Up a Join
- Lookups
- Using Lookups
- Lookup Wizard
- Lookup Limitations
- Filtering Data
- Filters in ODI
- Defining a Filter Manually
- Setting Up a Filter
- Overview of the Flow in ODI Interface
- Flow
- What Defines the Flow?
- The Scenario
- The Basic Process
- Selecting a Staging Area
- The Purpose of a Staging Area
- Placing the Staging Area
- Important Note
- How to Specify the Staging Area
- Configuring Filters
- Options for Filters
- Setting Options for Filters
- How to Disable a Transformation
- How to Enable a Mapping for Inserts or Updates
- Execution Location
- Execution Location and Syntax
- Why Change the Execution Location?
- How to Change the Execution Location
- ODI Interface Execution Simulation
- Selecting the Knowledge Module
- Which KMs for Which Flow?
- More About KMs
- Identifying IKMs and LKMs
- IKMs and LKMs: Strategies and Methods
- How to Specify an LKM
- How to Specify an IKM
- Common KM Options
- Flow: Example 1
- Flow: Example 2
- Flow: Example 3
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 9-1: Overview
- Practice 9-2: Overview
- Lesson 10: Interfaces: Monitoring and Debugging
- Objectives
- Monitoring Interfaces
- Operator Navigator: Viewing the Log
- Using Operator Navigator
- Sessions
- Viewing Details of Sessions
- How to Monitor Execution of an Interface
- How to Troubleshoot a Session
- 1. Identifying the Error
- 2. Reviewing the Code
- 3. How to Fix the Code and Restart the Session
- 4. Fixing the Interface
- Keys to Reviewing the Generated Code
- Working with Errors
- Common Errors and Symptoms
- Important Note
- Tips for Preventing Errors
- Using Quick-Edit Editor
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 10-1: Overview
- Lesson 11: Designing Interfaces: Advanced Topics 1
- Objectives
- Working with Business Rules
- Business Rules in Interfaces
- Business Rule Elements
- More Elements
- The Expression Editor
- Using Variables
- Using a Variable in Code
- Binding Versus Substitution
- Note: Case Sensitivity
- Data Sets and Set-Based Operators
- Flow with Multiple Data Sets
- Defining a Data Set
- Using Set-Based Operators
- Using Sequences
- Types of Sequences
- Support for Native Sequences
- Creating a Native Sequence
- Referring to Sequences
- Note: Sequences Updated by Agent
- Using Standard Sequences in Mappings Correctly
- Using ODI Standard Sequences in Mappings
- Populating Native Identity Columns
- Note
- Automatic Temporary Index Management
- Tracking Variables and Sequences
- How Variable and Sequence Tracking Works
- New Variable Actions
- Definition Tab of Session Step or Session Task
- Quiz
- Summary
- Checklist of Practice Activities
- Practice 11-1: Overview
- Practice 11-2: Overview
- Practice 11-3: Overview