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 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
  
• 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.
• 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) .
• Netezza
  
• 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