KNOWLEDGE BASE

Error: "Unable to connect to the ODBC Data Source" Rendering Live MySQL View on Tableau Cloud


Published: 05 Mar 2015
Last Modified Date: 08 Jun 2022

Issue

When attempting to render view with a live connection to MySQL published to Tableau Cloud, the following error might occur:
 
TableauException: Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid. [MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server on '<IP>' (10060) Unable to connect to the server "<IP>". Check that the server is running and that you have access privileges to the requested database. 
 

Environment

  • Tableau Cloud
  • MySQL
  • Amazon RDS

Resolution

  1. Add Tableau Cloud to your data provider’s list of approved IP addresses. For more information, see Tableau Cloud IP addresses under Keep Data Fresh.
  2. Work with your database administrator to confirm that remote access is enabled in MySQL.

Cause

Either the IP address used by Tableau Cloud is blocked, or the database does not allow remote access.

 
Did this article resolve the issue?