Mongo _ID field

[david_lange]

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

[john_wang]

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.

[david_lange]

Mongo version is 5.0.8

Both CDC and Full

I am new to QLIK, do you have instructions on   "open a support case with task Diag Package"

-Dave

[Steve_Nguyen]

@david_lange

https://community.qlik.com/t5/Knowledge/How-to-create-a-case-and-contact-Qlik-Support/ta-p/1710992

https://community.qlik.com/t5/Support/ct-p/qlikSupport?_ga=2.173812902.426572303.1652099283-29638097...

[john_wang]

Hello @david_lange ,

---

@david_lange wrote:

Mongo version is 5.0.8

---

Replicate officially support MongoDB version 4.x. Maybe it works well with MongoDB 5.x however 5.x is not certified yet.

Just for your info.

Regards,

John.