Tableau Online Amazon RDS-Hosted MySQL Refresh Extracts Error

Issue

Scheduled extract refresh for an Amazon RDS-Hosted MySQL fail with the error:

com.tableausoftware.nativeapi.dll.DataSourceException: IPC_NamedPipe::Select(WaitForMultipleObjects): Timeout
Unable to connect to the server "<server name>". Check that the server is running and that you have access privileges to the requested database.

Connectionless Failure

Environment

Tableau Online
MySQL hosted on Amazon RDS

Resolution

Carry out the following procedure:

Sign in to your Tableau Online site in a web browser.
Determine the host name for your Tableau Online site by looking at the URL displayed in the address bar of the web browser.
Refer to the Tableau Online IP addresses for data provider authorization for the IP range used by your Tableau Online host instance.
Add an access rule in Amazon RDS to allow access from the IP range.

Cause

The IP address range used by the instance of Tableau Online that hosts your Tableau Online site needs to be added to the authorized list for your Amazon RDS database instance.