Skip to main content
N
Nuttapol12-Amethyst
12-Amethyst
September 19, 2019
Question

How to send infotable to MSSQL

  • September 19, 2019
  • 3 replies
  • 2710 views

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.

 

 

3 replies

S
slangleyCommunity Manager
Community Manager
October 3, 2019

Hi @Nuttapol.

 

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

 

Regards.

 

--Sharon

    A
    AndyHilton13-Aquamarine
    13-Aquamarine
    October 6, 2023

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

    S
    slangleyCommunity Manager
    Community Manager
    November 14, 2023

    Hi @AndyHilton.

     

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

     

    Regards.

     

    --Sharon

      A
      AnnaAn14-Alexandrite
      14-Alexandrite
      October 8, 2019

      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

        A
        AnnaAn14-Alexandrite
        14-Alexandrite
        October 10, 2019

        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

        Terms & ConditionsCookie settingsAccessibility statement