Supported Controller Libraries
Siemens S7
For Siemens S7, SQL4automation provides four sample projects. For Siemens S7-1200 and Siemens S7-1500 in TIA Portal V13, one for S7-300 / S7-400 PN/DP controllers, and one in combination with the communication processor CP-343 / CP-443 in Simatic Studio.
Mitsubishi Electric GX Works3
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.
Rockwell Allen Bradley
For Rockwell Allen-Bradley controllers (RSLogix), SQL4automation provides two sample projects. These are examples for the ControlLogix and CompactLogix controller types, specifically for the 1756-L63 ControlLogix5563 and 1769-L18ERM-BB1B CompactLogix5318ERM-BB1B controllers.
CODESYS
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. SQL4CODESYS runs on all CODESYS controllers that support the SysSocket.lib (V3) or SysLibSockets.lib (V2) and are equipped with an Ethernet interface.
Beckhoff TwinCAT
For Beckhoff TwinCAT, SQL4automation provides two sample projects. One for TwinCAT V2 and one for TwinCAT V3 controllers. SQL4TwinCAT can be directly integrated as a library. Since communication takes place via TCP/IP, the Beckhoff TCP/IP Server license is required. On Beckhoff controllers running Windows or Windows Embedded (not CE), the SQL4automation Connector can be installed directly. No additional hardware is necessary.
B&R
For B&R PLC controllers, SQL4automation provides a sample project and a library. The sample project is configured to run immediately on the AR000 simulation controller. No hardware is required for testing.
Sigmatek
For Sigmatek LASAL PLC controllers, SQL4Automation provides two sample projects. One demonstrates the UTF-8 connection, the other a UTF-16 (Unicode) connection to an SQL database. The sample projects are configured to run immediately on the LARS test environment. No additional hardware is required.
KUKA
For KUKA robots, SQL4automation provides a sample project and a sample library. SQL4KUKA can be directly integrated as a library and runs on all KUKA KRC4 controllers. For TCP/IP communication, the license for the KUKA KRL XML interface is required.
Stäubli
For Stäubli robots, SQL4automation provides a sample project and a library. 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.
ABB
For ABB robots, SQL4automation provides a sample project and a library. SQL4Rapid can be directly integrated as a library and runs on all ABB robot controllers.
Schneider Electric
For Schneider Electric PLC 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.
Bucher Automation JetSym
For Bucher Automation JetSym 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.
HORST
For HORST robots, 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.
FANUC
For FANUC robot 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.
OMRON
For OMRON 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.
Compatibility
With SQL4Automation, you connect PLCs, robots, and MES systems directly via TCP/IP to all common SQL databases - flexible, without middleware, and with ready-to-use libraries for many controller types.
Supported Databases
MES Connections
With SQL4Automation, you connect your control systems directly to MES platforms without detours through additional software components. MES functions can be accessed directly from the PLC via SQL or web services, for example for order management, status reporting, or machine connectivity.
Example projects for CODESYS, Beckhoff, and Siemens facilitate implementation. Other controllers with SQL4Automation libraries can also be flexibly integrated. The connection is set up like a classic SQL link and managed via the Data Source Admin tool for fast and reliable communication between the shop floor and MES.
Supported Platforms
SQL4automation is supported by the following operating systems
Windows
SQL4automation runs on all Windows platforms from Windows XP onwards. Windows CE is not supported.
Linux
SQL4automation runs on all Debian derivatives. Other Linux systems available upon request.
Raspberry Pi
SQL4automation runs on Raspbian. Other Raspberry Pi systems available upon request.
Beckhoff
Since Beckhoff controllers run Windows, SQL4automation can be installed directly on these controllers. Windows CE systems are not supported.
Wago PFC 100/ 200
SQL4automation can be installed directly on a Wago PFC 100 or Wago PFC 200.
Switch to SQL4automation now.
Connect industrial controllers directly to SQL databases. Proven in practice since 2007 for maximum performance and security, completely without middleware.