Tableau is a popular visualized analytic program for data interactions. This topic describes how to configure the MaxCompute JDBC driver on Tableau to visualize MaxCompute data.

Prerequisites

  • Download and install Tableau. Click here to download Tableau. Tableau 2019.4 or later supports MaxCompute Connector.
  • Download the MaxCompute JDBC driver. Click here to download the MaxCompute JDBC driver. Download the jar-with-dependencies JAR package of Tableau 3.0.1 or later.

Procedure

  1. Place the downloaded JAR package of the MaxCompute JDBC driver to the following directory:
    • Windows: C:\Program Files\Tableau\Drivers
    • Mac: ~/Library/Tableau/Drivers
    • Linux: /opt/tableau/tableau_driver/jdbc
  2. Run Tableau DeskTop.
  3. In the left-side navigation pane, choose To Servers > Alibaba MaxCompute. If Alibaba MaxCompute does not appear in the left-side navigation pane, click More. Choose Alibaba MaxCompute in the right pane.
  4. In the dialog box that appears, Set Server, Username, and Password.
    • Server: must be in the <MaxCompute endpoint>? project=<MaxCompute project name> format.
      • <maxcompute_endpoint> is the MaxCompute endpoint of your region. For example, the public network endpoint of the China (Hangzhou) region is http://service.cn-hangzhou.maxcompute.aliyun.com/api. For more information about MaxCompute endpoints, see Configure endpoints.
      • <maxcompute_project_name> is the name of your MaxCompute project.
      Example:
      http://service.cn-hangzhou.maxcompute.aliyun.com/api?project=test_project
    • Username: the AccessKey ID of the account used to create the project.
    • Password: the AccessKey secret of the account used to create the project.
      Note Tableau 2019.4 does not support the AccessKey secret ending with an equal sign. If your AccessKey secret contains an equal sign, we recommend that you generate a new AccessKey pair.
  5. Click Log On to open the Tableau workspace.