Skip to main content
H
hkwan1-Visitor
1-Visitor
May 31, 2022
Question

Thingworx 9.x - SQL Server - Broker - Notification

  • May 31, 2022
  • 1 reply
  • 1157 views

Dear Sir/Madam,

1.My client has asked me whether Thingworx app can detect a change in the SQL Server - Table. I've checked the existing Thingworx Database Connectivity(s). It does not support "SQL Notification". Correct?

2.I've read about "Thingworx Edge .NET SDK" & "SQL Server - Notification". It seems complicated. See, below.

https://support.ptc.com/help/thingworx/edge_sdk_dotnet/en/

https://www.c-sharpcorner.com/uploadfile/87b416/working-with-sql-notification

3.I'm new to Thingworx. Is there a better (easier) solution?

Pls advise. Thanks

1 reply

S
slangleyCommunity Manager
Community Manager
May 31, 2022

HI @hkwan.

 

Can you provide more context around your inquiry?  What type of change are you referring to?

 

Regards.

 

--Sharon

H
hkwan1-VisitorAuthor
1-Visitor
June 1, 2022

Dear Sharon,

The client is inserting/updating production data to a SQL database - table. The client requires Thingworx App to detect the change, query the changed rows, parse the data for other apps. My initial plan is to query the table every 5 seconds. The client prefers "trigger". Pls advise. Thanks

S
slangleyCommunity Manager
Community Manager
June 2, 2022

Hi @hkwan.

 

To clarify further, is this an external database ThingWorx is connecting to via jdbc?  You indicated ThingWorx would need to parse the data for other apps.  Are these ThingWorx apps?  What is the volume of data?  Querying the table every 5 seconds may cause performance issues.

 

Please provide detailed information regarding your use case and we will try to advise.

 

Regards.

 

--Sharon

Terms & ConditionsCookie settingsAccessibility statement