saving json array using tmongodbinput and tmysqluotput

Anonymous — Sat, 16 Nov 2024 10:25:23 GMT

Hi Team,
In my talend job the requirement is that i need to pull the data from mongodb and load the data in mysql db.

mongodb input document:
{
"_id" : ObjectId("57bd63f624acb0748449bc61"),
"FHW_id" : "57bd63f624acb0748449bc60",
"role" : 8,
"partner_ngo_details" : 1,
"sync_status" : 4,
"nodes_hierarchy" : [
{
"node1" : 1,
"node2" : 1,
"node3" : 1,
"node4" : 1,
"node5" : 1
}
]
}
--------------
i am using tmongodbinput and tmysqluotput along with tmap.My question is how can i save the nodes_hierarchy array object of the json data in mysql.

Thanks in advance.
Regards,
Chandan Kumar Sah

Re: saving json array using tmongodbinput and tmysqluotput

Anonymous — Tue, 06 Sep 2016 04:22:52 GMT

Hi,
Here is a component TalendHelpCenter:tExtractJSONFields which is used to extract the data from JSON fields stored in a file, a database table.
The work flow should be:tmongoDBInput-->textractJsonField-->tMap-->tMysqloutput
Let us know if it is Ok with you.
Best regards
Sabrina

topic Re: saving json array using tmongodbinput and tmysqluotput in Talend Studio

saving json array using tmongodbinput and tmysqluotput

Re: saving json array using tmongodbinput and tmysqluotput