Json to sql table

Anonymous — Tue, 07 Jun 2016 13:31:37 GMT

Hi ,
I had a requirement where i need to take data from json file and load it in table (sql server).
can anyone please help me in this .
my sample json file is
[
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Tool Crib",
"Availability": "0.00",
"LocationID": "1"
},
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Sheet Metal Racks",
"Availability": "0.00",
"LocationID": "2"
},
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Paint Shop",
"Availability": "0.00",
"LocationID": "3"
},
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Paint Storage",
"Availability": "0.00",
"LocationID": "4"
},
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Metal Storage",
"Availability": "0.00",
"LocationID": "5"
},
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Miscellaneous Storage",
"Availability": "0.00",
"LocationID": "6"
},
{
"CostRate": "0.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Finished Goods Storage",
"Availability": "0.00",
"LocationID": "7"
},
{
"CostRate": "22.5000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Frame Forming",
"Availability": "96.00",
"LocationID": "10"
},
{
"CostRate": "25.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Frame Welding",
"Availability": "108.00",
"LocationID": "20"
},
{
"CostRate": "14.5000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Debur and Polish",
"Availability": "120.00",
"LocationID": "30"
},
{
"CostRate": "15.7500",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Paint",
"Availability": "120.00",
"LocationID": "40"
},
{
"CostRate": "18.0000",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Specialized Paint",
"Availability": "80.00",
"LocationID": "45"
},
{
"CostRate": "12.2500",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Subassembly",
"Availability": "120.00",
"LocationID": "50"
},
{
"CostRate": "12.2500",
"ModifiedDate": "06/01/1998 00:00:00",
"Name": "Final Assembly",
"Availability": "120.00",
"LocationID": "60"
}
]

Regards,
Miranda

Re: Json to sql table

Anonymous — Tue, 07 Jun 2016 19:09:19 GMT

Did you look at the tJSONExtractFields component?
Your job will look like , tFileInputJSON --> tJSONExtractFields --> tMSSQLOutput

topic Re: Json to sql table in Talend Studio

Json to sql table

Re: Json to sql table