Supported Controller Libraries

For Siemens S7, SQL4automation provides four sample projects: one for Siemens S7-1200 and Siemens S7-1500 in TIA Portal, one for S7-300 / S7-400 PN/DP controllers, and one in combination with the communication processor CP-343 / CP-443 in Simatic Studio.

For Mitsubishi GX Works3 controllers, SQL4automation provides a sample project and a library. The library can either be opened directly as a new project or integrated into an existing project.

For Allen Bradley and Rockwell Automation controllers, SQL4automation provides the SQL4RSLogix Add-On Instruction and sample projects for ControlLogix and CompactLogix systems. Communication is via Ethernet/IP socket. Sample projects are available in both Ladder and Structured Text.

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

For Beckhoff TwinCAT, SQL4automation provides libraries and sample projects for both TwinCAT V2 (SQL4TwinCAT) and TwinCAT V3 (SQL4TwinCAT3), including a TLS/SSL-capable Version 5 library for TwinCAT V3. Both variants support unencrypted and encrypted communication.

For B&R PLCs programmed in Automation Studio, SQL4automation provides the SQL4BR library. The sample project is configured to run immediately on the AR000 simulation controller — no hardware is required for testing. The library requires B&R Automation Studio V3.0.80.25 or higher and Automation Runtime V3.00 or higher. SQL4BR supports SELECT, INSERT, UPDATE, and DELETE operations.

For Sigmatek LASAL controllers, SQL4automation provides the SQL4LASAL library with support for both UTF-8 (Standard target) and UTF-16 communication. All Sigmatek controllers with open TCP/IP communication support are compatible. The library has been tested with the SoftSPS Lars and a C-IPC.

For KUKA KRC4 robot controllers, SQL4automation provides the SQL4KUKA library via the Ethernet KRL XML Interface. SQL4KUKA consists of a configuration file (sql4kuka.xml), the library (sql4kuka.src / sql4kuka.dat), and an example program. The Ethernet KRL XML Interface is available from KUKA as an option.

For Stäubli CS8C and CS9 robot controllers running VAL3, SQL4automation provides the SQL4Val3 library and a sample project. SQL4Val3 can be directly integrated as a library and runs on all Stäubli CS8 and Stäubli CS9 controllers with firmware version V7 or higher. In addition, the library can be tested directly on the Stäubli Emulator.

For ABB robot controllers running RAPID, SQL4automation provides the SQL4Rapid library. For ABB AC500 PLCs, the SQL4AC500 library (CODESYS V2 based) or SQL4CODESYSV3 (for AC500 V3) are used. Both establish direct TCP/IP connections to the SQL4automation Connector, no OPC UA server or middleware required.

For Schneider Electric PLCs, SQL4automation provides the SQL4SE library, which is built on the SQL4CODESYSV3 library. SQL4SE uses the fbSQL4CODESYS function block and follows the same integration pattern as CODESYS V3. The library is installed via the SQL4SE_ProjectArchive.

For Bucher Automation (formerly Jetter) PLCs, SQL4automation integration is available via the dedicated SQL4JetSym library. The library runs on all Bucher Automation controllers with an Ethernet interface and can be ordered directly at sales@bucherautomation.com.

For HORST robot systems, SQL4automation provides the SQL4HORST library supporting both graphical and textual programming modes. Database queries can be integrated into HORST programs as individual functions. Results are returned in a DataTable array accessible as DataTable[Row][Column].

For FANUC robot controllers, SQL4automation provides the SQL4FANUC library implemented in KAREL. SQL4FANUC requires the KAREL (R632) and User Socket Msg (R648) software options on the FANUC controller. Results are returned in the KAREL DataTable array and accessed via type conversion helper functions.

For Omron NX/NJ PLCs programmed in Sysmac Studio, SQL4automation provides the SQL4Omron library (Sql4OmronLib.slr). The library requires CPU version 1.18 or newer and uses standard Omron socket functions (SktTCPConnect, SktClose, SktGetTCPStatus, SktClearBuf). The library was developed and tested with an NX1P2.