Connect to MySQL

This tutorial demonstrates how to connect to a MySQL database. MySQL functionality requires manual installation of the MySQL connector.

MySQL Install

1. After installing Decisions using MS SQL, visit the MySQL Product Archives page.
2. Select product version 8.0.18 or below. Versions above v8.0.18 are not supported for Decisions v6. Set the OS to .NET & Mono then click Download. An Oracle Login is not required.
   
   
3. Extract and open the downloaded .zip file.
4. Within the v4.5.2 folder, locate and copy these two files: MySql.Data.dll and MySql.Web.dll.
   
   
5. Paste these files into C:\Program Files\Decisions\Decisions Services Manager\bin\ .
   
   
6. Restart the Service Host Manager.
7. Upon reconnecting to the Studio, navigate to System > Integrations > Databases. Click CREATE CONNECTION in the top action bar.
8. In the Database Integration panel, specify a Connection Name e.g. "MySQLtest" and set the Database Type to MYSQL.
   
   Configure the connection via MYSQL Server fields or Custom Connection String.
   
   
9. Click TEST to confirm successful connectivity, then click OK.