Rockwell Allen Bradley

Connection Rockwell Allen Bradley PLC to SQL database, MES, ERP

SQL4automation provides two sample projects for Rockwell Allen-Bradley controls (RSLogix). These are examples for the controller types ControlLogix and CompactLogix, in particular for the controllers 1756-L63 ControlLogix5563 and 1769-L18ERM-BB1B CompactLogix5318ERM-BB1B. In addition, a SQL4automation function block is available in the example, which may be imported into the current project as an add-on.

The following Rockwell Allen-Bradley PLC controllers and communication modules can set up TCP socket connections and are therefore compatible with SQL4automation:

Project-specific adjustments

The following project-specific adjustments have to be made to the function block SQL4automation:

Settings SQL4automation link

For Rockwell Allen-Bradley controls the SQL4automation Connector is operated with the target settings "standard". The configuration is completed with a few clicks.

On the following Rockwell Allen-Bradley controls the SQL4automation library has been tested:

• 1756-L63 ControlLogix5563
• 1769-L18ERM-BB1B CompactLogix5318ERM-BB1B