Connect Tableau to an AnalyticDB for MySQL cluster to build interactive dashboards and visual reports.
Prerequisites
Before you begin, install the following:
Alibaba AnalyticDB for MySQL driver. For setup instructions, see Alibaba AnalyticDB for MySQL.
Tableau 9.0 or later.
Also gather the following connection information:
The endpoint of your AnalyticDB for MySQL cluster
The port number
A username and password (privileged account or standard account)
Connect to AnalyticDB for MySQL
Start Tableau. In the left-side navigation pane, click MySQL.
In the MySQL dialog box, enter the connection details:
Server: The endpoint of your AnalyticDB for MySQL cluster.
Port: The port of your AnalyticDB for MySQL cluster.
Username: The account to connect with. AnalyticDB for MySQL supports two account types: privileged account and standard account.
Password: The password for the account.
Click Sign In.
Set up the data source
After signing in, Tableau displays the databases you have permission to access.
Select a database.
Select the tables to work with.
Drag tables onto the canvas to preview data and start building visual reports and dashboards.