Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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