Skip to main content
D
DR_105589338-Gravel
8-Gravel
September 20, 2023
Solved

Building dashboard for show data from Kepware ODBC Client

  • September 20, 2023
  • 2 replies
  • 4545 views

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.

 

Best answer by Sathishkumar_C

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...)

2 replies

A
Arun_C16-Pearl
16-Pearl
September 20, 2023

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

    D
    DR_105589338-GravelAuthor
    8-Gravel
    September 21, 2023

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

    A
    Arun_C16-Pearl
    16-Pearl
    September 21, 2023

    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

    S
    17-Peridot
    Sathishkumar_C17-PeridotAnswer
    17-Peridot
    September 26, 2023

    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...)
      D
      DR_105589338-GravelAuthor
      8-Gravel
      September 28, 2023

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

      Terms & ConditionsAccessibility statement