RSS Feed

Native support for MySQL and MariaDB in the Reliance 4 SCADA/HMI system

April 3, 2014 | Bretislav Valek

Beginning with version 4.6.2, support for logging historical data and alarms/events to the MySQL and MariaDB relational database management systems with no need for writing scripts is part of the Reliance SCADA/HMI system. MySQL is a popular and widely used database system created by the Swedish company MySQL AB, now owned and operated by Oracle Corporation. MariaDB is a MySQL-based community-developed database system released under the GNU GPL. The MySQL Workbench and HeidiSQL database management tools are also part of the installation. They can be suitable for database management from another, client computer.


To download the installers of the systems/tools, go to the Web pages shown in the following table:


MySQL

MariaDB

MySQL database installer

MariaDB database installer

MySQL Workbench management tool

HeidiSQL management tool


How to connect Reliance to MySQL and MariaDB

The ODBC standard is used to access both database management systems. The Reliance system requires a 32-bit version of the MySQL Connector/ODBC driver.



Once you install the driver, a new data source can be created through the ODBC Data Source Administrator. You must run a 32-bit version of this tool. Follow these instructions:


32-bit Windows:


1. Go to the Windows Control Panel and select Administrative Tools > Data Sources (ODBC).

2. On the System DSN page, add a new data source by clicking on Add. Select MySQL ODBC 5.3 Unicode Driver.


64-bit Windows:


1. Run the ODBC Data Source Administrator using C:\Windows\SysWOW64\odbcad32.exe.

2. On the System DSN page, add a new data source by clicking on Add. Select MySQL ODBC 5.3 Unicode Driver.


Note: Shortcuts to both editions of the ODBC Data Source Administrator (32-bit and 64-bit) are already contained in the Control Panel of 64-bit versions of Windows 8.

Reliance SCADA, ODBC Data Source Administrator

ODBC Data Source Administrator


Reliance SCADA, Create New Data Source

Create New Data Source


3. In the MySQL Connector/ODBC Data Source Configuration dialog, set up the connection parameters (connection name, server address, and login data):


MySQL Data Source Configuration

Setting up the connection parameters



After that, you can define an SQL connection in a Reliance project:


1. Open your project in the Reliance Design development environment.

2. Go to the Project Options dialog box (Project > Options > SQL) and add a new connection (or use the predefined one).


Reliance SCADA, Project Options

Project Options

3. Click on the Edit Connection String button to open the Data Link Properties dialog.


4. On the Provider page, select Microsoft OLE DB Provider for ODBC Drivers:


Data Link Properties

Data Link Properties


5. On the Connection page, specify the data source and enter your login data:


Data Link Properties – entering the login data

Data Link Properties – entering the login data


6. Click on the Test Connection button to verify the connection. Click OK to save the changes.


Henceforth, you can use the connection for logging historical data and alarms/events in the visualization project.

Reliance Earth Icon

Top