Issue:
How do I connect Machine SCADA Expert to a MariaDB SQL database.
Product Line:
EcoStruxure Machine SCADA Expert (all versions)
Resolution:
In order to setup a database connection for Machine SCADA Expert with a MariaDB database server, we recommend using the MySQL Connector/Net database provider
which can be used as an interface to communicate with a MariaDB database server according to this product website: https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/
The MySQL Connector/Net database provider has been tested and works correctly with EcoStruxure Machine SCADA Expert.
At the time of this writing the MySQL Connector/Net database provider can be downloaded from the official MySQL site: https://dev.mysql.com/downloads/connector/net/
Once the MySQL Connector has been installed, you can use the typical Database Configuration dialog within EcoStruxure Machine SCADA Expert
to setup the database connection with MariaDB. However, unlike for other database types, you cannot use the Data Link Properties dialog (which is accessed by clicking
on the ellipsis button [...] to the right of the Connection String field) to form the connection string. Instead, you must directly enter the connection
string parameters using the basic format:
Provider=MYSQLCLIENT; Server=myServerAddress; Database=myDataBase; Uid=myUsername; Pwd=myPassword;
Where:
- "Provider" is the database provider name
- "Server" is the MariaDB database server IP address or hostname.
- "Database" is the database catalog name in the MariaDB database instance.
- "Uid" is the user ID user to to be used for this database connection.
- "Pwd" is the user password.
This is the same procedure as when composing a connection string to connect with a MySQL database server.
Further details and additional optional parameters can be found in the EcoStruxure Machine SCADA Expert Help, section 'Using MySQL'.
If this FAQ did not solve your issue, you can chat with us at chat with us or e-mail us at customer.services@se.com to create a case with our Technical Support Team.
If you are not located in North America, please contact your local Customer Care Center for assistance: Support | Schneider Electric Global (se.com)
