Connect to a MySQL server

Question

Hi,

I'm trying to connect from alteryx to an external MySQL database (I have standard information such as the number of the server, the port, username, password and the name of the database). I know that there is the possibility to do so by "input tool" and the MySQL ODBC connector, but I have no idea how to configurate it in order to read the databases.

Can anyone help?

thanks

jaredcoffin · Answer

Please refer to article response MySQL Simba Driver for connection via Input Data tool in Alteryx 2025.1.

FloraF · Answer

Here is the link from the Alteryx Help page as well :)

https://help.alteryx.com/20214/designer/mysql

Happy Solving!

FloraF · Answer

Hello :)

There are couple of steps that have to be taken to configure your connection, please see the steps below:

1) Driver is downloaded to your local machine and added to your ODBC Data Source window

* You may check that by typing "odbc data source" and clicking on App to open.

2) Click on the "Drivers" Tab to ensure that it is avaliable as one of your drivers

3) Click on "User DSN" Tab

* Click on "Add"
* Click on "My SQL ODBC"
* Finish

4) Once you click on finish, you will be directed to configure the MySQL odbc. You will need to enter your credentials and the server URL (the information you have referenced in your initial post)

5) Go back to Alteryx and Click on the InDatabase Tool to configure it. The new driver should appear on the below screen.

**If this solves the issue, please click on the like below" thank you!