Page History

Overview

Our software platform supports integration with MySQL via the MySQL Connector/NET or ODBC driver, allowing connectivity to the database. After installing the chosen driver, users can configure the connection in Datasets / DBs / ConnectionString.

Installation and Setup

The MySQL Integration requires the usage of either the MySQL Connector installation or the ODBC driver for MySQL.

You can download the MySQL Connector/NET here.
And alternatively, you can download the latest ODBC Driver for MySQL here.

MySQL Connection via MySQL Connector

After downloading the MySQL Connector, please follow these steps:

1. Open the MySQL Connector NET 9.2.0 installer (mysql-connector-net-9.2.0.msi).
   Image Modified

2. Choose the Destination Folder and click Next.
   Image Modified
3. Click Install and wait for the installation process to complete.
   Image Modified
4. Click Finish to complete the installation.
   Image Modified
5. After completing the installation, open the Solutions Manager and select a solution.
6. Navigate to Datasets / DBs and click on the plus icon to create a new database connection.
7. Next, choose the MySQL Data Provider from the available options.
   Image Modified
8. After creating the database connection, click on ConnectionString and fill in the required fields with the necessary parameters, such as Server, Port, Database, SslMode, and any Additional Parameters as needed.
   Image Modified

MySQL Connection through ODBC

After downloading the latest ODBC Driver for MySQL, you can follow this step-by-step to properly install and use it on the software platform.

1. Open the .msi file - It is recommended to use the .msi installer over the .bin due to how much easier it is to use such file.

2. Click “Next >”.
   Image Modified

3. Accept the terms in the license agreement: 
   Image Modified
4. Choose the complete installation: 
   Image Modified
   
   
5. Lastly, make sure you agree with the Destination Folder and click to install the driver:
   Image Modified
   
   
6. After the driver is properly installed, head over to Datasets / DBs and click to add a new database:
   Image Modified
   
   
7. Change the data provider to “Odbc Data Provider” and choose MySql Database: 
   Image Modified
   
   
8. Open the “ConnectionString” dropdown and add your server information: 
   The “Server” line is where you add your server IP;
   The Port is where you select your server port, where it usually is 3306 for MySql Servers.
   Database is where you choose which database will be retrieved from the server.
   Make sure to add your user as an Additional Parameters with the syntax “User=<UserName>”
   Image Modified
   For the Driver line (in ConnectionString): Each version of the ODBC Driver you download will have a unique driver version string. To check your installed version, follow these steps:
   Press Win + R and type “odbcad32” and head to the Drivers tab, then, you can check your full driver name:
   Image Modified
   You can type one of those two Drivers in the ConnectionString dropdown - they should both work.
   
   

9. Lastly, you can set the password in the LogonPassword column. To do that however, you need Administrator permissions, which you can get by default by logging with the username “Administrator” and no password:
   Image Modified
   Image Modified
   Finally, you can add the password as shown below and your database should be working perfectly.
   Image Modified
   This way, your connection to the MySQL database should be working fine. Now that you're successfully connected, you can start executing queries, managing your data, and optimizing your database operations.