Access via JDBC
      Back to home
      1. Zetaris Support - Knowledge Base
      2. Connecting to Zetaris
      3. Access via JDBC

      Connect Tableau to Zetaris

      This article covers configuring Tableau to connect to Zetaris.

      Introduction

      Tableau supports JDBC drivers for several connectors including named connectors and other JDBC-based drivers, referred to as Other Databases (JDBC) in the tool.

      Configure JDBC Driver

      1. Download the Zetaris JDBC driver
        For Zetaris Enterprise it is located in the installation directory: 
        ZETARIS_DIR/jdbc-driver/
      2. Close Tableau
      3. Place the .jar file in the folder for your operating system: 
        1. Windows: C:\Program Files\Tableau\Drivers
        2. Mac: /Library/JDBC or ~/Library/JDBC
        3. Linux: /opt/tableau/tableau_driver/jdbc

      Determine Zetaris JDBC Connection Information

      The JDBC URL for Zetaris has a different format depending on your Zetaris deployment.  

      For Zetaris Enterprise it will be in the format:

      jdbc:zetaris:lightning@[host]:[port]

      Note - default port is 10000

      Connect to Zetaris

      1. Open Tableau
      2. Under Connect, select Other Databases (JDBC). 
        Screen Shot 2022-07-08 at 3.24.44 pm
      3. Specify the following values:
        URL: Zetaris JDBC URL
        Dialect: PostgreSQL
        Username: your user name
        Password: your password
      4. Click Sign in.