ZEPL supports JDBC interpreter with drivers for popular databases. Before connecting to your database, it's important to check the following:
First, you'll need to create an intepreter to provide database connection information.
Use the Test connection button to test the connection.
Once you have created the JDBC interpreter, you can use it in your notebook by providing the
%[Interpreter name] directive. For example, if you have created your JDBC interpreter with name "psql", you can use
%psql in the notebook. i.e.
%psql SELECT * from my_table
ZEPL connects your database using IPs addresses above Thus it's required to setup firewall and whitelist the IP.
To connect to a database in a private network, create an SSH tunnel using the following steps:
(1) Download our public key from the popup and whitelist these IPs through your firewall.
(2) Create a user account for ZEPL
[email protected]:~$ sudo useradd zepl
(3) Since ZEPL authenticates via public key, there's no need to set a password.
Authorize the key by opening up
default.ssh.public_key (the downloaded file)
and pasting its contents into a new line in
authorized_keys file has 600 permission.
(4) In most cases the SSH Port will be 22 by default. Check the Port variable in
/etc/ssh/sshd_config to see which port is used for SSH.
[email protected]:~$ cat /etc/ssh/sshd_config | grep Port Port 22
Now you can use your newly created interpreter with your notebooks to query and process data.