Hevo can connect to your database via SSH tunnel. Let's walk through the steps to enable connection through SSH.
1. Select SSH option
While configuring Source connection, select Connect through SSH checkbox.
2. Provide SSH Server Details
Provide following information about your SSH Server:
- SSH IP - The IP address / DNS of the SSH server
- SSH Port - The port of the SSH server as seen from the public internet (default is 22)
- SSH User - The username on the SSH server (e.g. hevo)
3. Add Hevo Public keys to authorized_keys
You will have to add our public keys t file on your SSH Server to
.ssh/authorized_keys enable Hevo to authenticate via public keys.
Following are the steps required for this:
a. Copy our public keys from source configuration screen.
b. Create ssh directory in home directory if it doesn't exist and give read, write and execute permissions.
#Creates the .ssh directory:
chmod 700 ~/.ssh
authorized_keys file if it doesn't exist and give read, write permissions
#Move to the .ssh directory:
#Create the authorized_keys file:
chmod 600 authorized_keys
d. Using your favorite text editor, add/append Hevo public key to
Alternatively, you can use the following command for the same:
echo '<public_key>' ~/.ssh/authorized_keys
echo 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDyfYljMfLMVD3erbKdslUDzbEUpcxAJgH33HWPtLgVjNAEMeMb2mJe4Zt72gDZnDmO/tMxbPfjIqnR7n2Jkc4XsoS3StvwEeGQ3AuwbWo1NQaDg8P8fHOOgY6z0VglYEZHDIhnZyA/UDLWEUAmQeuZm0tgBZtj/tm+qzdftX6cKzgFNSnimTivBXVmNdHKz+42Wpc/2XRRo6DqHgWnhKR47qcsVfasLd1RdqaJ3Sn4sDDC17KQ/3AMrvF47J0RIwVue/KHdfVi0HmI2Yv4goENokSrVuus7uUPI4bT8pvfb11ugVOGXS61IPyOZYaUQW5dfb00itm9tMBUFdD/nJNL firstname.lastname@example.org' ~/.ssh/authorized_keys
Hevo will be able to connect to your database through SSH after these steps.