saving json array using tmongodbinput and tmysqluotput

[Anonymous]

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

[Anonymous]

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