Connect to MySQL
  • 30 Jun 2022
  • 1 Minute to read
  • Dark
    Light

Connect to MySQL

  • Dark
    Light

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.

Upgrading from v6 to v8?
Please review Upgrading Decisions (v6 to v8) for IMPORTANT CONSIDERATIONS.

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

For further information on Installation, visit the Decisions Forum.

Was this article helpful?