Connect to a MySQL server

[Intwig]

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

[Kaustubh17]

Hi @Intwig 

First off all you have to install odbc driver on your alteryx designer machine.

https://dev.mysql.com/downloads/connector/odbc/

You can download the driver from the above link.

Then in  alteryx designer follow the below steps 

• Open designer
• Drag the input tool
• Select ODBC in mysql server.
• Then provide the proper credentials for connecting alteryx with mysql server.

Please find the below article for your reference.

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

If this article helps you please select as selected answer to help other on same issue in the alteryx community.

Regards,

Kaustubh

[Intwig]

Hi @Kaustubh17 

thanks for the reply. That is exactly what I did but then Alteryx ask me to set up a DSN and I have no idea how to do so...

the only info that I have are the ones on top

thanks again

[FloraF]

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

1. Click on "Add"
2. Click on "My SQL ODBC"
3. 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!

[FloraF]

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

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

Happy Solving!