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

[jaredcoffin]

This may not address the initial question but Simba ODBC driver is the only one that works with Alteryx 2025.1. First ODBC is set up like:

No other tabs need data but the Connection tab. If an error occurs about Auth method of "Caching SHA2 Authentication" then in PHPMyAdmin it can be switched to "Native MySQL Authentication".

Or by command line at MySQL> 

ALTER USER 'nativeuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Final error in Alteryx was a Truststore error as:

ERROR 7804 Connection::SQLDriverConnectW: [Simba][MySQL] (82) TrustStore error: Certificate Chain error status : 32; Certificate Chain info status : 256

Somehow menu item Options -> Advanced Options -> Manage In-DB Connections seemed to alleviate this Truststore error and now getting MySQL results. From now on just entering credentials with the Set Up a Connection button for the Input Data tool works.