Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Despite a successful extraction, the data is not reaching the target REPLICATE(Kafka) through the distribution path.

Krishna90Jan 17 2024

I am currently facing an issue with the data ingestion process in my Oracle GoldenGate (GG) datastream pipeline. The pipeline involves the following components: ATP DB-GG Deployment-1- GGdeployment-2- Kafka-GG stream analytics, where GG represents Oracle Cloud Infrastructure GoldenGate. Extract and Distribution path processing records but both Replicate (Apache kafka) and receiver path not processing any records.

Source Database: Oracle ATP Database
GoldenGate Deployments: GG Deployment-1(ATP DB) and GG Deployment-2(Kafka)

Properties file :
# Properties file for Replicat TEST

#kafka Connect Handler Template
gg.handlerlist=kafkaconnect
gg.handler.kafkaconnect.type=kafkaconnect
gg.handler.kafkaconnect.connectionId=ocid**************************************
gg.handler.kafkaconnect.mode=op
gg.handler.kafkaconnect.pkUpdateHandling=update
#TODO: Set the template for resolving the topic name.
gg.handler.kafkahandler.topicMappingTemplate=${fullyQualifiedTableName}
gg.handler.kafkaconnect.keyMappingTemplate=${primaryKeys}
gg.handler.kafkaconnect.omitNullValues=false
gg.handler.kafkaconnect.messageFormatting=row
gg.handler.kafkaconnect.metaColumnsTemplate=${objectname[table]},${optype[op_type]},${timestamp[op_ts]},${currenttimestamp[current_ts]},${position[pos]}
gg.handler.kafkaconnect.converter=json
#TODO: Set the location of the Kafka client libraries
gg.classpath=$THIRD_PARTY_DIR/kafka/*
jvm.bootoptions=-Xmx512m -Xms32m

Comments
Post Details
Added on Jan 17 2024
0 comments
32 views