Skip to main content
DR_105589338-Gravel
8-Gravel
Sep 20, 2023 2:20 AM UTC
Solved

Building dashboard for show data from Kepware ODBC Client

Now i try to make dashboard for showing data from MSSQL to Kepware in ODBC Client (as picture 1) and input to ThingWorx for showing as dashboard. But i cannot show all data that save to MSSQL can show only 1 row (as Picture 2) and can use Move function only (as Picture 3) but cannot next at mashup and search by date and time. How can i show all data and sorting by date and time? Thank you.

 

Sathishkumar_CAnswer
17-Peridot
Sep 26, 2023 5:27 AM UTC

I'm thinking of 3 options....

  1. If possible, you can connect directly MSSQL to ThingWorx. So that you can write your custom SQL Queries in ThingWorx.
  2. Temporarily log all the property values into ValueStream (All data change) or Stream (Every one minute with Timer/Scheduler). Then you can pull into Mashups.
  3. Have to verify with Kepware to fetch multiple records in single/multiple tag... (Not sure on this option.. let you know if got anything...)
View in thread

8 replies

Arun_C16-Pearl
16-Pearl
Sep 20, 2023 5:07 AM UTC

Hi @DR_10558933 ,

 

If I'm understanding your query properly means , you want to display the live data on mashup like Thingworx composer. In that case you can find default Industrial Thing > Service of GetPropertyValuesAsMultiRowTable, It will display the infotable data as multi rows with Status, Value, Last Updated Date Time.

Arun_C_1-1695186413398.png

 

Thanks & Regards,

Arun C

Translate
    DR_105589338-GravelAuthor
    8-Gravel
    Sep 21, 2023 6:15 AM UTC

    Can i build new row when execute like this photoScreenshot 2023-09-21 131340.png?

    Translate
    Arun_C16-Pearl
    16-Pearl
    Sep 21, 2023 6:51 AM UTC

    Hi @DR_10558933 ,

     

    Can you please explain me more on your use case for better understanding? What to develop on that screen its live monitoring of properties or history of property data?

     

    Thanks & Regards,

    Arun C

    Translate
    Sathishkumar_C17-PeridotAnswer
    17-Peridot
    Sep 26, 2023 5:27 AM UTC

    I'm thinking of 3 options....

    1. If possible, you can connect directly MSSQL to ThingWorx. So that you can write your custom SQL Queries in ThingWorx.
    2. Temporarily log all the property values into ValueStream (All data change) or Stream (Every one minute with Timer/Scheduler). Then you can pull into Mashups.
    3. Have to verify with Kepware to fetch multiple records in single/multiple tag... (Not sure on this option.. let you know if got anything...)
    Translate
      DR_105589338-GravelAuthor
      8-Gravel
      Sep 28, 2023 3:31 AM UTC

      Maybe use no.1 solution and try it . Thank you for help

      Translate
      Terms & ConditionsAccessibility statement