Unable to Publish Live MySQL Connections to Tableau Online When Using SSL Encryption
Published: 20 Dec 2017
Last Modified Date: 21 Dec 2017
IssueAfter connecting live to a MySQL datasource that uses SSL encryption ('Require SSL' selected) in Tableau Desktop, the following error may occur, when publishing to Tableau Online.
"Tableau Online can't connect to the following database or publish with a live connection: <DATABASE NAME>. You might need to add Tableau Online to your data provider's authorized list using the IP address range appropriate for your site location. For details, see Keep Data Fresh in the Tableau Online help.
Or you can create an extract and set up a refresh schedule. Data will start to refresh when Tableau Online is able to access your data."
ResolutionWorking with your MySQL database administrator to ensure the MySQL user has been granted permission to connect to any host from the Tableau Online specific IP addresses or ranges, follow one of the below options.
Reconfigure the MySQL grant to use the % wildcard as the host value instead of IP addresses or ranges. This will allow the user to connect from any host.
Reconfigure the MySQL grant to explicitly allow the Tableau Online IP addresses or ranges as the host value. For more information about Tableau Online instance specific IP addresses or ranges, please see Keep Data Fresh in the Tableau Online help.
CauseThe MySQL database user has not been granted permission to connect from the Tableau Online IP Addresses or Ranges.