Tableau is an easy-to-use tool used to analyze reports. It provides powerful functions and allows you to connect to AnalyticDB for MySQL. After you create an AnalyticDB for MySQL connection in Tableau, you can create smart views and dashboards through drag-and-drop operations or clicks.
Prerequisites
Alibaba AnalyticDB for MySQL is installed. For more information, visit Alibaba AnalyticDB for MySQL.
Tableau 9.0 or later is installed.
Use Tableau to connect to AnalyticDB for MySQL
Start Tableau and click MySQL in the left-side navigation pane to create a MySQL connection. In the MySQL dialog box that appears, configure the connection parameters.
Parameter
Description
Server
The endpoint of the AnalyticDB for MySQL cluster to which you want to connect.
Port
The port of the AnalyticDB for MySQL cluster endpoint.
User Name
The account used to connect to the AnalyticDB for MySQL cluster. You can use one of the following account types:
Privileged account
Standard account
Password
The password of the account used to connect to the AnalyticDB for MySQL cluster.
After you configure the preceding parameters, click Log In to connect to the AnalyticDB for MySQL cluster.
Use Tableau
In Tableau, you can view the databases on which you have permissions. After you select a database, you can read tables, preview data, and generate visual reports.