Beckhoff TwinCAT

Connection Beckhoff TwinCAT PLC to SQL database, MES, ERP

For Beckhoff TwinCAT SQL4automation provides two sample projects. One for TwinCAT V2 and one for TwinCAT V3 controls. SQL4TwinCAT can be directly integrated as a library. Since the communication takes place via TCP/IP, the TCP/IP server licence from Beckhoff is required. On Beckhoff controls, on which Windows or Windows embedded (not CE) is running, the SQL4automation Connector may be installed directly. Thus no additional hardware is necessary.

Integration of the SQL4TwinCAT library

Parameters such as IP address and the connector's port and the SQL string are passed to the SQL4TwinCAT library. The return values of the SQL query are written into the two-dimensional string array ptTableValues

Settings SQL4automation link

For Beckhoff TwinCAT controls, the SQL4automation Connector is operated with the target settings "standard". The configuration is completed with a few clicks.

Tested Beckhoff controls

The SQL4TwinCAT library has been tested on the following Beckhoff PLC controls:

• Beckhoff CX9000
• Beckhoff CX9010
• Beckhoff CX9020
• Beckhoff CX5020
• Beckhoff C6920