Skip to main content
S
SA_101003587-Bedrock
7-Bedrock
February 28, 2022
Solved

How to store industrial connection data in Postgres

  • February 28, 2022
  • 2 replies
  • 2352 views

Hi,
I am trying to make connectivity with remote industrial connection thing and PostgreSQL database,  any guide or steps to follow to insert the remote thing industrial connection data into the Postgres SQL database.
could you please help me with this connectivity and data insertion of streaming data, I am using the Thingworx 9 version and Postgres sql database?

Best answer by slangley

Hi @SA_10100358.

 

The easiest thing to do is to read the properties coming in and log them to a value stream.  Once in the value stream, will you have the data available to manipulate as needed via services/mashup.  Alerts can be generated based on the conditions you define.  

 

This is a simplistic view so you will need to consider volume in your design to avoid the possibility of performance issues.

 

Regards.

 

--Sharon

 

 

2 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
February 28, 2022

Hi,

 

From "Help Center" - "PostgreSQL": https://support.ptc.com/help/thingworx/platform/r9/en/index.html#search/PostgreSQL

S
slangleyCommunity Manager
Support
March 7, 2022

Hi @SA_10100358.

 

Hopefully, you will find this guide helpful.

 

Regards.

 

--Sharon

 

 

S
SA_101003587-BedrockAuthor
7-Bedrock
March 8, 2022

Hi slangley, Thanks for your help. i have gone through this guide. This helps with connectivity and visualization. 
In my use case, I want to read the streaming data and while reading the live data I want to apply some logic and filters and then I want to push the data into the Postgres database. 
Could you please help me with how we can apply custom logic to streaming data eg. by using value stream, service, thing, property?  

Terms & ConditionsAccessibility statement