StarRocks | Tableau Exchange

StarRocks

by CelerData Inc

Description

The Starrocks Tableau connector enables seamless and secure integration between Tableau and Starrocks. It provides efficient lakehouse query capabilities, empowering you to leverage Tableau's powerful visualization and analytics features.

Installation

Tableau Desktop

  1. Download the Starrocks JDBC Driver mysql-connector-j-8.4.0.jar, and place to:
    1. macOS: ~/Library/Tableau/Drivers
    2. Windows: C:\Program Files\Tableau\Drivers
    3. You need to create the folder if it doesn't already exist
  2. Download the latest starrocks-connector-jdbc.taco
    1. macOS: ~/Documents/My Tableau Repository/Connectors
    2. Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
  3. Restart Tableau Desktop
  4. In Tableau Desktop: ConnectTo a ServerStarrocks JDBC by Celerdata

Tableau Server

  1. Download the Starrocks JDBC Driver mysql-connector-j-8.4.0.jar, and place to:
    1. Linux: /opt/tableau/tableau_driver/jdbc
    2. Windows: C:\Program Files\Tableau\Drivers
    3. You need to create the directory if it doesn't already exist
    4. For Linux: make sure directory is readable by the "tableau" user. To do this:
      • Create the directory:
      • sudo mkdir -p /opt/tableau/tableau_driver/jdbc
      • Copy the downloaded driver file to the location, replacing [/path/to/file] with the path and [driver file name] with the name of the driver you downloaded:
      • sudo cp [/path/to/file/][driver file name].jar /opt/tableau/tableau_driver/jdbc
      • Set permissions so the file is readable by the "tableau" user, replacing [driver file name] with the name of the driver you downloaded:
      • sudo chmod 755 /opt/tableau/tableau_driver/jdbc/[driver file name].jar
  2. Download the latest starrocks-connector-jdbc.taco and place it into these folders on each node:
    1. Linux: /opt/tableau/connectors
    2. Windows: C:\Program Files\Tableau\Connectors
  3. Restart the server.
     tsm restart

Tech Specifications

Version
1.1.0
Works with
Tableau 2020.4 and later

Resources