Skip to main content

SQL4automation Modes of Operation

Requirements​

The SQL4automation Connector V6 runs as a service on Windows (XP and up) or Linux (Ubuntu) in the browser.

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

SQL4automation Integrated into Production PC​

The SQL server/database and the SQL4automation Connector are both installed on the same PC.

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

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