Using Tableau to Access HetuEngine

Prerequisites

• Tableau Desktop has been installed.
• The JDBC JAR file has been obtained. For details, see 1.
• A human-machine user, for example, hetu_user, has been created in the cluster. For details, see Creating a HetuEngine User. For clusters with Ranger authentication enabled, the Ranger permission must be added to user hetu_user based on service requirements. For details, see Adding a Ranger Access Permission Policy for HetuEngine.
• A compute instance has been created and is running properly. For details, see Creating a HetuEngine Compute Instance.

Procedure

1. Place the obtained JAR file to the Tableau installation directory, for example, C:\Program Files\Tableau\Drivers.
2. Open Tableau, choose To a Server > Other Databases (JDBC), enter the URL and the username and password of the created human-machine user, and click Sign In. HetuEngine is accessible either in the HSFabric or HSBroker mode. For details about the URL format, see Table 1.
   Figure 1 Entering connection information
   

3. After the login is successful, drag the data table to be operated to the operation window on the right and refresh data.