![]() ![]() DBAs can quickly view key performance indicators using the Performance Dashboard. MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. Learn more » Visual Performance Dashboard Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health. MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. The Object Browser provides instant access to database schema and objects. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. Henceforth, you can use the connection for logging historical data and alarms/events in the visualization project.MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. Click on the Test Connection button to verify the connection. On the Connection page, specify the data source and enter your login data:ĭata Link Properties – entering the login dataĦ. On the Provider page, select Microsoft OLE DB Provider for ODBC Drivers:ĥ. Click on the Edit Connection String button to open the Data Link Properties dialog.Ĥ. Go to the Project Options dialog box ( Project > Options > SQL) and add a new connection (or use the predefined one).ģ. Open your project in the Reliance Design development environment.Ģ. In the MySQL Connector/ODBC Data Source Configuration dialog, set up the connection parameters (connection name, server address, and login data):Īfter that, you can define an SQL connection in a Reliance project:ġ. 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.ģ. Run the ODBC Data Source Administrator using C:\Windows\SysWOW64\odbcad32.exe. On the System DSN page, add a new data source by clicking on Add. Go to the Windows Control Panel and select Administrative Tools > Data Sources (ODBC).Ģ. You must run a 32-bit version of this tool. Once you install the driver, a new data source can be created through the ODBC Data Source Administrator. The Reliance system requires a 32-bit version of the MySQL Connector/ODBC driver. The ODBC standard is used to access both database management systems. ![]() How to connect Reliance to MySQL and MariaDB To download the installers of the systems/tools, go to the Web pages shown in the following table: They can be suitable for database management from another, client computer. The MySQL Workbench and HeidiSQL database management tools are also part of the installation. MariaDB is a MySQL-based community-developed database system released under the GNU GPL. MySQL is a popular and widely used database system created by the Swedish company MySQL AB, now owned and operated by Oracle Corporation. Native support for MySQL and MariaDB in the Reliance 4 SCADA/HMI systemīeginning 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |