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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Thingworx 9.x - SQL Server - Broker - Notification

hkwan
7-Bedrock

Thingworx 9.x - SQL Server - Broker - Notification

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

3 REPLIES 3
slangley
23-Emerald II
(To:hkwan)

HI @hkwan.

 

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

 

Regards.

 

--Sharon

hkwan
7-Bedrock
(To:slangley)

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
23-Emerald II
(To:hkwan)

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

Top Tags