The Schneider Electric SQL Gateway is an additional software that builds the interface between the controller and the SQL database.
The SQL Gateway must be installed on a PC from which the controller and the MySQL server can be reached.
In the SQL Gateway console, the connection to the database must be configured. For each database connection, a unique connection name must be specified. This connection name must be defined in the controller application as it is in the SQL Gateway, and is transmitted in conjunction with the SQL request from the controller to the SQL Gateway. Based on this connection name the SQL Gateway forwards the request to the configured SQL database.
For the communication between the controller and the SQL Gateway the following parameter must be provided:
IP address of the PC on which the SQL Gateway is running
TCP port number which the SQL Gateway is monitoring
Connection name of the database connection configured in the SQL Gateway
For secured communication via TLS, the digital certificates must be managed:
The server certificate (applied by the SQL Gateway) must be declared as trusted on the controller.
Depending on the settings in the SQL Gateway, it might be required to add the controller certificate to the list of permitted clients for the SQL Gateway.
For further information, refer to: