Skip to main content

Integrate with Tableau

You can integrate Imply Hybrid and Imply Enterprise 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 Imply.

Prerequisites​

Before you start, ensure that you have the following:

  • Access to Imply Manager.
  • The name of the Imply cluster you want to access with Tableau.
  • Username and password of an admin Druid user. You can see Druid users in the web console.
  • 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

Create the connection string​

You use the information in Imply Manager to create the connection string necessary for Tableau to interact with Imply.

info

For Imply Enterprise, the connection string is dependent on your setup. Contact Imply support if you need help configuring your connection string.

To create a connection string for Imply Hybrid, follow these steps:

  1. In Imply Manager, click Manage next to the name of your cluster, then click the API tab.
  2. Copy the part of the JDBC connection string after jdbc:avatica:remote:url=. For example, the part of the string to copy is:
    https://imply-d31-elbexter-1wjnc17hbnlau-1914634165.us-east-1.elb.amazonaws.com:9088/druid/v2/sql/avatica/
  3. Add the following string to the end of the URL. Replace the truststore value with the path to your truststore file and 123456 with your truststore password. ;truststore=/Users/USERNAME/Documents/truststore.jks;truststore_password=123456;

The complete URL will look something like this:

https://imply-d31-elbexter-1wjnc17hbnlau-1914634165.us-east-1.elb.amazonaws.com:9088/druid/v2/sql/avatica/;truststore=/Users/username/Documents/truststore.jks;truststore_password=123456;

Integrate Imply with Tableau​

Follow these steps to integrate Imply 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 connection string.
    • Port: 9088
    • Authentication: Username and Password.
    • Username: Your Druid username.
    • Password: Your Druid password.
    • TLS: TLS Disabled. Tableau desktop connection details
  4. Click Sign In.
  5. Once Tableau connects to Imply, select druid in the Database drop-down and druid in the Schema drop-down to view your Polaris tables: Enterprise tables in Tableau

If you see the following error when trying to connect, check the connection string 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: