How to Configure Apache Zeppelin to Securely and Concurrently access the TIBCO ComputeDB Cluster

Multiple users can concurrently access a secure TIBCO ComputeDB cluster by configuring the JDBC interpreter setting in Apache Zeppelin. The JDBC interpreter allows you to create a JDBC connection to a TIBCO ComputeDB cluster.

Note

  • Currently, only the %jdbc interpreter is supported with a secure TIBCO ComputeDB cluster.

  • Each user accessing the secure TIBCO ComputeDB cluster should configure the %jdbc interpreter in Apache Zeppelin as described in this section.

Step 1: Download, Install and Configure TIBCO ComputeDB

  1. Download and install TIBCO ComputeDB Enterprise Edition

  2. Configure the TIBCO ComputeDB cluster with security enabled.

  3. Start the TIBCO ComputeDB cluster.

    • Create a table and load data.

    • Grant the required permissions for the users accessing the table.

      For example:

      snappy> GRANT SELECT ON Table airline TO user2;
      snappy> GRANT INSERT ON Table airline TO user3;
      snappy> GRANT UPDATE ON Table airline TO user4;
      

    Note

    User requiring INSERT, UPDATE or DELETE permissions also require explicit SELECT permission on a table.

  4. Download and extract the contents of the Zeppelin binary package.

  5. Start the Zeppelin daemon using the command:
    ./bin/zeppelin-daemon.sh start

Configure the JDBC Interpreter

Log on to Zeppelin from your web browser and configure the JDBC Interpreter.

    Zeppelin web server is started on port 8080
    http://<IP address>:8080/#/

Configure the Interpreter

  1. Log on to Zeppelin from your web browser and select Interpreter from the Settings option.

  2. Edit the existing %jdbc interpreter and configure the interpreter properties. The table lists the properties required for TIBCO ComputeDB:

    Property Value Description
    default.url jdbc:snappydata://localhost:1527/ Specify the JDBC URL for TIBCO ComputeDB cluster in the format jdbc:snappydata://<locator_hostname>:1527
    default.driver io.snappydata.jdbc.ClientDriver Specify the JDBC driver for TIBCO ComputeDB
    default.password The JDBC user password
    default.user The JDBC username
  3. Dependency settings
    Since Zeppelin includes only PostgreSQL driver jar by default, you need to add the Client (JDBC) JAR file path for TIBCO ComputeDB. The TIBCO ComputeDB Client (JDBC) JAR file (snappydata-jdbc_2.11-1.2.0.jar) is available on the release page.
    The TIBCO ComputeDB Client (JDBC) JAR file can also be placed under /interpreter/jdbc before starting Zeppelin instead of providing it in the dependency setting.

  4. If required, edit other properties, and then click Save to apply your changes.

See also