cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Storing Thing Properties in two different value streams/DB's

pshashipreetham
17-Peridot

Storing Thing Properties in two different value streams/DB's

Hi,

We have Postgres as an Model DB, InfluxDB as an Time series DB. Will it be possible in a Thing, few logged properties can be stored in the InfluxDB and few on Postgres ?

Because we run a retention policy every month for Influx DB, which purges Data on Monthly basis, there are few properties that are getting logged to be excluded from the Purge.

So if I assign a Thing with ValueStream of InfluxDB everything gets purged, there are few properties that should be excluded for client data Analysis.

Thanks,

Shashi Preetham
1 ACCEPTED SOLUTION

Accepted Solutions

Unfortunately that isn't possible at this time, since a Thing is associated with only 1 Valuestream.

 

What you can do is to add a subscription (DataChange) on the properties you want to retain longer and have those write to a 'regular' Stream which has the other persistence provider. As long as you aren't 'exponentially' increasing the amount of events, and you aren't running very long processes off those subscriptions, it should be fine.

View solution in original post

1 REPLY 1

Unfortunately that isn't possible at this time, since a Thing is associated with only 1 Valuestream.

 

What you can do is to add a subscription (DataChange) on the properties you want to retain longer and have those write to a 'regular' Stream which has the other persistence provider. As long as you aren't 'exponentially' increasing the amount of events, and you aren't running very long processes off those subscriptions, it should be fine.

Top Tags