Connection of Bucher Automation PLC to SQL database, MES, ERP

For Bucher Automation Jetsym PLCs, SQL4automation provides a sample project and a library. SQL4JetSym runs on all JetSym PLCs which support Ethernet. You can either directly open the SQL4JetSym library as a new project or integrate it into an existing one.

Integration of the SQL4JetSym library

The SQL4JetSym library receives parameters like the ip address and port of the connector, as well as the SQL string. The return values are then written into the structure stResult.

The library gets called with the following command:

Default Parameters for CfbSQL4JetSym:

Settings SQL4automation link

The SQL4automation Connector is operated with the target settings "Standard" for Bucher Automation JetSym PLCs. The configuration only takes a few clicks.

The SQL4JetSym Library can be ordered here.

Tested Bucher Automation controls

The SQL4JetSym library has been tested on the following Bucher Automation JetSym controls:

• JC-340
• JC-350
• JC-365MC
• JC-440EXT