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

ZETARIS_DIR/jdbc-driver/

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.

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:
   

   ZETARIS_DIR/jdbc-driver/

3. Copy Zetaris JDBC driver to the following directory:

   DATA_DIR/lib/jdbc

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
   

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
   
   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
   

6. Click Save to save your connection