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).
   

2. Choose the Destination Folder and click Next.
   
3. Click Install and wait for the installation process to complete.
   
4. Click Finish to complete the installation.
   
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.
   
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.
   

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.

...