Connecting to MySQL

Contents[Hide]

1. Overview

This article shows you how to use the MySQL data provider in a Dundas BI data connector. The MemSQL data provider is similar and relies on the same drivers.

Tip
You can also use ODBC or JDBC drivers to connect to MySQL.

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.

2.1. Windows

When Dundas BI is installed on a Windows server, download and install the MySQL connector for .NET for Windows.

2.2. Linux

For Dundas BI running on Linux, including Docker images and Kubernetes, the MySQL connector for .NET Core DLL needs to be installed.

Download the MySQL connector for .NET for .NET & Mono, and extract it to find MySql.Data.dll.

Find the website's App_Data folder within the Dundas BI installation folder, and create two additional subdirectories (if they do not exist) to place the DLL at this location:

/usr/share/dundas/bi/Files/{Instance Name}/www/BIWebsite/App_Data/ExtensionsLib/netcore/MySql.Data.dll

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 website to ensure the DLL is loaded.

3. Create a data connector

In the main menu on the left, choose New and Data Connector.

Set a Name and set Provider to MemSQL Database or MySQL Database as appropriate.

Connecting to MySQL
Connecting to MySQL

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.

Click Test connection to confirm your entries, then click the submit button at the bottom to create the data connector and discover the available data structures to list under it for you to use.

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri