Converting the rows to json in Mongodb

Anonymous — Sat, 16 Nov 2024 07:48:04 GMT

Hi,, I am trying to convert data from Oracle to Mongodb . I am using the following flow. When I am using tWriteJsonField component, I am not getting option for configuring the JSON tree instead I get the XML tree structure. So, I tried using tMongoDBOutput_1 and there too I am not getting option for Configuring JSOn tree. I tried with Talend 6.1 and 7.0.1 and both has same issue. My desired output is as follow.

{ "_id" : ObjectId("5b75d09c3a4c89fd5c08bf0f"),
 "DEPARTMENT_NAME" : "Human Resources",
 "DEPARTMENT_ID" : 40,
 employees : {
 "EMPLOYEE_ID" : 118,
 "FIRST_NAME" : "Guy",
 "LAST_NAME" : "Himuro",
 "EMAIL" : "GHIMURO",
 "PHONE_NUMBER" : "515.127.4565",
 "SALARY" : 2600,
 "HIRE_DATE" : "15-11-2006", 
 "MANAGER_ID" : 114
}
}

XML Tree option when using tWriteJSONField componentNo JSON tree configure option for tMongoDBOutputWorkflow for Oracle to MongoDB.

Re: Converting the rows to json in Mongodb

Anonymous — Wed, 29 Aug 2018 08:53:35 GMT

Hello,

The JSON tree map will be configurable in a built-in mode for tMongoDBOutput component.

Best regards

Sabrina

topic Re: Converting the rows to json in Mongodb in Talend Studio

Converting the rows to json in Mongodb

Re: Converting the rows to json in Mongodb