Oracle GoldenGate 12c: Integrate Big Data

Suggested Prerequisite

• Students should be familiar with the Oracle GoldenGate 12c product
• While not required, a generic knowledge of SQL would help.

Required Prerequisite

• Oracle GoldenGate 12c: Fundamentals for Oracle

Audience

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

Course Topics

1. Oracle GoldenGate for Big Data 12c: Product Overview

• Oracle GoldenGate Adapter Architecture – the Overall Framework
• Configuring Message Capture
• Message Parsing
• Java Adapter and Oracle GoldenGate for Big Data: Compare and Contrast
• Oracle GoldenGate for Big Data
• Oracle GoldenGate Java Adapter: Message Capture and Delivery
• Java Handlers
• Configuring Message Delivery

2. Configuring and Using the Hadoop HDFS Handler

• HDFS Handler Supported Formats
• Relevant HDFS Handler Configuration Parameters
• HDFS Partitioning
• HDFS Handler Performance Considerations
• HDFS Handler Best Practices
• HDFS Metadata Change Events
• HFDS Overview
• Hadoop Sequence Files

3. Configuring and Using the Hadoop HBase Handler

• HBase Handler Best Practices
• Relevant HBase Handler Configuration Parameters
• HBase Column Family
• HBase Metadata Change Events
• HBase Row Key
• HBase Handler Functionality
• HBase Overview

4. Configuring and Using the Apache Flume Handler

• Metadata Change Events
• Mapping Transactions to Transactional Flume Events
• Relevant Flume Handler Configuration Parameters
• Flume Overview
• Flume Handler Schema Propagation
• Mapping Operations to Flume Events
• Mapping Transactions to Operational Flume Events
• Flume Handler Setup

5. Configuring and Using the Apache Kafka Handler

• Kafka Handler Advanced Configuration
• Kafka Handler Best Practices
• Kafka Handler Schema Propagation
• Relevant Kafka Handler Configuration Parameters
• Kafka Core APIs
• Kafka Producer Configuration File
• Kafka Handler Setup
• Kafka Overview

6. Configuring and Using the Cassandra Handler

• Cassandra Handler: Supported Data Types
• Cassandra Overview
• ACID Properties Versus Eventual Consistency
• Cassandra Handler Operation Processing
• Cassandra Handler Best Practices
• Relevant Cassandra Handler Configuration Parameters
• Cassandra Primary Keys
• Schema, Table, and Column Mapping

7. Configuring and Using the MongoDB Handler

• Relevant MongoDB Handler Configuration Parameters
• MongoDB Undo Handling
• MongoDB Java Driver
• MongoDB-Specific Considerations: Document Key Column
• MongoDB Bulk Write
• MongoDB Overview
• MongoDB-Supported Data Types

8. Configuring and Using the Generic JDBC Handler

• JDBC Handler Single Operation Mode
• JDBC Handler: Overview
• JDBC Handler–Supported Targets
• Relevant JDBC Handler Configuration Parameters
• JDBC Handler Error Handling

9. Configuring and Using Pluggable Formatters and the Metadata Provider

• Row Formatters
• Operation Formatters
• Metadata Provider Types
• Pluggable Formatters: Overview
• Metadata Provider: Overview
• Metadata Provider Configuration
• Metadata Provider: When Is It Necessary?
• Formatter Configuration