Thingworx 9.x - SQL Server - Broker - Notification

[hkwan]

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

[slangley]

HI @hkwan.

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

Regards.

--Sharon

[hkwan]

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

[slangley]

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