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 21.8.0.0.0 and later
Information 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


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