Skip to main content
14-Alexandrite
October 4, 2019
Solved

Kepware data to a database

  • October 4, 2019
  • 1 reply
  • 6519 views

Hi,

Is it possible to store kepware data in a database? I want to retrieve data from DB with SQL commands. 

 

When connectivity with Thingworx and kepware are interrupted, I need to store data from kepware to database and retrieve the data to Thingworx when connection is reestablished.  Store and forward functionality in Kepware can automatically send data to Thingworx when connection is reestablished but it don't have any control as we need to calculate the KPIs based on the retrieved data and sync with the existing data.

 

With regards

Yedukrishnan U

Best answer by KCorrigan

Hi Yedukrishnan,

 

Yes, there are a couple options for having KEPServerEX log data to ODBC compliant databases such as SQL.

Please read more about these logging options in the following Knowledge Base Article:

 

https://www.ptc.com/en/support/article?n=CS277795

 

Best Regards,

 

KC

Kepware TSE

1 reply

KCorrigan14-AlexandriteAnswer
14-Alexandrite
October 4, 2019

Hi Yedukrishnan,

 

Yes, there are a couple options for having KEPServerEX log data to ODBC compliant databases such as SQL.

Please read more about these logging options in the following Knowledge Base Article:

 

https://www.ptc.com/en/support/article?n=CS277795

 

Best Regards,

 

KC

Kepware TSE

Community Manager
October 16, 2019

Hi @Yedukrishnan.

 

If the response provided by @KCorrigan answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon