- Querying Your Data
- Visualization Tools
- Tableau Integration
Tableau Integration
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.jar) from Maven.
#Introduction
Tableau Desktop is a data analysis and visualization software. Tableau Desktop uses JDBC driver to perform operations.
#Configuration
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:
- Use
jdbc:rockset://api.rs2.usw2.rockset.com
for URL - Select
PostgreSQL
as dialect. - Enter
apikey
as Username and Rockset API Key as the password. - Click on
Sign In
- Use
#Usage
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:
- Select
Publish Workbook
fromServer
in the Menu.
- Edit Data Sources and select
Published Separately
forPublish Type
andEmbedded password
for Authentication.