Using Tableau to Access HetuEngine

Prerequisites

• Tableau has been installed.
• The JDBC JAR file has been obtained. For details, see 1.
• A human-machine user has been created in the cluster. For details about how to create a user, see Creating a HetuEngine User.

Procedure

1. Place the obtained JAR file to the Tableau installation directory, for example, C:\Program Files\Tableau\Drivers.
2. Open Tableau, select Other databases (JDBC), enter the URL and the username and password of the created human-machine user, and click Sign In.

   

   URL format:

   jdbc:presto://<HSBrokerIP1:port1>,<HSBrokerIP2:port2>,<HSBrokerIP3:port3>/hive/default?serviceDiscoveryMode=hsbroker

   Example:

   jdbc:presto://192.168.8.37:29860,192.168.8.38:29860,192.168.8.39:29860/hive/default?serviceDiscoveryMode=hsbroker

   Obtain the HSBroker node and port number:

   1. Log in to FusionInsight Manager.
   2. Choose Cluster > Services > HetuEngine > Role > HSBroker to obtain the service IP addresses of all HSBroker instances.
   3. Choose Cluster > Services > HetuEngine > Configurations > All Configurations and search for server.port on the right to obtain the port number of HSBroker.
      

      • You can select one or more normal brokers for the HSBroker node and port number.
      • If the connection fails, disable the proxy and try again.

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