I'm using Mac, and I want to schedule tableau daily refresh, but my Database is accessed via SSH tunnel which gets me an access to MySQL Database hosted in AWS
Any solutions over it would be appreciated. Many Thanks
Can anyone give me detailed steps to do so, cause I am not so acquainted with using Tableau.
@Gaurav Sahani
Hi, you would need to configure the SSH tunnel in the Tableau Server machine, and it should work. Make sure the local port you use for the SSH tunnel is not being used. in Tableau Server.
tsm topology list-ports
If you have several nodes, you may need to open the ssh tunnel on each node
And also, make sure you have configured correctly the mysql driver on all nodes:
https://www.tableau.com/support/drivers
You can test the mysql driver connecting to the Rfam database (password is empty)
https://docs.rfam.org/en/latest/database.html
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
