GoldenGate Online Training in Hyderabad



Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.GoldenGate's complementary product accelerates Oracle's product strategy to manage real-time data integration through a comprehensive data integration platform. This combination is expected to deliver the fastest and most scalable real-time data integration solution for customers.

Course content

  • Introduction
    • Discussing Required versus Suggested Knowledge
    • Listing Course Objectives
    • Discussing Course Non-Objectives (available as other follow-on courses)
  • Technology Overview
    • Creating Oracle GoldenGate Topologies
    • Reviewing Oracle GoldenGate Use Cases
    • Assembling Building Blocks
    • Listing Supported OS
    • Listing Supported Databases
    • Listing the Oracle Goldengate Product Line
    • Describing GUI Management Options
    • Listing Non-Database Sources and Targets
  • Oracle GoldenGate Architecture
    • Describing Oracle GoldenGate Process Groups
    • Explaining change Capture and Delivery (with and without a data pump)
    • Explaining Initial Data Load
    • Contrasting Batch and Online Operation
    • Explaining Oracle GoldenGate Checkpointing
    • Describing Commit Sequence Numbers (CSN)
    • Describing Oracle GoldenGate Files and Directories
  • Installing Oracle GoldenGate
    • Listing System Requirements
    • Performing Installation
    • Configuring Environment Variables
    • Using GGSCI
    • Running Oracle GoldenGate from the OS shell.
  • Configuration Overview and Preparing the Environment
    • Reviewing Configuration Overview
    • Configuring Manager Process
    • Creating Source Definitions
    • Preparing the Source Database
    • Assigning Oracle Database Roles/Privileges Required
  • Configuring Change Capture (Extract)
    • Reviewing Extract Overview
    • Accessing Logs on Oracle ASM
    • Accessing Logs Remotely
    • Configuring Extract Tasks
    • Adding Extract Group
    • Editing Extract Parameters
    • Extracting Use of Archived Transaction Logs
    • Adding Trails
  • Configuring Change Delivery (Replicat)
    • Reviewing Replicat Overview
    • Configuring Replicat Tasks
    • Configuring a Sample Environment
  • Configuring Extract Trails and Files (Data Pump)
    • Reviewing Extract Trails and Files Overview
    • Describing Trail Formats
    • Using Logdump for Viewing Trails
    • Reversing the Trail Sequence
    • Configuring and Using Data Pumps
  • Performing Initial Load
    • Oracle GoldenGate Methods
    • Listing Database-specific Methods
    • Describing Resource Limitations
    • Listing Advantages of Oracle GoldenGate Methods
    • Configuring File Load Methods
    • Configuring Direct Load Methods
    • Handling Collisions with Initial Load
  • Editing Configuration Parameters
    • Editing Parameter Files
    • Contrasting GLOBALS versus Process Parameters
    • Configuring GLOBALS Parameters
    • Configuring Manager Parameters
    • Configuring Extract Parameters
    • Configuring Replicat Parameters
  • 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
  • Additional Transformation Concepts
    • Configuring and Using Macros
    • Configuring and Using User Tokens
    • Configuring and Using User Exits
    • Configuring and Using Oracle Sequences
  • Configuration Options
    • Configuring and Using BATCHSQL
    • Configuring and Using Compression
    • Configuring and Using Encryption
    • Configuring and Using Event Actions
  • Bidirectional Replication
    • Reviewing Bidirectional Considerations
    • Detecting Loops
    • Avoiding Conflicts
    • Configuring and Using Conflict Detection and Resolution
    • Describing Identity Types Issues
  • DDL Replication
    • Reviewing Data Description Language Replication Overview
    • Configuring and Using Options for DDL Replication
    • Configuring and Using String Substitution in DDL


Mail : 

India : +91-8143-111-555

 USA : +1-703-445-4802

 uk : +44-20-3287-2021

 Whats app : +91-8143-110-555

  0 Votes    0 Comments   Share   Add Bookmark

Tags :

Online Training,


Please login or register to comment