Connect to MySQL
- 07 Feb 2023
- 1 Minute to read
-
Print
-
DarkLight
Connect to MySQL
- Updated on 07 Feb 2023
- 1 Minute to read
-
Print
-
DarkLight
As a means of adding additional open-source database options and as an additional data management method, administrators can integrate their SQL-based Decisions environment with a MySQL Database.
The following document demonstrates how to properly install MySQL and integrate it with a pre-existing Decisions Installation.
Upgrading from v6 to v8?
Please review Upgrading Decisions (v6 to v8) for IMPORTANT CONSIDERATIONS.
MySQL Install
- Install with MySQL.
- Via the MySQL Product Archives, select a Product Version 8.0.32 or later from the respective drop-down. Then, select .NET & Mono under Operating System, and Download the resulting ZIP Archive.
- Extract and open the downloaded .zip file (ex: "mysql-connector-net-8.0.32-noinstall"). Open folder
net6.0
. CopyMySql.Data.dll
andGoogle.Protobuf.dll
. - Paste these files into
C:\Program Files\Decisions\Decisions Server\Instances\Control\CustomReferences\
. - Restart the Decisions Server (or IIS App Pool).
- Upon reconnection to the Studio, navigate to System > Integrations > Databases. Then, click CREATE CONNECTION.
- In the Database Integration window, specify a Connection Name (ex: "MySQLtest") and set the Database Type to MYSQL. Then configure the MYSQL SERVER settings, or define a Custom Connection String.
- Click TEST to confirm successful connectivity, then click OK.
- Once the database has been integrated, search and view its contents via the Query Editor.
For further information on Installation, visit the Decisions Forum.
Was this article helpful?