Oracle GoldenGate 11g: Fundamentals for SQL Server NEW

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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
  • Con…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Data Warehouse, Microsoft SQL Server, PL/SQL, Oracle 11G, and Oracle.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.