Table of Contents
- Title and Copyright Information
- Preface
-
1
Overview
-
1.1
Understanding Oracle GoldenGate for
Distributed Applications and Analytics
- 1.1.1 Understanding Oracle GoldenGate for Distributed Applications and Analytics
- 1.2 What’s Supported in Oracle GoldenGate for Distributed Applications and Analytics
- 1.3 Dependency Downloader
-
1.1
Understanding Oracle GoldenGate for
Distributed Applications and Analytics
- 2 Get Started
-
3
Prepare
-
3.1
Preparing for Installation
- 3.1.1 Downloading Oracle GoldenGate for Distributed Applications and Analytics
-
3.1.2
Installation Overview
- 3.1.2.1 Contents of the Installation ZIP File
- 3.1.2.2 Using the Generic Build of Oracle GoldenGate
- 3.1.2.3 Considerations for Using a Custom Build for a GoldenGate for Distributed Applications and Analytics Instance of Oracle GoldenGate
- 3.1.2.4 Installing to a Non-Generic Instance of Oracle GoldenGate
- 3.1.3 Directories and Variables in Microservices Architecture
- 3.1.4 Setting up Environmental Variables
-
3.1
Preparing for Installation
-
4
Install
- 4.1 Setting up Oracle GoldenGate for Distributed Applications and Analytics in a High Availability Environment
- 4.2 Installing Oracle GoldenGate for Distributed Applications and Analytics
- 5 Upgrade
-
6
Configure
-
6.1
Configuring Oracle GoldenGate for Distributed
Applications and Analytics
- 6.1.1 Running with Replicat
- 6.1.2 About Schema Evolution and Metadata Change Events
- 6.1.3 About Configuration Property CDATA[] Wrapping
- 6.1.4 Using Regular Expression Search and Replace
- 6.1.5 Scaling Oracle GoldenGate for Distributed Applications and Analytics Delivery
- 6.1.6 Configuring Cluster High Availability
- 6.1.7 Using Identities in Oracle GoldenGate Credential Store
- 6.2 Logging
- 6.3 Configuring Logging
-
6.1
Configuring Oracle GoldenGate for Distributed
Applications and Analytics
-
7
Quickstarts
- 7.1 QuickStarts: Prerequisites
- 7.2 Realtime Data Ingestion into Snowflake with Oracle GoldenGate for Distributed Applications and Analytics
- 7.3 Realtime Parquet Ingestion into Google Cloud Storage with Oracle GoldenGate for Distributed Applications and Analytics
- 7.4 Realtime Parquet Ingestion into AWS S3 buckets with Oracle GoldenGate for Distributed Applications and Analytics
- 7.5 Realtime Parquet Ingestion into Azure Data Lake Storage with Oracle GoldenGate for Distributed Applications and Analytics
- 7.6 Realtime Parquet Ingestion into OCI Object Storage with Oracle GoldenGate for Distributed Applications and Analytics
- 7.7 Realtime Message Ingestion to OCI Streaming with Oracle GoldenGate for Distributed Applications and Analytics
- 7.8 Realtime Message Ingestion to Azure Event Hubs with Oracle GoldenGate for Distributed Applications and Analytics
- 7.9 Realtime Data Ingestion into GCP BigQuery with Oracle GoldenGate for Distributed Applications and Analytics
- 7.10 Realtime Message Ingestion to Google Pub/Sub with Oracle GoldenGate for Distributed Applications and Analytics
- 7.11 Realtime Message Ingestion to Apache Kafka with Oracle GoldenGate for Distributed Applications and Analytics
-
8
Replicate Data
-
8.1
Source
- 8.1.1 Add Extract
- 8.1.2 Amazon MSK
-
8.1.3
Apache Cassandra
- 8.1.3.1 Overview
- 8.1.3.2 Setting Up Cassandra Extract Change Data Capture
- 8.1.3.3 Deduplication
- 8.1.3.4 Topology Changes
- 8.1.3.5 Data Availability in the CDC Logs
- 8.1.3.6 Using Initial Load Extract
- 8.1.3.7 Using Change Data Capture Extract
- 8.1.3.8 Replicating to RDMBS Targets
- 8.1.3.9 Partition Update or Insert of Static Columns
- 8.1.3.10 Partition Delete
- 8.1.3.11 Security and Authentication
- 8.1.3.12 Cleanup of CDC Commit Log Files
- 8.1.3.13 Multiple Extract Support
- 8.1.3.14 CDC Configuration Reference
- 8.1.3.15 Troubleshooting
- 8.1.3.16 Cassandra Capture Client Dependencies
-
8.1.4
Apache Kafka
- 8.1.4.1 Overview
- 8.1.4.2 Prerequisites
-
8.1.4.3
General Terms and Functionality of Kafka
Capture
- 8.1.4.3.1 Kafka Streams
- 8.1.4.3.2 Kafka Message Order
- 8.1.4.3.3 Kafka Message Timestamps
- 8.1.4.3.4 Kafka Message Coordinates
- 8.1.4.3.5 Start Extract Modes
- 8.1.4.3.6 General Configuration Overview
- 8.1.4.3.7 OGGSOURCE parameter
- 8.1.4.3.8 The Extract Parameter File
- 8.1.4.3.9 Kafka Consumer Properties File
- 8.1.4.4 Generic Mutation Builder
- 8.1.4.5 Kafka Connect Mutation Builder
- 8.1.4.6 Example Configuration Files
- 8.1.5 Azure Event Hubs
- 8.1.6 Confluent Kafka
- 8.1.7 DataStax
- 8.1.8 Java Message Service (JMS)
-
8.1.9
MongoDB
- 8.1.9.1 Overview
- 8.1.9.2 Prerequisites to Setting up MongoDB
- 8.1.9.3 MongoDB Database Operations
- 8.1.9.4 Using Extract Initial Load
- 8.1.9.5 Using Change Data Capture Extract
- 8.1.9.6 Positioning the Extract
- 8.1.9.7 Security and Authentication
- 8.1.9.8 MongoDB Bidirectional Replication
- 8.1.9.9 Mongo DB Configuration Reference
- 8.1.9.10 Columns in Trail File
- 8.1.9.11 Update Operation Behavior
- 8.1.9.12 Oplog Size Recommendations
- 8.1.9.13 Troubleshooting
- 8.1.9.14 MongoDB Capture Client Dependencies
- 8.1.10 OCI Streaming
-
8.2
Target
- 8.2.1 Add Replicat
-
8.2.2
Amazon Kinesis
- 8.2.2.1 Overview
- 8.2.2.2 Detailed Functionality
-
8.2.2.3
Setting Up and Running the Kinesis Streams Handler
- 8.2.2.3.1 Set the Classpath in Kinesis Streams Handler
- 8.2.2.3.2 Kinesis Streams Handler Configuration
- 8.2.2.3.3 Using Templates to Resolve the Stream Name and Partition Name
- 8.2.2.3.4 Resolving AWS Credentials
- 8.2.2.3.5 Configuring the Proxy Server for Kinesis Streams Handler
- 8.2.2.3.6 Configuring Security in Kinesis Streams Handler
- 8.2.2.4 Kinesis Handler Performance Considerations
- 8.2.2.5 Troubleshooting
- 8.2.3 Amazon MSK
-
8.2.4
Amazon Redshift
- 8.2.4.1 Detailed Functionality
- 8.2.4.2 Operation Aggregation
- 8.2.4.3 Unsupported Operations and Limitations
- 8.2.4.4 Uncompressed UPDATE records
- 8.2.4.5 Error During the Data Load Proces
- 8.2.4.6 Troubleshooting and Diagnostics
- 8.2.4.7 Classpath
- 8.2.4.8 Configuration
- 8.2.4.9 INSERTALLRECORDS Support
- 8.2.4.10 Redshift COPY SQL Authorization
- 8.2.4.11 Co-ordinated Apply Support
- 8.2.5 Amazon S3
-
8.2.6
Apache Cassandra
- 8.2.6.1 Overview
- 8.2.6.2 Detailing the Functionality
- 8.2.6.3 Setting Up and Running the Cassandra Handler
- 8.2.6.4 About Automated DDL Handling
- 8.2.6.5 Performance Considerations
- 8.2.6.6 Additional Considerations
- 8.2.6.7 Troubleshooting
- 8.2.6.8 Cassandra Handler Client Dependencies
- 8.2.7 Apache HBase
-
8.2.8
Apache HDFS
- 8.2.8.1 Overview
- 8.2.8.2 Writing into HDFS in SequenceFile Format
- 8.2.8.3 Setting Up and Running the HDFS Handler
- 8.2.8.4 Writing in HDFS in Avro Object Container File Format
- 8.2.8.5 Generating HDFS File Names Using Template Strings
- 8.2.8.6 Metadata Change Events
- 8.2.8.7 Partitioning
- 8.2.8.8 HDFS Additional Considerations
- 8.2.8.9 Best Practices
- 8.2.8.10 Troubleshooting the HDFS Handler
- 8.2.8.11 HDFS Handler Client Dependencies
-
8.2.9
Apache Kafka
-
8.2.9.1
Apache Kafka
- 8.2.9.1.1 Overview
- 8.2.9.1.2 Detailed Functionality
-
8.2.9.1.3
Setting Up and Running the Kafka Handler
- 8.2.9.1.3.1 Classpath Configuration
- 8.2.9.1.3.2 Kafka Handler Configuration
- 8.2.9.1.3.3 Java Adapter Properties File
- 8.2.9.1.3.4 Kafka Producer Configuration File
- 8.2.9.1.3.5 Using Templates to Resolve the Topic Name and Message Key
- 8.2.9.1.3.6 Kafka Configuring with Kerberos on a Hadoop Platform
- 8.2.9.1.3.7 Kafka SSL Support
- 8.2.9.1.4 Schema Propagation
- 8.2.9.1.5 Performance Considerations
- 8.2.9.1.6 About Security
- 8.2.9.1.7 Metadata Change Events
- 8.2.9.1.8 Snappy Considerations
- 8.2.9.1.9 Kafka Interceptor Support
- 8.2.9.1.10 Kafka Partition Selection
- 8.2.9.1.11 Troubleshooting
- 8.2.9.1.12 Kafka Handler Client Dependencies
-
8.2.9.2
Apache Kafka Connect Handler
- 8.2.9.2.1 Overview
- 8.2.9.2.2 Detailed Functionality
- 8.2.9.2.3 Setting Up and Running the Kafka Connect Handler
- 8.2.9.2.4 Connecting to a Secure Schema Registry
- 8.2.9.2.5 Kafka Connect Handler Performance Considerations
- 8.2.9.2.6 Kafka Interceptor Support
- 8.2.9.2.7 Kafka Partition Selection
- 8.2.9.2.8 Troubleshooting the Kafka Connect Handler
-
8.2.9.2.9
Kafka Connect Handler Client Dependencies
- 8.2.9.2.9.1 Kafka 2.8.0
- 8.2.9.2.9.2 Kafka 2.7.1
- 8.2.9.2.9.3 Kafka 2.6.0
- 8.2.9.2.9.4 Kafka 2.5.1
- 8.2.9.2.9.5 Kafka 2.4.1
- 8.2.9.2.9.6 Kafka 2.3.1
- 8.2.9.2.9.7 Kafka 2.2.1
- 8.2.9.2.9.8 Kafka 2.1.1
- 8.2.9.2.9.9 Kafka 2.0.1
- 8.2.9.2.9.10 Kafka 1.1.1
- 8.2.9.2.9.11 Kafka 1.0.2
- 8.2.9.2.9.12 Kafka 0.11.0.0
- 8.2.9.2.9.13 Kafka 0.10.2.0
- 8.2.9.2.9.14 Kafka 0.10.2.0
- 8.2.9.2.9.15 Kafka 0.10.0.0
- 8.2.9.2.9.16 Kafka 0.9.0.1
-
8.2.9.3
Apache Kafka REST Proxy
- 8.2.9.3.1 Overview
-
8.2.9.3.2
Setting Up and Starting the Kafka REST Proxy Handler Services
- 8.2.9.3.2.1 Using the Kafka REST Proxy Handler
- 8.2.9.3.2.2 Downloading the Dependencies
- 8.2.9.3.2.3 Classpath Configuration
- 8.2.9.3.2.4 Kafka REST Proxy Handler Configuration
- 8.2.9.3.2.5 Review a Sample Configuration
- 8.2.9.3.2.6 Security
- 8.2.9.3.2.7 Generating a Keystore or Truststore
- 8.2.9.3.2.8 Using Templates to Resolve the Topic Name and Message Key
- 8.2.9.3.2.9 Kafka REST Proxy Handler Formatter Properties
- 8.2.9.3.3 Consuming the Records
- 8.2.9.3.4 Performance Considerations
- 8.2.9.3.5 Kafka REST Proxy Handler Metacolumns Template Property
-
8.2.9.1
Apache Kafka
- 8.2.10 Apache Hive
- 8.2.11 Azure Blob Storage
- 8.2.12 Azure Data Lake Storage
- 8.2.13 Azure Event Hubs
-
8.2.14
Azure Synapse Analytics Data
Warehouse
- 8.2.14.1 Detailed Functionality
- 8.2.14.2 Operation Aggregation
- 8.2.14.3 Compressed Update Handling
- 8.2.14.4 Configuration
- 8.2.14.5 Troubleshooting and Diagnostics
- 8.2.15 Confluent Kafka
-
8.2.16
Databricks
- 8.2.16.1 Detailed Functionality
-
8.2.16.2
Configuration
- 8.2.16.2.1 Automatic Configuration
- 8.2.16.2.2 Authentication to Databricks
- 8.2.16.2.3 Unity Catalog
- 8.2.16.2.4 Create an External Location
- 8.2.16.2.5 Compute Clusters Without Unity Catalog
- 8.2.16.2.6 Classpath Configuration
- 8.2.16.2.7 Proxy Configuration
- 8.2.16.2.8 Operation Aggregation
- 8.2.16.2.9 Compressed Update Handling
- 8.2.16.2.10 End-to-End Configuration
- 8.2.16.2.11 Table Mapping
- 8.2.16.3 Troubleshooting and Diagnostics
- 8.2.17 DataStax
-
8.2.18
Elasticsearch
-
8.2.18.1
Elasticsearch with Elasticsearch 7x and
6x
- 8.2.18.1.1 Overview
-
8.2.18.1.2
Detailing the Functionality
- 8.2.18.1.2.1 About the Elasticsearch Version Property
- 8.2.18.1.2.2 About the Index and Type
- 8.2.18.1.2.3 About the Document
- 8.2.18.1.2.4 About the Primary Key Update
- 8.2.18.1.2.5 About the Data Types
- 8.2.18.1.2.6 Operation Mode
- 8.2.18.1.2.7 Operation Processing Support
- 8.2.18.1.2.8 About the Connection
- 8.2.18.1.3 Setting Up and Running the Elasticsearch Handler
- 8.2.18.1.4 Troubleshooting
- 8.2.18.1.5 Performance Consideration
- 8.2.18.1.6 About the Shield Plug-In Support
- 8.2.18.1.7 About DDL Handling
- 8.2.18.1.8 Known Issues in the Elasticsearch Handler
- 8.2.18.1.9 Elasticsearch Handler Transport Client Dependencies
- 8.2.18.1.10 Elasticsearch High Level REST Client Dependencies
-
8.2.18.2
Elasticsearch 8x
- 8.2.18.2.1 Overview
- 8.2.18.2.2 Detailing the Functionality
- 8.2.18.2.3 About the Index
- 8.2.18.2.4 About the Document
- 8.2.18.2.5 About the Data Types
- 8.2.18.2.6 About the Connection
- 8.2.18.2.7 About Supported Operation
- 8.2.18.2.8 About DDL Handling
- 8.2.18.2.9 About the Primary Key Update
- 8.2.18.2.10 About UPSERT
- 8.2.18.2.11 About Bulk Write
- 8.2.18.2.12 About Routing
- 8.2.18.2.13 About Request Headers
- 8.2.18.2.14 About Java API Client
- 8.2.18.2.15 Setting Up the Elasticsearch Handler
- 8.2.18.2.16 Elasticsearch Handler Configuration
- 8.2.18.2.17 Enabling Security for Elasticsearch
- 8.2.18.2.18 Security Configuration for Elasticsearch Cluster
- 8.2.18.2.19 Security Configuration for Elasticsearch Handler
- 8.2.18.2.20 Troubleshooting
- 8.2.18.2.21 Elasticsearch Handler Client Dependencies
- 8.2.18.3 Support for Vector Data
-
8.2.18.1
Elasticsearch with Elasticsearch 7x and
6x
-
8.2.19
Flat Files
- 8.2.19.1 File Writer Handler
- 8.2.19.2 Optimized Row Columnar (ORC)
- 8.2.19.3 Parquet
-
8.2.20
Google BigQuery
- 8.2.20.1 Using Streaming API
-
8.2.20.2
Google BigQuery Stage and Merge
- 8.2.20.2.1 Overview
- 8.2.20.2.2 Detailed Functionality
- 8.2.20.2.3 Prerequisites
- 8.2.20.2.4 Differences between BigQuery Handler and Stage and Merge BigQuery Event Handler
- 8.2.20.2.5 Authentication or Authorization
- 8.2.20.2.6 Operation Aggregation
- 8.2.20.2.7 Compressed Update Handling
- 8.2.20.2.8 Configuration
- 8.2.20.2.9 Troubleshooting and Diagnostics
- 8.2.21 Google Cloud Storage
- 8.2.22 Google Pub/Sub
- 8.2.23 Java Message Service (JMS)
- 8.2.24 Java Database Connectivity
-
8.2.25
MongoDB
- 8.2.25.1 Overview
- 8.2.25.2 MongoDB Wire Protocol
- 8.2.25.3 Supported Target Types
- 8.2.25.4 Detailed Functionality
- 8.2.25.5 Setting Up and Running the MongoDB Handler
- 8.2.25.6 Security and Authentication
- 8.2.25.7 Reviewing Sample Configurations
- 8.2.25.8 MongoDB to AJD/ATP Migration
- 8.2.25.9 MongoDB Handler Client Dependencies
- 8.2.26 Netezza
- 8.2.27 OCI Streaming
-
8.2.28
Oracle NoSQL
- 8.2.28.1 Overview
- 8.2.28.2 On-Premise Connectivity
- 8.2.28.3 OCI Cloud Connectivity
- 8.2.28.4 Oracle NoSQL Types
- 8.2.28.5 Oracle NoSQL Handler Configuration
- 8.2.28.6 Performance Considerations
- 8.2.28.7 Operation Processing Support
- 8.2.28.8 Column Processing
- 8.2.28.9 Table Check and Reconciliation Process
- 8.2.28.10 Oracle NoSQL SDK Dependencies
-
8.2.29
OCI Autonomous Data Warehouse
- 8.2.29.1 Detailed Functionality
- 8.2.29.2 ADW Database Credential to Access OCI ObjectStore File
- 8.2.29.3 ADW Database User Privileges
- 8.2.29.4 Unsupported Operations/ Limitations
- 8.2.29.5 Troubleshooting and Diagnostics
- 8.2.29.6 Classpath
- 8.2.29.7 Configuration
- 8.2.30 Oracle Cloud Infrastructure Object Storage
- 8.2.31 Redis
-
8.2.32
Snowflake
-
8.2.32.1
Snowflake Stage and Merge Handler
- 8.2.32.1.1 Overview
- 8.2.32.1.2 Detailed Functionality
-
8.2.32.1.3
Configuration
- 8.2.32.1.3.1 Automatic Configuration
- 8.2.32.1.3.2 Snowflake Storage Integration
- 8.2.32.1.3.3 Classpath Configuration
- 8.2.32.1.3.4 Proxy Configuration
- 8.2.32.1.3.5 INSERTALLRECORDS Support
- 8.2.32.1.3.6 Snowflake Key Pair Authentication
- 8.2.32.1.3.7 Mapping Source JSON/XML to Snowflake VARIANT
- 8.2.32.1.3.8 Operation Aggregation
- 8.2.32.1.3.9 Compressed Update Handling
- 8.2.32.1.3.10 End-to-End Configuration
- 8.2.32.1.3.11 Table Mapping
- 8.2.32.1.4 Troubleshooting and Diagnostics
- 8.2.32.2 Snowflake Streaming Handler
-
8.2.32.1
Snowflake Stage and Merge Handler
-
8.2.33
Additional Details
- 8.2.33.1 Command Event Handler
- 8.2.33.2 HDFS Event Handler
- 8.2.33.3 Metacolumn Keywords
-
8.2.33.4
Metadata Providers
- 8.2.33.4.1 About the Metadata Providers
- 8.2.33.4.2 Avro Metadata Provider
- 8.2.33.4.3 Java Database Connectivity Metadata Provider
-
8.2.33.4.4
Hive Metadata Provider
- 8.2.33.4.4.1 Detailed Functionality
- 8.2.33.4.4.2 Configuring Hive with a Remote Metastore Database
- 8.2.33.4.4.3 Classpath Configuration
- 8.2.33.4.4.4 Hive Metadata Provider Configuration Properties
- 8.2.33.4.4.5 Review a Sample Configuration
- 8.2.33.4.4.6 Security
- 8.2.33.4.4.7 Metadata Change Event
- 8.2.33.4.4.8 Limitations
- 8.2.33.4.4.9 Additional Considerations
- 8.2.33.4.4.10 Troubleshooting
-
8.2.33.4.5
Google BigQuery Metadata Provider
- 8.2.33.4.5.1 Authentication
- 8.2.33.4.5.2 Supported BigQuery Datatypes
- 8.2.33.4.5.3 Parameterized BigQuery Datatypes
- 8.2.33.4.5.4 Unsupported BigQuery Datatypes
- 8.2.33.4.5.5 Configuring BigQuery Metadata Provider
- 8.2.33.4.5.6 Sample Configuration
- 8.2.33.4.5.7 Proxy Settings
- 8.2.33.4.5.8 Classpath Settings
- 8.2.33.4.5.9 Limitations
-
8.2.33.5
Pluggable Formatters
- 8.2.33.5.1 Using Operation-Based versus Row-Based Formatting
- 8.2.33.5.2 Using the Avro Formatter
- 8.2.33.5.3 Existing Avro Formatter
- 8.2.33.5.4 Using the Delimited Text Formatter
-
8.2.33.5.5
Using the JSON Formatter
- 8.2.33.5.5.1 Operation Metadata Formatting Details
- 8.2.33.5.5.2 Operation Data Formatting Details
- 8.2.33.5.5.3 Row Data Formatting Details
- 8.2.33.5.5.4 Sample JSON Messages
- 8.2.33.5.5.5 JSON Schemas
- 8.2.33.5.5.6 JSON Formatter Configuration Properties
- 8.2.33.5.5.7 Review a Sample Configuration
- 8.2.33.5.5.8 Metadata Change Events
- 8.2.33.5.5.9 JSON Primary Key Updates
- 8.2.33.5.5.10 Integrating Oracle Stream Analytics
- 8.2.33.5.6 Using the Length Delimited Value Formatter
- 8.2.33.5.7 Using the XML Formatter
-
8.2.33.6
Stage and Merge Data Warehouse
Replication
-
8.2.33.6.1
Steps for Stage and Merge
- 8.2.33.6.1.1 Stage
- 8.2.33.6.1.2 Merge
- 8.2.33.6.1.3 Configuration of Handlers
- 8.2.33.6.1.4 File Writer Handler
- 8.2.33.6.1.5 Operation Aggregation
- 8.2.33.6.1.6 Object Store Event handler
- 8.2.33.6.1.7 JDBC Metadata Provider
- 8.2.33.6.1.8 Command Event handler Merge Script
- 8.2.33.6.1.9 Stage and Merge Sample Configuration
- 8.2.33.6.1.10 Variables in the Merge Script
- 8.2.33.6.1.11 SQL Statements in the Merge Script
- 8.2.33.6.1.12 Merge Script Functions
- 8.2.33.6.1.13 Prerequisites
- 8.2.33.6.1.14 Limitations
- 8.2.33.6.2 Hive Stage and Merge
-
8.2.33.6.1
Steps for Stage and Merge
- 8.2.33.7 Template Keywords
- 8.2.33.8 Velocity Dependencies
-
8.1
Source
-
9
Administer
- 9.1 Automatic Heartbeat for Oracle GoldenGate for Distributed Applications and Analytics
-
9.2
Parsing the Message
- 9.2.1 Parsing Overview
- 9.2.2 Fixed Width Parsing
- 9.2.3 Delimited Parsing
- 9.2.4 XML Parsing
- 9.2.5 Source Definitions Generation Utility
-
9.3
Message Capture Properties
- 9.3.1 Logging and Connection Properties
-
9.3.2
Parser Properties
- 9.3.2.1 Setting the Type of Parser
-
9.3.2.2
Fixed Parser Properties
- 9.3.2.2.1 fixed.schematype
- 9.3.2.2.2 fixed.sourcedefs
- 9.3.2.2.3 fixed.copybook
- 9.3.2.2.4 fixed.header
- 9.3.2.2.5 fixed.seqid
- 9.3.2.2.6 fixed.timestamp
- 9.3.2.2.7 fixed.timestamp.format
- 9.3.2.2.8 fixed.txid
- 9.3.2.2.9 fixed.txowner
- 9.3.2.2.10 fixed.txname
- 9.3.2.2.11 fixed.optype
- 9.3.2.2.12 fixed.optype.insertval
- 9.3.2.2.13 fixed.optype.updateval
- 9.3.2.2.14 fixed.optype.deleteval
- 9.3.2.2.15 fixed.table
- 9.3.2.2.16 fixed.schema
- 9.3.2.2.17 fixed.txind
- 9.3.2.2.18 fixed.txind.beginval
- 9.3.2.2.19 fixed.txind.middleval
- 9.3.2.2.20 fixed.txind.endval
- 9.3.2.2.21 fixed.txind.wholeval
-
9.3.2.3
Delimited Parser Properties
- 9.3.2.3.1 delim.sourcedefs
- 9.3.2.3.2 delim.header
- 9.3.2.3.3 delim.seqid
- 9.3.2.3.4 delim.timestamp
- 9.3.2.3.5 delim.timestamp.format
- 9.3.2.3.6 delim.txid
- 9.3.2.3.7 delim.txowner
- 9.3.2.3.8 delim.txname
- 9.3.2.3.9 delim.optype
- 9.3.2.3.10 delim.optype.insertval
- 9.3.2.3.11 delim.optype.updateval
- 9.3.2.3.12 delim.optype.deleteval
- 9.3.2.3.13 delim.schemaandtable
- 9.3.2.3.14 delim.schema
- 9.3.2.3.15 delim.table
- 9.3.2.3.16 delim.txind
- 9.3.2.3.17 delim.txind.beginval
- 9.3.2.3.18 delim.txind.middleval
- 9.3.2.3.19 delim.txind.endval
- 9.3.2.3.20 delim.txind.wholeval
- 9.3.2.3.21 delim.fielddelim
- 9.3.2.3.22 delim.linedelim
- 9.3.2.3.23 delim.quote
- 9.3.2.3.24 delim.nullindicator
- 9.3.2.3.25 delim.fielddelim.escaped
- 9.3.2.3.26 delim.linedelim.escaped
- 9.3.2.3.27 delim.quote.escaped
- 9.3.2.3.28 delim.nullindicator.escaped
- 9.3.2.3.29 delim.hasbefores
- 9.3.2.3.30 delim.hasnames
- 9.3.2.3.31 delim.afterfirst
- 9.3.2.3.32 delim.isgrouped
- 9.3.2.3.33 delim.dateformat | delim.dateformat.table | delim.dateform.table.column
-
9.3.2.4
XML Parser Properties
- 9.3.2.4.1 xml.sourcedefs
- 9.3.2.4.2 xml.rules
- 9.3.2.4.3 rulename.type
- 9.3.2.4.4 rulename.match
- 9.3.2.4.5 rulename.subrules
- 9.3.2.4.6 txrule.timestamp
- 9.3.2.4.7 txrule.timestamp.format
- 9.3.2.4.8 txrule.seqid
- 9.3.2.4.9 txrule.txid
- 9.3.2.4.10 txrule.txowner
- 9.3.2.4.11 txrule.txname
- 9.3.2.4.12 oprule.timestamp
- 9.3.2.4.13 oprule.timestamp.format
- 9.3.2.4.14 oprule.seqid
- 9.3.2.4.15 oprule.txid
- 9.3.2.4.16 oprule.txowner
- 9.3.2.4.17 oprule.txname
- 9.3.2.4.18 oprule.schemandtable
- 9.3.2.4.19 oprule.schema
- 9.3.2.4.20 oprule.table
- 9.3.2.4.21 oprule.optype
- 9.3.2.4.22 oprule.optype.insertval
- 9.3.2.4.23 oprule.optype.updateval
- 9.3.2.4.24 oprule.optype.deleteval
- 9.3.2.4.25 oprule.txind
- 9.3.2.4.26 oprule.txind.beginval
- 9.3.2.4.27 oprule.txind.middleval
- 9.3.2.4.28 oprule.txind.endval
- 9.3.2.4.29 oprule.txind.wholeval
- 9.3.2.4.30 colrule.name
- 9.3.2.4.31 colrule.index
- 9.3.2.4.32 colrule.value
- 9.3.2.4.33 colrule.isnull
- 9.3.2.4.34 colrule.ismissing
- 9.3.2.4.35 colrule.before.value
- 9.3.2.4.36 colrule.before.isnull
- 9.3.2.4.37 colrule.before.ismissing
- 9.3.2.4.38 colrule.after.value
- 9.3.2.4.39 colrule.after.isnull
- 9.3.2.4.40 colrule.after.ismissing
-
9.4
Oracle GoldenGate Java Delivery
- 9.4.1 Configuring Java Delivery
- 9.4.2 Running Java Delivery
- 9.4.3 Configuring Event Handlers
-
9.4.4
Java Delivery Properties
- 9.4.4.1 Common Properties
- 9.4.4.2 Delivery Properties
-
9.4.4.3
Java Application Properties
- 9.4.4.3.1 Properties for All Handlers
- 9.4.4.3.2 Properties for Formatted Output
-
9.4.4.3.3
Properties for CSV and Fixed Format Output
- 9.4.4.3.3.1 gg.handler.name.format.delim
- 9.4.4.3.3.2 gg.handler.name.format.quote
- 9.4.4.3.3.3 gg.handler.name.format.metacols
- 9.4.4.3.3.4 gg.handler.name.format.missingColumnChar
- 9.4.4.3.3.5 gg.handler.name.format.presentColumnChar
- 9.4.4.3.3.6 gg.handler.name.format.nullColumnChar
- 9.4.4.3.3.7 gg.handler.name.format.beginTxChar
- 9.4.4.3.3.8 gg.handler.name.format.middleTxChar
- 9.4.4.3.3.9 gg.handler.name.format.endTxChar
- 9.4.4.3.3.10 gg.handler.name.format.wholeTxChar
- 9.4.4.3.3.11 gg.handler.name.format.insertChar
- 9.4.4.3.3.12 gg.handler.name.format.updateChar
- 9.4.4.3.3.13 gg.handler.name.format.deleteChar
- 9.4.4.3.3.14 gg.handler.name.format.truncateChar
- 9.4.4.3.3.15 gg.handler.name.format.endOfLine
- 9.4.4.3.3.16 gg.handler.name.format.justify
- 9.4.4.3.3.17 gg.handler.name.format.includeBefores
- 9.4.4.3.4 File Writer Properties
- 9.4.4.3.5 JMS Handler Properties
- 9.4.4.3.6 JNDI Properties
- 9.4.4.3.7 General Properties
- 9.4.4.3.8 Java Delivery Transaction Grouping
- 9.4.5 Developing Custom Filters, Formatters, and Handlers
- 10 Troubleshoot