Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Converting the rows to json in Mongodb

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
}
}

 

0683p000009LzTp.jpgXML Tree option when using tWriteJSONField component0683p000009Lz7o.jpgNo JSON tree configure option for tMongoDBOutput0683p000009LzJy.jpgWorkflow for Oracle to MongoDB.

Labels (5)
1 Reply
Anonymous
Not applicable
Author

Hello,

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

 

Best regards

Sabrina