MySQL Simba Driver

[LauraMendes]

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

[PhilippK · Accepted 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

[LauraMendes]

Great thanks for the suggestion, Ill give them a try and update here with the solution (if there is one given)

Laura

[LauraMendes]

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