Hello,
I have been trying to connect to a MySQL database in AWS via an ODBC connection in Alteryx. I have downloaded the Alteryx Supported ODBC driver (Simba: https://alteryx.flexnetoperations.com/flexnet/operationsportal/entitledDownloadFile.action?downloadP... and configured it so that I get a successful connection. I then go to use it in an Input tool in Alteryx and i get the below error:
Error: Input Data (4): Error opening "SHOW VARIABLES LIKE 'aurora_version'": No Columns Returned.
As this is an Alteryx supported (and recommended) driver I am surprised by this, has anyone had this issue and know how to fix it please? I have managed to get the MySQL driver working: https://dev.mysql.com/downloads/connector/odbc/ (there are some residual issues with JSON Columns) but I wanted to use the Alteryx recommended one in case it performs better.
Any help is gratefully received!
Laura
Solved! Go to Solution.
Hi Laura,
I recommend that you book a session with an Alteryx database expert here:
https://community.alteryx.com/t5/Virtual-Solution-Center/tkb-p/vsc
Best regards
Phil
Great thanks for the suggestion, Ill give them a try and update here with the solution (if there is one given)
Laura
After a useful session with a support person at Alteryx he advised that the ODBC Driver MySimba is only for on-prem My SQL databases, the My SQL DB I am trying to access is in the cloud. No need to get the 'enterprise' version, just download the Driver from here: https://dev.mysql.com/downloads/connector/odbc/
Laura