Building dashboard for show data from Kepware ODBC Client

[DR_10558933]

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.

[Arun_C]

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.

Thanks & Regards,

Arun C

[DR_10558933]

Can i build new row when execute like this photo?

[Arun_C]

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

[DR_10558933]

Thank you

First i input data from MSSQL to Kepware in OBDC Client by used Dynamic table function as picture 1

after that i want to show data that collect from Kepware to Thingworx and show data realtime in table and other type.

MSSQL >> KEPWARE >> THINGWORX >> Show data realtime

[Arun_C]

Hi,

Correct me if Im worng, You are expecting the realtime data from Industrial Thing in Thingworx. But in above reply you asked for the 2 second row to add which means whether it an second thing with same set of data feilds? Can you please tell me with sample how that screen need to be develop?

Thanks & Regards,

Arun C

[DR_10558933]

Dear Mr.Arun , i mean i want to create new row every 1 minute with new data that receive from kepware. thank you.

[Sathishkumar_C · Accepted solution]

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

[DR_10558933]

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