Skip to main content

Integrate with Tableau

You can integrate Imply Polaris with Tableau using the Imply Tableau connector. The connector adds the ability to use Tableau Desktop or Tableau Server to query and visualize data stored in Polaris.

Prerequisites​

Before you start, ensure that you have the following:

  • A Polaris API key with the AccessQueries permission. See API key authentication to obtain an API key and assign permissions. Visit Permissions reference for more information on permissions.

  • The ID of the Polaris project you want to access with Tableau.

  • Access to Tableau Desktop or Tableau Server. Note that the instructions in this guide relate to Tableau Desktop. You can't use the Imply Tableau connector with Tableau Cloud.

info

The screen captures and instructions in this guide show the configuration for Tableau Desktop 2024.3. They may not reflect the current state of the product.

Install the driver and connector​

Follow these steps to install the JDBC driver and Tableau connector:

  1. Download the Avatica JDBC driver available from Imply.
  2. Place the JAR file in the appropriate folder for your software and operating system:
    • Tableau Desktop, macOS: ~/Library/Tableau/Drivers
    • Tableau Desktop, Windows: C:\Program Files\Tableau\Drivers
    • Tableau Server, Linux: /opt/tableau/tableau_driver/jdbc/
    • Tableau Server, Windows: C:\Program Files\Tableau\Drivers
  3. Download the Tableau connector file druid_jdbc-v0.0.1.taco.
  4. Place the TACO file into the appropriate folder for your software and operating system. Replace USERNAME with your OS username:
    • Tableau Desktop, macOS: /Users/USERNAME/Documents/My Tableau Repository/Connectors
    • Tableau Desktop, Windows: C:\Users\USERNAME\Documents\My Tableau Repository\Connectors
    • Tableau Server, Linux: /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors
    • Tableau Server, Windows: C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors

Integrate Polaris with Tableau​

Follow these steps to integrate Polaris with Tableau Desktop. If you're using Tableau Server, configure a connection with the same details.

  1. Launch Tableau Desktop.
  2. In the Connect pane, display the server connection options and click Druid Connector by Imply.
  3. Provide the following connection details:
    • Server/Project Id: Your Polaris URL in the following format. Note that transparent_reconnection=true enables silent reconnect in the case of a dropped connection.
      https://PROJECT_ID.jdbc.REGION.CLOUD_PROVIDER.api.imply.io;transparent_reconnection=true
      For example:
      https://f683410c-0935-4d2a-ab74-9a584f2727b7.jdbc.us-east-1.aws.api.docs.imply.io;transparent_reconnection=true
    • Port: 443
    • Authentication: Username and Password.
    • Username: Your Polaris API key name, for example docs-tableau.
    • Password: Your Polaris API key.
    • TLS: TLS Disabled. Tableau desktop connection details
  4. Click Sign In.
  5. Once Tableau connects to Polaris, select druid in the Database drop-down and druid in the Schema drop-down to view your Polaris tables: Polaris tables in Tableau

If you see the following error when trying to connect, check the URL in the Server/Project Id field and make sure the Avatica JDBC driver is in the right location.

An error occurred while communicating with the Druid Connector by Imply data source 'Untitled Data Source'. The drivers required to connect to the data source are not installed.

Learn more​

See the following topics for more information: