How to insert an array type data into MongoDB by Talend tMongoDBOutput

Anonymous — Sat, 16 Nov 2024 10:01:42 GMT

Hello Guys,
when I insert a row in Mongo shell:
db.mycoll.insert(
{
"column1":
}
)
result is:
{ "_id" : ObjectId("58b82d52957107b7c5d11062"), "column1" : }
but when I load data with Talend tMongoDBOutput component, even I choice column1's data type is "Object" in output side, Talend still load it as string, result like this:
{ "_id" : ObjectId("58b82d52957107b7c5d11062"), "column1" : "" }
Because input_row is from Oracle, it is string, so I tried to add a tJavaRow component convert the string to array, but I can not set the result value to ouput_row which is tMongoDBOutput component's input_row, so anybody know What the best way I can do to resolved this problem? By the way, I must use Talend tMongoDBOutput to do it.
Thanks

Re: How to insert an array type data into MongoDB by Talend tMongoDBOutput

Anonymous — Fri, 07 Apr 2017 10:13:45 GMT

Hi,
You can perform this by passing an array of json documents to the insert method on a collection i n the mongo shell?
Have you tried this "function" in tMongoDBRow to see if it works?
Best regards
Sabrina

topic How to insert an array type data into MongoDB by Talend tMongoDBOutput in Talend Studio

How to insert an array type data into MongoDB by Talend tMongoDBOutput

Re: How to insert an array type data into MongoDB by Talend tMongoDBOutput