8 Replies Latest reply on Mar 9, 2017 6:44 AM by Ankit Gupta RSS
    duang Apprentice

    Read data from SQL and insert as property values

    I have an external SQL database that records data and I want to add this to a Thingworx thing to be stored in the associated value stream.

     

    How would you do this?

     

    I am able to access the SQL data from ThingWorx and query the table, but I need to assign it as properties of the thing.  The external database remains the master and I want ThingWorx to read updated data from the SQL server every minute.