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

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

SQL Database to Kepware connection

VS_9760165
13-Aquamarine

SQL Database to Kepware connection

Hi ,

Fetching data from SQL database to Kepware tags through ODBC client , but tag values not updating when data updated in sql table. pls see below snap for your reference.

if we manually synchronize then its updating.

want to update tag value automatically whenever record in sql table updated/added.

 

VS_9760165_0-1649147537416.png

 

Thanks,

Vaibhav

2 REPLIES 2
PaiChung
22-Sapphire I
(To:VS_9760165)

There isn't a way I believe for there to be a trigger from SQL to Kepware, so I think you have to rely on the Kepware scanrate to go fetch the information periodically.

TBH I've never set it up this way, so hopefully someone else can provide more information.

VS_9760165
13-Aquamarine
(To:PaiChung)

Hi @PaiChung ,

 

Thank you for your reply,

 So i will try with SQL trigger and will see.

Announcements


Top Tags