Connect Dataiku to Zetaris

Installation and Configuration of Zetaris JDBC driver on Dataiku Data Studio

Installing Zetaris JDBC Driver

The driver is a single JAR file.  It is located in the installation directory


It can also be downloaded from the following link.

Download and Install JDBC Driver

Installation of JDBC drivers must be done while Data Science Studio is stopped.

DATA_DIR refers to the data directory of your Data Science Studio installation.

ZETARIS_DIR refers to the installation directory of the Zetaris installation

  1. Stop Data Science Studio
    DATA_DIR/bin/dss stop
  2. Obtain the JDBC Driver

    For Zetaris Enterprise the JDBC driver can be found in the following directory:
  3. Copy Zetaris JDBC driver to the following directory:
  4. Start Data Science Studio
    DATA_DIR/bin/dss start

Connect to Zetaris

  1. Login to Data Science Studio
    http://<your server address>:11000
  2. Go to the Administration > Connection page

  3. Click “New connection” and select Other SQL databases
    Screen Shot 2022-06-29 at 9.36.05 am

  4.  Enter the following connection information:

    Connection Name Zetaris
    JDBC Driver class com.zetaris.lightning.jdbc.LightningDriver
    JDBC Url jdbc:zetaris:lightning@[host]:[port]
    User Zetaris username
    Password Zetaris password
    SQL Dialect Hive
  5. Click Test to validate your connection
    Screen Shot 2022-06-29 at 12.23.22 pm
    Dataiku will attempt to connect to the database, and provide feedback on whether the attempt was successful.

    You should receive a confirmation that the connection was successful
    Screen Shot 2022-06-29 at 12.25.07 pm

  6. Click Save to save your connection