My Oracle Support Banner

MongoDB Extract to Kafka OGGBig Data Replicating With Wrong Special Characters In Kafka (Doc ID 2956171.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle GoldenGate Big Data and Application Adapters - Version and later
Information in this document applies to any platform.


We've a MongoDB replication for Confluent(Kafka).

However, when the data is replicated, special characters like ' $ \""\ ' are included in the records.

Do we need to do any special configuration on the source or destination to prevent this issue?

{"table":"stock-service.stockItem-001","op_type":"U","op_ts":"2023-05-31 14:39:26.000000","pos":"00000000100000003366","":"{ \"_id\" : { \"$oid\" : \"xxxxxxxxxxxxxx\" } }","after.payload":"{\"_id\": {\"$oid\": \"xxxxxxxxxxxxx\"}, \"$v\": {\"$numberInt\": \"1\"}, \"$set\": {\"amountPhysical\": {\"$numberDouble\": \"62.0\"}}}"}

Source: MongoDB 4.4.17
Target: Kafka (json)

Oracle GoldenGate for Big Data
Version (Build 004)
Version OGGCORE_21.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.