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.
- 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.
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. For more information about how to use Tableau, visit the Tableau official website.