Oracle Data Integrator 12c: Integration and Administration (D82167) – Details

Detaillierter Kursinhalt

Introduction
  • Identifying the Course Units
  • Why Oracle Data Integrator?
  • Overview of ODI Architecture
  • Overview of ODI Components
  • About Graphical Modules
  • Types of ODI Agents
  • Overview of Oracle Data Integrator Repositories
Administering ODI Repositories and Agents
  • Administrating the ODI Repositories
  • Creating Repository Storage Spaces
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Creating a Wallet to Securely Store Credentials
  • Managing ODI Agents
  • Creating a Physical Agent
  • Launching a Listener, Scheduler and Web Agent
ODI Topology Concepts
  • Overview of ODI Topology
  • About Data Servers and Physical Schemas
  • Defining the Physical Architecture
  • Defining the Logical Architecture
  • Mapping Logical and Physical Resources
  • Defining Agents
  • Defining a Topology
  • Planning the Topology
Describing the Physical and Logical Architecture
  • Overview of Topology Navigator
  • 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
Setting Up a New ODI Project
  • Overview of ODI Projects
  • Creating a New Project
  • Creating and Maintaining Folders
  • Organizing Projects and Folders
  • Understanding Knowledge Modules
  • Exchanging ODI Objects and Sharing Global Objects
  • Exporting and Importing Objects
  • Creating and Labeling with Markers
Oracle Data Integrator Model Concepts
  • What is a Model?
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Configuring Constraints in ODI
  • Creating Keys and References
Organizing ODI Models and Creating Data stores
  • What is a Mapping?
  • Business Rules for Mappings
  • Creating a Basic Mapping
  • What is a Join?
  • What is a Filter?
  • What is a Constraint?
  • What is a Staging Area?
ODI Mapping Concepts
  • What is a Mapping?
  • Business Rules for Mapping
  • What is a Mapping, a Filter, a Join?
  • Overview of Integration Process
  • What is a Staging Area?
  • Execution Location
  • Mapping with Knowledge Modules (KM)
  • Creating an Intermediate Mapping
Designing Mappings
  • Designing a Mapping
  • Multiple Source Data stores
  • Creating Joins
  • Filtering Data
  • Disabling Transformations
  • Overview of the Flow
  • Specifying the Staging Area
  • Selecting Knowledge Modules
Mapping: Monitoring and Debugging
  • Monitoring Mappings
  • Creating Objects with Operator
  • Viewing Sessions and Tasks
  • How to Monitor Execution of a Mapping
  • How to Troubleshoot a Session
  • Keys to Reviewing the Generated Code
  • Working with Errors
  • Tips for Preventing Errors
Designing Mappings: Advanced Topics 1
  • Mapping with Business Rules
  • Overview of Business Rule Elements
  • Creating and Tracking Variables
  • Creating User Functions
  • Mapping Substitution Methods
  • Modifying a KM
  • Showing Variable Values in Log
  • Customizing Reverse Engineering Using RKM
Designing Mappings: Advanced Topics 2
  • Using Partitioning in a Mapping
  • Reusable Mappings
  • Derived Select (Subselect) for Reusable Mappings
  • Using User Functions
  • Creating a User Function
  • Using Substitution Methods
  • Developing Your Own Knowledge Module
Creating and Running ODI procedures
  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Viewing Results with Operator
Using ODI 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
Step-by-Step Debugger
  • Starting a Session in Debug mode
  • Specifying Debug Properties
  • Control Execution Flow
  • Screen Step Numbering
Managing ODI Scenarios and Versions
  • What is a Scenario?
  • Managing Scenarios with Load Plans
  • Preparing Scenarios for Deployment
  • Automating Scenario Management
  • Scheduling the ODI Scenario
  • Overview of ODI version management
  • Handling concurrent changes
Using Load Plans
  • What Are Load Plans?
  • Load Plan Editor
  • Load Plan Steps
  • Defining the Restart Behavior
  • Benefits of Using Load Plans
  • Handling Failed Load Plans
Enforcing Data Quality and Auditing Data with ODI
  • 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
Working with Changed Data Capture
  • Overview of ODI version management
  • Techniques of Changed Data Capture
  • Changed Data Capture in ODI
  • CDC Strategies and Infrastructure
  • CDC Consistency
  • Creating Change Data Capture (CDC)
  • Viewing Data/Changed data
  • Journalizing
Advanced ODI Administration
  • Introduction to ODI Security Navigator
  • Security Concepts: Overview, Defining Security Policies
  • Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User
  • Defining Password Policies, Implementing External Authentication
  • Generating Topology Reports
  • Integration of ODI with Enterprise Manager
  • Java EE Agent and Enterprise Manager Configuration with WebLogic Domain
  • Using ODI Console
Integrating ODI with Subversion
  • ODI: VCS Integration
  • ODI: Selecting the Required VCS
  • SVN Connections
  • Configuring the Subversion Repository with ODI
  • Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN
  • Creating a New Version for an Object
  • Creating Full or Partial Tags in the Subversion Repository
  • Performing a Branch Merge
Integrating Big Data with ODI
  • Big Data Concepts
  • Emergence of Apache Hadoop
  • Hadoop Ecosystem
  • Apache HBase, Apache Hive, Apache Pig
  • Apache Spark, Apache Sqoop, Apache Oozie
  • Hadoop Data Integration: Overview
  • Big Data Knowledge Modules Matrix
  • ODI: Hadoop Integration Process