- Applications and Dashboards
- Visualization Tools
This page describes how to set up Tableau Desktop and configure it for use with Rockset. You can integrate Tableau with Rockset to power real-time dashboards on NoSQL data.
The steps below require that you have the Rockset Java SDK jar version 0.7.0+. For instructions on building the jar, refer here. You can also download the jar (rockset-java-$version-uberjar.jar) from Maven.
Note: Make sure your Tableau Desktop installation is version 2019.2 (or later) and you have Rockset Java SDK version 0.7.0 (or later).
- Create an API Key using the Rockset Console under Manage > API Keys.
Place the Rockset Java SDK 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.
In Tableau, navigate to Connect To a Server and select
Other Databases (JDBC):
- Configure the connection as follows:
jdbc:rockset://api.usw2a1.rockset.comfor URL (or the api url for your region if not Oregon)
apikeyas Username and Rockset API Key as the password.
- Click on
Explore the schema of all Rockset collections present in your workspace:
Publishing to Tableau Server
Publish a workbook along with a data source to your Tableau server:
Serverin the Menu.
- Edit Data Sources and select
Embedded passwordfor Authentication.