Skip to main content
W
WB_99621451-Visitor
1-Visitor
September 10, 2021
Solved

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

  • September 10, 2021
  • 2 replies
  • 1389 views

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

Best answer by slangley

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

S
slangleyCommunity ManagerAnswer
Community Manager
September 23, 2021

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

 

L
LM_100297241-Visitor
1-Visitor
September 24, 2021

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

 

Dinar Guru

    Terms & ConditionsCookie settingsAccessibility statement