Connecting to MySQL
This article provides details on using the MySQL data provider in a Dundas BI data connector. The MemSQL data provider is similar and relies on the same drivers.
Main article: Connect to data and view it on a dashboard
2. Install the driver
The MySQL and MemSQL data providers require drivers to be installed on the server that runs Dundas BI.
If you are using multiple servers to run Dundas BI, this is needed for each server installation.
When Dundas BI is installed on a Windows server, download and install the MySQL connector for .NET for Windows on the server.
For Dundas BI installations on Linux, including Docker images and Kubernetes, download MySQL connector for .NET for .NET & Mono, and extract it to find MySql.Data.dll.
Find the App_Data folder within your Dundas BI installation's folder, create two additional subdirectories ExtensionsLib/netcore/ (if they do not exist), and place the DLL within netcore. This would place the DLL at this location for an installed Dundas BI instance:
Ensure the permissions allow the dundasbi group to read and execute the new file (e.g., chgrp dundasbi MySql.Data.dll and chmod 751 MySql.Data.dll), and restart the Dundas BI service to ensure the DLL is loaded: for a Dundas BI instance, restart the website service.
3. Data connector settings
Create a new data connector and set Data Provider to MemSQL Database or MySQL Database as appropriate.
Set the remaining fields for the server, credentials, and database, and click to access additional options if needed from the expandable sections below. To see a description, hover over (or long-tap) one of the fields.