Oracle GoldenGate Hub: Comprehensive Training & Hands-on Lab

Name: Oracle GoldenGate Hub: Comprehensive Training & Hands-on Lab
Rating: 3.9 (12 reviews)

Mastering Real-Time Data Integration and Replication with Oracle GoldenGate Hub

Created byCu Dinh Tien, Quan Pham, Phuong Nguyen, Dien Pham, Educonnhub

Last updated 8/2024

English

English [Auto],

What you'll learn

Learn about the real-time data integration capabilities of Oracle GoldenGate.
Gain a thorough understanding of Oracle GoldenGate and its core concepts.
Differentiate between Oracle GoldenGate Classic Architecture and Microservices Architecture.
Explore the architecture of Oracle GoldenGate Hub and its components.
Explore performance optimization, data transformation, and change data capture (CDC) techniques.
Master the setup and configuration of Oracle GoldenGate Microservices Architecture
Explore the architecture of Oracle GoldenGate Hub and its advantages
Learn how to configure GoldenGate Hub for centralized data integration and replication
Discover common use cases for Oracle GoldenGate Hub in enterprise environment
Install and configure Oracle Client Software, GoldenGate Software, and NGINX Reserve Proxy Server.
Source and Target Database Configuration
Gain practical experience in deploying and managing Oracle GoldenGate Hub in real-world scenarios

Course content

4 sections • 16 lectures • 1h 52m total length

Introduction to Oracle GoldenGate Hub3:01
Explore the Oracle GoldenGate Hub architecture and microservices approach, install and configure the hub, validate real-time data movement across cloud, on-premises, or hybrid environments through testing.
Materials0:01

Understanding Oracle GoldenGate Architecture8:54
Master real-time data integration with Oracle GoldenGate, capturing and delivering changes across heterogeneous systems using CDC, trail files, and robust replication topologies for high availability and disaster recovery.
Oracle GoldenGate Microservices Architecture6:47
Explore Oracle GoldenGate microservices architecture, featuring rest enabled services, administration server and service manager, distribution and receiver servers, performance metrics, and admin client for automated deployments.
Comparison: Classic Architecture vs. Microservices Architecture5:59
Explore Oracle GoldenGate classic and microservices architectures, compare deployment, components, configuration, and management approaches, and discuss scalability and resource use to help choosing the right approach.
Oracle GoldenGate Hub Architecture and Configuration12:17
Compare Oracle GoldenGate local and hub configurations, highlighting hub architecture for centralized multi-source data replication, trail file handling, and reduced resource usage with centralized management.
Use Cases of Oracle GoldenGate Hub4:42
Explore how Oracle GoldenGate Hub centralizes data replication with a unified console, enabling multi-source data aggregation, data distribution, transformation, and cross-platform migration across cloud and on premises environments.

Installation and Setup1:28
Install the oracle golden gate hub on linux server, configure source and target pdbs (12c to 19c), install oracle client and goldengate software, and set up jinx reserve proxy server.
Source and Target Database Configuration3:44
Configure source and target databases on separate servers by enabling archive log mode, force logging, and minimal supplemental logging; enable goldengate replication, install utl_spa, and create goldengate user for CDB/PDB.

Practical Lab 1 - Oracle Client Installation8:39
Set up Oracle GoldenGate Hub server by installing Oracle client 12c and 19c, configuring OS user, environment variables, and testing connections with tnsnames.ora and sqlplus.
Practical Lab 2 - Oracle GoldenGate Installation6:58
Install Oracle GoldenGate 19c on the server, configure 12c source and 19c target databases, apply patches to 12.2.0.1.41, and set up nginx as a reverse proxy.
Practical Lab 3 - Configuration Setup9:12
Configure the Oracle GoldenGate hub with a service manager and deployments using the configuration assistant or a silent response file, creating administration and performance metrics servers.
Practical Lab 4 - Configuring Source and Target Databases10:19
This lab guides configuring source and target Oracle databases for GoldenGate replication, enabling archive log mode, force logging, minimal supplemental logging, and creating admin accounts and schemas.
Practical Lab 5 - Preparing for Migration8:40
Prepare for migration by creating Golden Gate credentials and a heartbeat table, enabling trend data on the source, and configuring schemas before creating extracts and replicates.
Practical Lab 6 - Creating Extract and Replicat Processes14:49
Configure extracts and replicates on the Oracle GoldenGate hub to capture changes from the source database and apply them to the target database, with credentials, profiles, and auto start settings.
Practical Lab 7 - Demonstration and Monitoring6:51
Demonstrate end-to-end Oracle GoldenGate hub replication by running extract and replicate, inserting test data, validating source-to-target migration, and monitoring latency with commands.

Requirements

Basic Database Knowledge
Oracle Database Management
Data Integration Concepts
Software and Tools: Oracle Client, GoldenGate Software, and NGINX Reserve Proxy Server

Description

*This course contains the use of artificial intelligence.*

Unlock the power of real-time data integration and replication with our comprehensive course on Oracle GoldenGate Hub. Designed for database administrators, data engineers, IT professionals, and aspiring data experts, this course offers an in-depth exploration of Oracle GoldenGate Hub's capabilities through a combination of theoretical knowledge and practical hands-on labs.

Through a series of structured modules, participants will gain a solid understanding of Oracle GoldenGate Hub's architecture, key features, and use cases. Beginning with an introduction to Oracle GoldenGate Hub, learners will delve into its role as a central hub for orchestrating data replication processes across heterogeneous systems and environments.

Subsequent modules will cover essential topics such as understanding Oracle GoldenGate Architecture, including classic and microservices architectures, and comparing their benefits and scalability. Participants will also explore Oracle GoldenGate Microservices Architecture, learning how to configure and deploy microservices for seamless data integration.

Practical sessions will guide participants through the installation, setup, and configuration of Oracle GoldenGate Hub, as well as the preparation and configuration of source and target databases. Hands-on labs will provide invaluable experience in deploying Oracle GoldenGate Hub in real-world scenarios, including Oracle Client installation, GoldenGate software setup, and creating extract and replicat processes.

By the end of the course, participants will have the skills and knowledge to effectively deploy, manage, and optimize Oracle GoldenGate Hub for real-time data integration and replication. Whether you're looking to enhance your career prospects, optimize data workflows, or stay ahead in the rapidly evolving field of data management, this course offers the comprehensive training and practical skills you need to succeed.

Who this course is for:

Database Administrators (DBAs)
Data Engineers
Data Analysts and Developers
Enterprise Architects

Oracle GoldenGate Hub: Comprehensive Training & Hands-on Lab

What you'll learn

Explore related topics

Course content

Introduction to Oracle GoldenGate Hub2 lectures • 3min

Understanding Oracle GoldenGate Architecture and Microservices5 lectures • 39min

Installation, Setup, and Configuration2 lectures • 5min

Hands-on Labs and Practical Application7 lectures • 1hr 5min

Requirements

Description

Who this course is for: