Skip to content

DataOS Integration with Tableau

This article will help you to set up the connection between DataOS and Tableau. It provides specific steps needed to fetch data from DataOS into Tableau.

Explore your DataOS data with Tableau

Tableau is one of the most powerful business intelligence tools which allows you to pull vast amounts of information from disparate sources, and helps you turn it into advanced visualizations. The dashboard created from these visualizations empowers you with business insights and helps in data-driven decisions.

DataOS and Tableau integration work to take advantage of that powerful visualization technology on the data pulled from DataOS.

Requirements

  • Tableau Desktop installed on your system - If Tableau is not installed on your system, you can download the latest version from the Tableau website.
  • Java installed on your system- you can download the latest version from the Latest Oracle Java.
  • Driver - In order to connect to DataOS Catalog, you would have to install the driver.
  • DataOS Wrapped Token- To authenticate and access DataOS, you need a wrapped token. This token contains the API key along with the cluster name.

Download and install the driver

Check your Tableau version and follow the steps given below:

  • Tableau: 2021.3, 2021.2.2, 2021.1.5, 2020.4.8, 2020.3.12, and above

    a. Download the driver (for example, trino-jdbc-373.jar) from the Trino page. Please note that Presto is Trino now.

    b. Copy the downloaded JAR file to the appropriate location.

    • ~/Library/Tableau/Drivers for MAC
    • C:\Program Files\Tableau\Drivers for WINDOWS

  • Tableau: 10.0-2020.2 and below.

    a. Download the driver from Tableau driver download page.

    Select the operating system and bit version according to your system configurations.


Driver download
Driver download

Click on the Download button (mac or Windows).


Driver download for Mac
Driver download for Mac

Double-click on downloaded 'Simba Presto 1.1.pkg' for mac or Windows 64-bit driver to run the installer.

Click Continue and follow the steps for a successful installation.

Generate DataOS API token

  1. Sign in to your DataOS instance with your username and password. On the DataOS home page, click on 'Profile'.


DataOS home page

  1. On the 'Profile' page, click on Tokens.


Profile
Profile

  1. Click on the Add API Key link on the Tokens tab:


API key
API key

  1. Type in the name for this token and also set the validity period of your token based on the security requirements as per your business needs. Click Save to create one for you.


Add key
Add key

  1. The API key is listed below. Click on the “eye icon” on the right side to make the full API key visible.


Key created
Key created

  1. Click on the API key to copy it. You would need this API key to create wrapped token.

Create Wrapped Token Using Terminal

  1. On CLI, use the command below to create a wrapped token. Provide the apikey token and name of the Cluster.

echo '{"token":"<apikey-token>","cluster":"<cluster-name>"}' | base64
2. For the following values of api-key and cluster-name, the command will appear as shown below:
apikey-token = abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz
cluster-name = miniature
Ensure that JSON string should not contain any spaces. 
echo '{"token":"abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz","cluster":"miniature"}' | base64
3. Upon successful execution, the output will resemble the following, creating a token.

eyJ0b2tlbiI6ImFiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6YWJjZGVmZ2hpamtsbW5vcHFyc3R1
dnd4eXoiLCAiY2x1c3RlciI6ImphcnZpc2NsdXN0ZXIifQ
4. Once the token is created then align it in a single line. You would need this token to configure the Presto driver.

eyJ0b2tlbiI6ImFiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6YWJjZGVmZ2hpamtsbW5vcHFyc3R1dnd4eXoiLCAiY2x1c3RlciI6ImphcnZpc2NsdXN0ZXIifQ

Configure driver on Tableau

You need to configure the Presto driver in the Tableau application to connect to your data in DataOS.

  1. Open the Tableau desktop application. Click on More to access the list of all the servers connectors. Search for Presto and click on it.


Server connectors
Server connectors

  1. A dialogue box appears where the user can provide the following values:
Property Value
Server e.g. tcp.reasonably-welcome-grub.dataos.io
Port 7432
Catalog e.g. icebase
Schema an optional field
Authentication LDAP
Username Username
Password Access API Key from DataOS
Require SSL Check the box


Inputs
Inputs

  1. Click Sign In.

    📌 Note: If you encounter any error in setting up the connection, please check DataOS URL, and validity of the API key and try again or contact your administrator.

Access DataOS on Tableau

  1. Once you've completed the driver configuration steps successfully, you can see the DataOS catalog in the left panel in Tableau dialog.


Tableau connected
Tableau connected

  1. To get the list of available schemas, click on Search icon. To select the relevant schema, double-click on it.


Schema
Schema

  1. To bring the data from the table, click on Search icon and you can see all the tables available in your DataOS schema cluster. Double-click to select a table that you want to retrieve data from.


Tables
Tables

  1. Click Upload Now to load the data for preview. Tableau retrieves data from the selected DataOS table and loads it into a worksheet.


Data loaded
Data loaded

  1. Now you can explore and visualize this data in Tableau.


Tableau visualization
Tableau visualization