Category Archives: SQLDeveloper

SQLDeveloper and SSH Tunnels

I saw @krisrice post this

I’ve been using SQLDeveloper for a long time now and have always setup my SSH Tunnels separately (using tools like Meerkat). So I thought I’d take a look at how easy it is to use SSH Tunnels natively with SQLDeveloper.

Turns out it’s incredible simple to configure, simply go to your database connection properties

2014-09-16_10-13-08

Notice here that my connection is to localhost (since I’ll be using an SSH tunnel to connect to the remote machine), you could alternatively use a bastion host.

Click on the Advanced button and then select the SSH tab

All you need to do is specify the hostname you want to connect to along with the username. You could specify a password when you connect, but I’m using a keyfile so that I can essentially have passwordless login.

That’s it! Now when I try to connect to the remote connection, the SSH Tunnel kicks in and I don’t need to worry about setting up an SSH Tunnel externally to SQLDeveloper. Another nice side-effect of this is if I export the connection, I can share it with someone else and don’t need to worry about telling them to setup an SSH Tunnel as that information is also embedded in the connection export file (although obviously they’d need either the password or the Key File).

Perhaps not a marquee new feature in SQLDeveloper but a very welcome one!