topic Re: Insert ObjectID from Mongodb Collection A to Collection B in Mongodb in Talend Studio

Insert ObjectID from Mongodb Collection A to Collection B in Mongodb

Anonymous — Wed, 28 Mar 2018 20:18:25 GMT

I am new to using Talend. I am not able to carry over the ObjectID from Mongodb collection A to Mongodb collection B. I am using a

How to carry over a objectID from Mongodb's collection A to a new mongodb collection B. I am using the following logic to execute. TMongoDBInput-->tmap-->tMongoDBOutput. I have mapped the link target in tMongoDBOutput to have the _id field's static value mapped as object where the _id field attribute is defined as class. I am still seeing ObjectID as string in collection B. What am i missing here ? Appreciate the help. Thanks

Re: Insert ObjectID from Mongodb Collection A to Collection B in Mongodb

Anonymous — Wed, 28 Mar 2018 20:47:40 GMT

This problem was solved by making the attribute type of _id as @type and setting the Static Value to object in the Link target.

Re: Insert ObjectID from Mongodb Collection A to Collection B in Mongodb

krengan21 — Mon, 17 Sep 2018 15:05:12 GMT

Hi,

Can you share me the screenshot so that i can get a clear idea about it.

Thanks and Regards,

Kasthuri Rengan

Re: Insert ObjectID from Mongodb Collection A to Collection B in Mongodb

Anonymous — Tue, 06 Aug 2019 14:29:02 GMT

I too, would like to get a more explicit answer...
My problem is I need to insert from mysql to mongoDB.

But some field in my output table are ObjectId fields (which talend identified as string upon retrieving the schema)

Upon insert I match one Mysql column data on a mongoDB collection (label field) and get the corresponding _id (as a string)
But I need to put that in the mongoDB output on a reference ObjectId field (for another collection, just as a "foreign key").

I tried to import Bson objectId and do a ObjectId(MyStringId) / ObjectId.Parse(MyStringId) with no success.

Talend.PNG

Re: Insert ObjectID from Mongodb Collection A to Collection B in Mongodb

krengan21 — Wed, 07 Aug 2019 04:14:07 GMT

Try reading the data type as object while fetching it from the source and change the data type to object in output schema also it should solve your problem.

Don't forget to give Kudos if this solution is working .
Regards,
Kasthuri Rengan