Zepl supports a JDBC interpreter with drivers for popular databases. Drivers for the following databases are currently supported by Zepl:
For additional database connections, please contact [email protected].
Before connecting to your database, it's important to check the following:
First you'll need to create an interpreter to provide the database connection information as follows:
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 as follows:
%psql SELECT * from my_table
Zepl connects to your database using the IP addresses below so you'll need to whitelist them in your firewall:
To connect to a database in a private network, create an SSH tunnel using the following steps:
Download our public key using the Download button and whitelist the IP addresses listed above through your firewall.
Create a user account for Zepl
[email protected]:~$ sudo useradd zepl
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
Make sure the
authorized_keys file has
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
Now you can use your newly created JDBC interpreter with your notebooks to query and process data.