
Anonymous
Not applicable
2017-03-02
04:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
292 Views
1 Reply

Anonymous
Not applicable
2017-04-07
06:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
292 Views
