MongoDB Extract to Kafka OGGBig Data Replicating With Wrong Special Characters In Kafka
(Doc ID 2956171.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate Big Data and Application Adapters - Version 21.8.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
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?
Example:
{"table":"stock-service.stockItem-001","op_type":"U","op_ts":"2023-05-31 14:39:26.000000","pos":"00000000100000003366","after.id":"{ \"_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 21.9.0.0.1 (Build 004)
Version 21.9.0.0.4 OGGCORE_21.9.0.0.0OGGRU_PLATFORMS_230310.1001
Cause
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
Symptoms |
Cause |
Solution |