Skip to main content
Sep 10, 2021 1:51 PM UTC
Solved

Storing data pulled from a database inside a stream/value stream

Hello,

 

I was wondering weither it would be possible to store the data i pull from my DB inside a stream?
I succefuly made the connexion to Mssql and i am able to query those data using a service.

The reason behind this is that i'd like to be able to iterate through or use the recent temperature data stored in the stream inside a subscription that does some manipulations for me.

 

Thank you in advance

slangleyAnswer
Sep 23, 2021 7:08 PM UTC

Hi @WB_9962145.

 

You can certainly do that.  Here are some links that may help to determine the best method:

 

Storing Data in ThingWorx

Difference between Streams, Value Streams and Datatables in ThingWorx

Methods for Data Storage

 

Review the above to determine if you actually want to use streams.  It's also possible to leave the data in the source location and write services to handle the manipulations for returning the needed values.

 

Regards.

 

--Sharon

 

2 replies

slangleyAnswer
Sep 23, 2021 7:08 PM UTC

Hi @WB_9962145.

 

You can certainly do that.  Here are some links that may help to determine the best method:

 

Storing Data in ThingWorx

Difference between Streams, Value Streams and Datatables in ThingWorx

Methods for Data Storage

 

Review the above to determine if you actually want to use streams.  It's also possible to leave the data in the source location and write services to handle the manipulations for returning the needed values.

 

Regards.

 

--Sharon

 

Sep 24, 2021 4:00 AM UTC

Thanks to this article I can learn more. Expand my knowledge and abilities. Actually the article is very real.

 

Dinar Guru