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
-
Configure the TIBCO ComputeDB cluster with security enabled.
-
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.
-
-
Download and extract the contents of the Zeppelin binary package.
-
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
-
Log on to Zeppelin from your web browser and select Interpreter from the Settings option.
-
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 -
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. -
If required, edit other properties, and then click Save to apply your changes.
See also