Connect to MySQL

As a means of adding additional open source database options, and as an additional method of data management, Administrators have the option to integrate their SQL-based Decisions environment with a MySQL Database.

The following document demonstrates how to properly install and MySQL and how to integrate it with a pre-existing Decisions Installation.

MySQL Install

1. Install with MS SQL.  
2. Via the MySQL Product Archives, select a Product Version that is 8.0.23 or later from the respective dropdown. Then, under Operating System, select .NET & Mono, and Download the resulting ZIP Archive.
3. Extract and open the downloaded .zip file (ex: "mysql-connector-net-8.0.27-noinstall"). Within the v4.5.2 folder, locate and copy MySql.Data.dll and MySql.Web.dll.
4. Paste these files into C:\Program Files\Decisions\Decisions Server\Instances\Control\CustomReferences\.
   
5. Restart Decisions Server (or IIS App Pool).
6. Upon reconnection to the Studio, navigate to System > Integrations > Databases. Then, click CREATE CONNECTION. 
7. 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. 
8. Click TEST to confirm successful connectivity, then click OK.
9. Once the database has successfully been integrated, search and view its contents via the Query Editor.