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
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
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
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
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
2) Click on the "Drivers" Tab to ensure that it is avaliable as one of your drivers
3) Click on "User DSN" Tab
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!
Here is the link from the Alteryx Help page as well :)
https://help.alteryx.com/20214/designer/mysql
Happy Solving!