SQL Clients > Tableau

Tableau

This page describes how to set up Tableau Desktop and configure it for use with Rockset.

The steps below require that you have a Rockset account and have the Rockset Java Client jar. For instructions on building the jar, refer here. You can also download the jar (rockset-java-$version.jar) from Maven.

Introduction

Tableau Desktop is a data analysis and visualization software. Tableau Desktop uses JDBC driver to perform operations. JDBC support is available in Tableau Desktop version 2019.1 (or later) and Rockset Java Client version 0.5.11 (or later).

Configuration

  1. Create an API Key using the Rockset Console under Manage > API Keys.

Rockset API Keys

  1. Place the Rockset Java Client jar in the following folder depending on the operating system:

    • Windows: C:\Program Files\Tableau\Drivers
    • Mac: ~/Library/Tableau/Drivers

    Refer to Tableau Documentation for more detailed instructions.

  2. In Tableau, navigate to Connect To a Server and select Other Databases (JDBC):

Tableau Connect
  1. Configure the connection as follows:
    • Use jdbc:rockset://api.rs2.usw2.rockset.com for URL
    • Enter apikey as Username and Rockset API Key as the password.
    • Click on Sign In
Tableau Rockset Information

Usage

Explore the schema of all Rockset collections present in your workspace:

Tableau Explore