did you get any kind of message error?
The correct question is verify if your Tableau Server accept this connections?
Actually I'm not connecting to a Tableau Server.
I'm running Tableau Desktop and I need to set up a MySQL data sources to access tables into the mysql database.
I'm able to connect to the mysql database thru port 3306, but ultimately I will have to connect to the mysql database thru a SOCKS proxy for security reasons.
I'm looking for a post on how to set up such connection.
I don’t think Tableau Desktop application support or allow direct connection to any data sources thru a SOCKS5 protocol.
So, I went with a proxy client on my desktop that route all communications thru a SOCKS5 proxy server like Dante.
I will not go into deep details, here’s a list of steps I follow and was successful.
First I launch a small Linux server where I installed the Dante - A free SOCKS server and configured it following How to setup a Socks5 Proxy server on Ubuntu with Dante.
Then I installed Proxifier a client proxy on my Windows 10.
Then I added a Proxification rule where the tabprotosrv.exe application is allowed to route all connections to the SOCKS5 proxy server on a specific target port. I my case it’s MySQL (3306).
I also grant access from the SOCKS5 proxy server to connect to the MySQL database's instance.
The I successfully tested the MySQL connection towards the MySQL databases instance thru the SOCKS5 proxy server.
Since I couldn’t find any support for communication with the SOCKS5 protocol with the Tableau Desktop application, I think it’s the only solution.
Unfortunately the proxy client Proxifier is a paid application it’s the only reason one would not go with this type of configuration.
The Dante Proxy server is free, you still have to launch a server to host the SOCKS5 proxy server.
I hope my configuration is a good scenario.
This is actually up to the MySQL ODBC driver, so you'll get a better answer in a forum for it such as MySQL :: MySQL Forums :: Connector/ODBC . But as far as I can tell, the driver does not support SOCKS proxies.
I think I found a MySQL ODBC Driver that support proxy connections ODBC driver for MySQL and MariaDB 32/64 bit - Devart.
I looked at the https://www.devart.com/odbc/mysql/docs/tunneling.htm documentation and it sounds it's supported.
I haven't tested with Tableau Desktop.
Anyone out there who tested Tableau DeskTop with this ODBC driver or any other ODBC drivers that support proxy connection?