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

      Connect Apache Zeppelin to Zetaris

      This article covers configuring Apache Zeppelin to connect to Zetaris.

      Introduction

      Apache Zeppelin supports JDBC drivers to connect to data sources.  Zetaris provides its JDBC driver as a single jar file, which will be used to connect Apache Zeppelin to Zetaris.

      Configure JDBC Driver

      1. Download the Zetaris JDBC driver
        For Zetaris Enterprise it is located in the installation directory: 
        ZETARIS_DIR/jdbc-driver/
      2. To install the driver, copy the Zetaris JDBC driver to a directory on your Zeppelin installation.

      Determine Zetaris JDBC Connection Information

      The JDBC URL for Zetaris Enterprise has the following format:

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

      Note - default port is 10000

      Connect to Zetaris

      1. Start Zeppelin.
      2. Login to Zetaris http://<hostname>:8080
      3. Click on your username from the navigation bar and click on the option Interpreter.
        Screen Shot 2022-07-11 at 3.33.02 pm
      4. Click the Create button.
        Screen Shot 2022-07-11 at 3.40.52 pm

      5. Specify the following values:
        Interpreter Name: Zetaris
        Interpreter group: jdbc

        For properties, specify the following:
        default.driver: com.zetaris.lightning.jdbc.LightningDriver
        default.url: jdbc:zetaris:lightning@[host]:[port]
        default.user: your Zetaris username
        default.password: your Zetaris password

        Under Dependencies->Artifact specify the full path to your Zetaris jdbc driver, similar to:
        /<jdbc_path>/ndp-jdbc-driver-2.1.0.10-driver.jar
      6. Click Save.