Skip to main content

SQL4automation Connector

Requirements​

The SQL4automation Connector V5 runs as a service on Windows (XP and up) or Linux (Ubuntu).

The connection between PLC / robot control and the Connector is established via TCP/IP. The connection to the database is made via ODBC. This means the control system, connector and database must be able to communicate with each other via TCP/IP.

Topology​

There are several options for arranging the connector and the database. See some installation possibilities below:

Legend: SQL4automation Connector, Control (PLC, robot controls, ...), SQL database

Stand-Alone System​

Control system, SQL server and the SQL4automation Connector are installed on a PC or Control Panel-PC.

Example 1: Control, SQL database and SQL4automation Connector on one PC Example 2: Control, SQL database and SQL4automation Connector on one Control Panel-PC

Separate SQL-Server​

The SQL server and the SQL4automation Connector are installed on a PC or Control Panel-PC.

Example 3: SQL database and SQL4automation Connector on a PC, control connected via the machine network (Ethernet) Example 4: SQL database and SQL4automation Connector on a Control Panel-PC, control connected via the machine network (Ethernet)

Separate Automation and Data Network (e.g. Company Network)​

The SQL server is installed on a PC (e.g. Linux server) and connected to the data network. The control system is connected to the automation network. The SQL4automation Connector is installed on a second PC or Control Panel-PC. The connector interlinks both networks with each other. The networks can be protected with a firewall.

Example 5: Network database in the company network, Control Panel-PC with SQL4automation Connector interlinking company and machine network, several controls in the machine network