Skip to content

DBeaver DB Connection and SSH Tunnel

You will have had to complete the prerequisite steps before continuing with these instructions.

  1. Click new connection and PostgresSQL in the upper right under the plug+ symbol.

    dbeaver_plug_plus.png

  2. Click on SSH tab > Check use SSH tunnel > Then click the pencil icon to edit the profiles. Then click create.

    dbeaver_ssh_profiles.png

  3. Give your profile a meaningful name and click OK.

    dbeaver_create_ssh_profile.png

  4. Check the box to Use SSH Tunnel.

    dbeaver_use_ssh_tunnel.png

  5. Enter IP address in Host/IP line - Provided by EA. The username will be tunnel-user. Port will be 22. Select Public Key as the authentication method.

    dbeaver_ssh_params.png

  6. Click the folder icon and navigate to the saved private key file created for GitHub.

    dbeaver_key_navigation.png

    NOTE: If a passphrase was used to create the SSH key, provide the passphrase in the box below the private key line. Check the "Save Password/Passphrase" box to ensure the passphrase is saved for subsequent connections.

  7. Click test connection. A successful connection should be established. If there is an error, please check your configuration and try again. Click OK after a successful test.

  8. On the main SSH tab, make sure your profile is selected.

    dbeaver_profile_selection.md

  9. Navigate back to Main tab. Host, Database, Username and Password will be provided by EA. Be sure to check box that says "Save password locally".

    dbeaver_postgres_cxn.png

  10. Test connection and click OK if it is successful. If not, please check configuration and retry. You can click OK on the Main tab once a successful test connection is established.

  11. Once a connection is created in the Database Navigator, you can rename the connection by right clicking on it and choosing Rename from the pop-up menu.

Please reach out to EA if troubleshooting help is needed.