Oracle GoldenGate 11g: Fundamentals for SQL Server NEW

The Oracle GoldenGate 11g Fundamentals for SQL Server course provides presentations and hands-on practice of the commands, parameters, functions and features for installing and configuring Oracle GoldenGate for SQL Server to SQL Server replication on a Windows platform. The labs assume Oracle GoldenGate software version 11.2.1.0.1 running on Windows Server 2008.Students use Oracle GoldenGate utilities to run, manage, and troubleshoot Oracle GoldenGate instances.

This course is only offered as a private class at a customer site on customer equipment.

Learn to:

• Prepare the environment and install Oracle GoldenGate
• Issue GGSCI commands to add, start, monitor, stop, and delete processes
• Configure Extract (Change Capture), Replicat (Change Delivery), and Initial Load
• Manage Extract trails and files using logdump
• Create parameter files
• Manage and troubleshoot Oracle GoldenGate instances

This course is based on Oracle Golden Gate version 11.1.1.

Audience

• Data Warehouse Administrator
• Data Warehouse Analyst
• Data Warehouse Developer
• Database Administrators
• Database Designers
• System Administrator
• System Integrator
• Technical Consultant

Course Topics Introducing Oracle GoldenGate 11gR2

• Oracle GoldenGate features
• Oracle GoldenGate evolution
• Transactional Data Management
• Oracle GoldenGate solutions
• Oracle Middleware for Business Intelligence
• High Availability & Disaster Tolerance
• Real-Time Data Integration

OGG Technology Overview

• How Oracle GoldenGate Works: Modular Building Blocks
• Oracle GoldenGate Databases and Platforms
• Oracle GoldenGate Product Line

OGG Architecture

• Describing Oracle GoldenGate Process Groups
• Explaining Initial Data Load
• Contrasting Batch and Online Operation
• Explain Oracle GoldenGate checkpointing and Commit Sequence Number (CSN)
• Describing Oracle GoldenGate parameters, and GGS commands

Installing Oracle GoldenGate

• Listing System Requirements
• Installation on Windows
• Environment Variables for Oracle GoldenGate
• GGSCI Help Facility
• GGSCI Commands
• Using Oracle GoldenGate documentation
• Running Oracle GoldenGate from command interface

Configuration Overview and Preparing the Environment

• Reviewing Configuration Overview
• Configuring Manager Process
• Creating Source Definitions
• Preparing the Source Database
• Explain the User Privileges and authentications required for the Extract, Replicat, and Manager processes
• Authentication methods

Configuring Change Capture (Extract)

• Reviewing Extract Overview
• Oracle GoldenGate Tasks
• Adding Extract Group
• Editing Extract Parameters
• Extract Use of Transaction Log Backups
• Adding Trails

Configuring Change Delivery (Replicat)

• Reviewing Replicat Overview
• Configuring Replicat Tasks
• Sample Configuration
• Avoiding Collisions with Initial Load
• Handling Collisions with Initial Load

Extract Trails and Files (logdump)

• Reviewing Extract Trails and Files Overview
• GoldenGate data format
• Alternative trail format
• Using Logdump for Viewing Trails
• Reversing the Trail Sequence

Configuring Initial Load

• Listing Advantages of Oracle GoldenGate Methods
• Listing Database-specific Methods
• Describing Resource Limitations
• File to Replicat
• File to Database Utility
• Configuring Direct Load Methods

Using Oracle GoldenGate Commands and Parameters

• Types of OGG commands
• Use OGG commands and OBEY files
• Running OGG from OS Shell
• Editing Parameter Files
• Contrasting GLOBALS versus Process Parameters
• Parameters for different process types

Filtering and Data Selection

• Filtering and Data Selection
• Mapping Columns Between Different Schemas
• Using Built-in "@" (at) Functions
• Using SQLEXEC to Interact Directly with a Database

Advanced Transformation Concepts

• Configuring and Using Macros
• Configuring and Using User Tokens
• Configuring and Using User Exits
• Handling Identity Types

Configuration Options

• Configuring and Using BATCHSQL
• Configuring and Using Compression
• Configuring and Using Encryption
• Configuring and Using Event Actions

Bidirectional Replication

• Detecting and Avoiding Loops
• Avoiding, Detecting, and Handling Conflicts

Course Objectives

• Use Oracle GoldenGate utilities
• Use Oracle GoldenGate to perform data transformation
• Run and manage Oracle GoldenGate instances
• Configure Oracle GoldenGate for SQL Server to SQL Server replication
• Describe Oracle GoldenGate solutions
• Describe Oracle GoldenGate architecture
• Install Oracle GoldenGate software on Windows