topic Re: Mongo _ID field in Qlik Replicate

Mongo _ID field

david_lange — Mon, 09 May 2022 21:51:16 GMT

When replicating Mongo data to Oracle the Mongo _id column is transformed.

For example this _ID in Mongo

Enterprise mongodb-dev [primary] dk_pdce_ipick_transfer> db.transfer_requests.find({MasterPartId: 155100})
_id: Binary(Buffer.from("04a9368d5cc11743b6bc576a064de13f", "hex"), 3),

Lands is converted into a different value

SELECT DOC_ID, DOC
FROM MONGO_IPICK_MAIN.TRANSFER_REQUESTS
where doc like '%"MasterPartId": 155100%'
4317c15c-8d36-a904-3fe1-4d066a57bcb6

Re: Mongo _ID field

john_wang — Tue, 10 May 2022 03:31:16 GMT

Hello @david_lange ,

The "_id" column is meaningful in MongoDB (unique identifier "_id" in MongoDB ). In general this column should be replicate to target side as is. Not sure if you add any transformation or other operations on it. please let me know:

1. there MongoDB version

2. the behavior occurs in Full Load stage, or CDC stage, or both

For secure reason I'd like to suggest you open a support case with task Diag Package so far we may check further.

thank you,

John.