Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
Hi,
I have two kind of data in my thing some data changes quite rarely while other data is frequent. I want to store frequent data in influxdb and less frequent data in postgres because i'll be purging data every month. Is there any way to do this.
Thanks,
Adarsh
Solved! Go to Solution.
Hi @AA_10034462 ,
You can Refer to: https://community.ptc.com/t5/ThingWorx-Developers/Storing-Thing-Properties-in-two-different-value-streams-DB-s/m-p/816669
As of now it can't be done, until and unless you wanna use a AnyDataChange Event on the Frequent Data to store in Postgres Values Streams.
Thanks,
Hi @Sathishkumar_C ,
I have similar situation, a Thing is connected with the InfluxDb Value Stream, while Client want to store the less Frequent data in the Postgres(or avoid purge if it is in Influx Value streams), Because in Influx there is an retention policy which purges the data for every month, less frequent data should be avoided during the purge if it is in Influx, can this be achieved ?
Thanks,
Shashi.
Hi @AA_10034462 ,
You can Refer to: https://community.ptc.com/t5/ThingWorx-Developers/Storing-Thing-Properties-in-two-different-value-streams-DB-s/m-p/816669
As of now it can't be done, until and unless you wanna use a AnyDataChange Event on the Frequent Data to store in Postgres Values Streams.
Thanks,