Connecting to Tableau Desktop

Before you begin

In order to connect to Okera's Presto endpoint via Tableau you will need to do the following:

  • Download Tableau's Presto JDBC Driver
  • Get your Okera Presto endpoint Host/Port
  • Get your authentication credentials (depending on what your cluster is setup to authenticate with this could be LDAP or JWT)
  • Verify your ODAS SSL certificate is not self-signed and that your certificate contains its root chain. For more info see here.

Install Tableau's Presto Driver

You will need to download Tableau's Presto driver. You can download it from this page. Depending on your platform, you may end up downloading the driver or an entire bundle of drivers. If you get the bundle, you only need the Simba Presto driver.

Note

On Windows you may need to configure the DSN for Tableau Presto ODBC Driver, however this should auto create..

Connect to Okera

Once you've installed the driver, open Tableau and in the Connect panel, look under the subsection To A Server for the More… option. Find Presto (listed alphabetically) and select it.

Tableau Presto Connection select

You should then see this panel:

Tableau Presto Connect Window
  • Host/Port: You will need the enter the Presto host and its port assignment (the default is 14050). You can find this in the Okera UI by clicking on the System tab. Okera System Information
  • Catalog: The catalog name is okera
  • Username/Password: Enter your username and password. Your password will either be your LDAP credentials, or your token (depending on how your Okera cluster is configured). If token, you can grab your token by clicking on user profile icon in the bottom left corner. Copy token from Okera Web UI

  • SSL: Be sure to check the Require SSL box. If your ODAS cluster uses an SSL certificate from a trusted Certificate Authority, you have what you need to connect. If you have a self-signed certificate, you’ll need to configure the Simba driver to accept self-signed certs.

Once you click Sign in you should see this view:

Tableau databases view

A Tableau schema maps to what Okera calls a database. Clicking Select Schema will open a search panel for listing database objects. You will need to click the magnifying glass icon to load the list.

Once you select a database, another dialog to search for datasets will appear.

Using self-signed certificates

Navigate to the location Tableau Desktop uses for driver configuration. On a Mac, this location takes the form /Users//Documents/My Tableau Repository/Datasources. Create a file named Presto.tdc and add the following configuration:

<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='presto' enabled='true' version='10.1'>
<vendor name='presto' />
<driver name='presto' />
<customizations>
<customization name='odbc-connect-string-extras' value='SSL=1;AllowSelfSignedServerCert=1;AllowHostNameCNMismatch=1' />
</customizations>
</connection-customization>

The properties set here will a) enable SSL; b) allow a self-signed certificate for server authentication; and c) accept a certificate if the hostname given doesn’t match the one listed in the certificate. It’s not the most secure option, but it does let you test the connection and access to ODAS data right away.

Connection error

If you hit the following connection error:

[Simba][Presto] (1020) 
Error with HTTP API at https://<server address>:8443/v1/statement:
Peer certificate cannot be authenticated with given CA certificates

it means you need need to place your root chain inside your intermediate cert file. You may need to work with IT to get your certificate file update to contain the root chain. Tableau requires the entire root chain for security reasons.