topic Re: Convert uuid to Object-id using Talend in Data Quality

Convert uuid to Object-id using Talend

TRandy — Fri, 15 Nov 2024 22:17:30 GMT

Please can you help me ??

I have a field that provides ids but they are uuids. I would like to convert them to Object_id so that it can be consumed by mongo

Re: Convert uuid to Object-id using Talend

Anonymous — Wed, 07 Dec 2022 20:44:02 GMT

A MongoDB ObjectId is made up of different parts. These are explained here....

https://www.mongodb.com/docs/manual/reference/method/ObjectId/

While this will be possible in Talend, I am not sure that simply converting a UUID will be sufficient. You will need to construct it according to the rules in the doc above.

Re: Convert uuid to Object-id using Talend

TRandy — Thu, 08 Dec 2022 13:26:38 GMT

Thanks for your feedback @Richard Hall ,

Please how can i do it using Talend ??

Re: Convert uuid to Object-id using Talend

Anonymous — Mon, 12 Dec 2022 15:56:02 GMT

If you want to create your own ObjectIds, you will need to do this following the MongoDB JavaDocs to do this in Java. These can be seen here....

https://mongodb.github.io/mongo-java-driver/3.6/javadoc/org/bson/types/ObjectId.html

But MongoDB should generate these IDs for you when you load new documents into the DB. Unfortunately this is not a Talend question, this is a question for MongoDB.