CODESYS

Connection CODESYS PLC to SQL database, MES, ERP

SQL4automation provides two sample projects for CODESYS. One for CODESYS V2 and one for CODESYS V3 controls. SQL4CODESYS can be directly integrated as a library. SQL4CODESYS runs on all CODESYS controls that support either SysSocket.lib (V3) or SysLibSockets.lib (V2) and that are equipped with an Ethernet interface.

Integration of the SQL4CODESYS library

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

Setting SQL4automation link

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

Tested CODESYS controls

The SQL4CODESYS library has been tested on the following CODESYS PLCs:

• CODESYS SP PLC WinNT
• CODESYS SP RTE
• CODESYS Control Win SL
• CODESYS Control RTE SL
• Bosch Rexroth L20
• Bosch Rexroth L25
• Wago 750-885
• Wago 750-841
• Wago I/O-IPC
• Wago Speedway
• Wago PFC100/200
• KEBA CP-242
• Solvimus auvis.box
• Festo CPX
• Festo CEC
• Kendrion Kuhnke FIO Controller 113