Hello,

In my current project I have to connect real time data from Beckhoff PLC to tables in SQL sever database. I am not able to do that based on Beckhoff database blocks that they provide or through their tech support. Can anybody please help and guide me on how I can attach real time data from Beckhoff PLC to SQL server database.

 

Depending on how you define real time, an SQL database is not capable of real time storage.

Several times I have stored data from TwinCAT in an SQL Server by writing a .NET application that retrieves data from TwinCAT and stores it in the database. I would use the NT_StartProcess function block in TwinCAT to launch the application. This technique works in batch applications where process data is stored in an array in TwinCAT, then retrieved by the application at the end of the batch.

 

Did you try with http://download.beckhoff.com/downlo...CAT_DataBase_Server/Install/TcDataBaseSrv.exe ?

I prefer writing a vb.net app communicating to the PLC trough ADS and writing to SQL the whit ADO.NET

 

Hi Sid,
I used OPC Client for ODBC for this. I pointed the OPC Client for ODBC to the Database. The connected the OPC Server to the OPC Client for ODBC and I got it to work.

Here is a link to try it:
http://www.matrikonopc.com/products/opc-archiving/opc-client-for-odbc.aspx

Cheers,
Wassim Daoud
Global Solutions Architect