Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 component
No JSON tree configure option for tMongoDBOutput
Workflow for Oracle to MongoDB.
Hello,
The JSON tree map will be configurable in a built-in mode for tMongoDBOutput component.
Best regards
Sabrina