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 query from the controller to the SQL Gateway. Based on this connection name the SQL Gateway forwards the query to the configured SQL database.
For the communication between the controller and the SQL Gateway the following parameter must be provided:
oIP address of the PC on which the SQL Gateway is running
oTCP port number on which the SQL Gateway is listening (3457 per default)
oConnection name of the database connection configured in the SQL Gateway
For further information about configuration of SQL Gateway, refer to the SQL Gateway User Guide.
