9.2 Target

GoldenGate for Distributed Applications and Analytics (GG for DAA) supports the following technologies as source. GG for DAA change data replication is managed by a replicat process.
About Replicat

Replicat is a process that delivers data to a target system. It reads the source trail file, reconstructs the DML or DDL operations, and applies them to the target system.

For the following two common uses cases of GG for DAA, the function of the Replicat process is as follows:
  • Initial Loads: When you set up GG for DAA for initial loads, the Replicat process applies a static data copy to target objects or routes the data to a high-speed bulk-load utility
  • Change Synchronization: When you set up GG for DAA to keep the target system synchronized with the source, the Replicat process applies the source operations to the target objects.
You can configure multiple Replicat processes with one or more Extract processes to increase the throughput. To preserve data integrity, each set of processes handles a different set of objects. To differentiate among Replicat processes, you assign each one a group name.
  • Add Replicat
  • Amazon DocumentDB
  • Amazon Kinesis
    The Kinesis Streams Handler streams data to applications hosted on the Amazon Cloud or in your environment.
  • Amazon MSK
  • Amazon Redshift
    Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. The purpose of the Redshift Event Handler is to apply operations into Redshift tables.
  • Amazon S3
    Learn how to use the S3 Event Handler, which provides the interface to Amazon S3 web services.
  • Apache Cassandra
    The Cassandra Handler provides the interface to Apache Cassandra databases.
  • Apache HBase
    The HBase Handler is used to populate HBase tables from existing Oracle GoldenGate supported sources.
  • Apache HDFS
    The HDFS Handler is designed to stream change capture data into the Hadoop Distributed File System (HDFS).
  • Apache Kafka
    The Kafka Handler is designed to stream change capture data from an Oracle GoldenGate trail to a Kafka topic.
  • Apache Hive
  • Azure Blob Storage
  • Azure Data Lake Storage
  • Azure Event Hubs
    Kafka handler supports connectivity to Microsoft Azure Event Hubs.
  • Azure Synapse Analytics Data Warehouse
    Microsoft Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing and Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA) analytics.
  • Confluent Kafka
  • Databricks
  • DataStax
  • Elasticsearch
  • Flat Files
  • Google BigQuery
  • Google Cloud Storage
  • Google Pub/Sub
  • Iceberg Event Handler
  • Java Message Service (JMS)
    The Java Message Service (JMS) Handler allows operations from a trail file to be formatted in messages, and then published to JMS providers like Oracle Weblogic Server, Websphere, and ActiveMQ.
  • Java Database Connectivity
    Learn how to use the Java Database Connectivity (JDBC) Handler, which can replicate source transactional data to a target or database.
  • Microsoft Fabric OneLake
  • MongoDB
    Learn how to use the MongoDB Handler, which can replicate transactional data from Oracle GoldenGate to a target MongoDB and Autonomous JSON databases (AJD and ATP) .
  • OCI Streaming
    Oracle Cloud Infrastructure Streaming (OCI Streaming) supports putting messages to and receiving messages using the Kafka client. Therefore, Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA) can be used to publish change data capture operation messages to OCI Streaming.
  • Oracle NoSQL
    The Oracle NoSQL Handler can replicate transactional data from Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA) to a target Oracle NoSQL Database.
  • OCI Autonomous Data Warehouse
    Oracle Autonomous Data Warehouse (ADW) is a fully managed database tuned and optimized for data warehouse workloads with the market-leading performance of Oracle Database.
  • Oracle Cloud Infrastructure Object Storage
    The Oracle Cloud Infrastructure Event Handler is used to load files generated by the File Writer Handler into an Oracle Cloud Infrastructure Object Store.
  • Redis
    Redis is an in-memory data structure store which supports optional durability. Redis is simply a key/value data store where a unique key identifies the data structure stored. The value is the data structure that is stored.
  • Snowflake
  • Additional Details

Parent topic: Replicate Data