cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

How to send infotable to MSSQL

Nuttapol
11-Garnet

How to send infotable to MSSQL

I have infotable but i would like to send infotable to MSSQL External database.

Now I try to use jdbc connector extension but i don't know how to send infotable to MSSQL External database.

please suggestion me thank you.

 

 

5 REPLIES 5
slangley
23-Emerald II
(To:Nuttapol)

Hi @Nuttapol.

 

Take a look at this learning guide to see if it answers your questions.

 

Regards.

 

--Sharon

AndyHilton
13-Aquamarine
(To:slangley)

The guide appears to not be a part of this link any longer.

slangley
23-Emerald II
(To:AndyHilton)

Hi @AndyHilton.

 

The learning guides were migrated to IoT TipsThis one may be helpful in answering your questions.

 

Regards.

 

--Sharon

AnnaAn
14-Alexandrite
(To:Nuttapol)

Hi,

Do you really want to store the fields in your InfoTable to the mapping fields separately in your MSSQL database table? If so you need an intermediate service to parse these fields out and then call the SQL Command to store it into database table;

if you want to store the InfoTable into only one field of your MSSQL database table, then you could consider to change InfoTable format to JSON(for example, ToJSON Service) and then store it into your MSSQL table varchar field.

Br,

Anna

AnnaAn
14-Alexandrite
(To:Nuttapol)

Hi,

Could you let us know if your problem is resolved? Please share with us how it's resolved or please mark the post as Accepted Solution for others reference who have similar question.

Thanks,

 

Br,

Anna

Announcements


Top Tags