Aqua Data Studio includes an SSH Environment - an interactive Unix-like command-line interface. SSH is used for remote login and secure communications with remote servers over unsecured networks. The SSH interface is integrated in the IDE and utilizes all Aqua Data Studio GUI capabilities such as a tabbed window interface, customized tabs, search functions, keyboard mapping, docking framework, and Shortcut Toolbar shortcuts. Advanced Server Properties also allow the use of Private Key Authentication.
Registering an SSH Server
This is very similar to how database servers are registered. Once you have installed Aqua Data Studio you will need to register your servers before you get started. There are two methods of registering ssh servers, both of which launch the Register SSH Server dialog
Both of this launch the Register SSH Server dialog, which lets you fill in the properties of the SSH server you are attempting to connect to.
The properties of any registered SSH server can be viewed and altered by right-clicking on a server in the Servers Browser and selecting "Properties."
It is possible to register servers by using a configuration copied from another user. The servers from a copied configuration will populate the Servers Browser, but passwords will have to be entered within the properties of each one. Passwords do not copy when configurations are duplicated. See the "Configuration & Connection Files" section for more information on sharing and portability of Aqua Data Studio configurations.
SSH Server Registration in Aqua Data Studio
New Server Group | Group Name | Register SSH Server | Enter Server Details | Server Registered | Open Server |
To Register a SSH Server :
To configure Port Forwarding :
Troubleshooting Registrations
User name and Password | Click on Ping |
If you face any problem during SSH Server Registration, there might be a few things that you are doing wrong :
Tip : Tick the ’Save Password’ check box and you may quickly connect to an SSH server without having to type in the authentication every time you Open.
How to edit SSH server properties
To Edit the SSH Server Properties of an already Registered SSH Server, in Aqua Data Studio :
You can change Server Properties like
How to register an SSH Server Clone
Right Click Server | Specify Name |
To create an SSH Server Clone of an already Registered Server, in Aqua Data Studio:
You can now connect to the newly registered Server.
Using Aqua Data Studio to open an SSH Server
Locate the Server | Popup | Connected |
To Open a registered Server :
SSH Connection Toolbar
Once a connection succeeds, the Connection Toolbar becomes visible. It includes buttons that allow you to Reconnect, Copy selected text, Paste text from the clipboard, Find text, and edit Options.
The Options button allows changing the Font, History Buffer Size, Tab Size as well as the Foreground, Background, and Selection Background colors. Changes made to the Options take effect immediately.
SSH Terminal Options | SSH Terminal Find in Buffer |
To share or copy registered server connections for use on another computer, see Configuration & Connection Files
Using Advanced Properties (Advanced Tab)
Edit the SSH Server Properties to use Advanced Properties:
SSH Server Right Click | SSH Server Advanced Properties |
With the options in Advanced properties of a Server, you can:
Using the Key Generator Tool to create a Public/Private Key Pair for use in Authentication
To create Keys for use in authorized_keys files, select Tools > Key Generator from the Main Application Menu. The tool allows for creating and saving both public/private key pairs using SSH-2 RSA or SSH-2 DSA with 1024 bit or 2048 bit length. By default, SSH-2 RSA is selected with 1024 bits key length.
Key Generator for Private Key Authorization |
Using the Key Agent Options to cache Private Key Passphrases in Memory
If you do not wish to store your private key passphrase to disk, enable the Key Agent within File > Options > SSH Terminal.
This allows using a private key but instead of reading the passphrase from the registered server connection properties on disk, you are prompted for the passphrase in the terminal window the very first time you connect to the server.
Once you enter the passphrase at the prompt, the passphrase is kept in application memory until Aqua Data Studio is closed. As long as you do not close Aqua Data Studio the cached passphrase will be used each time you connect to the server.
Key Agent for caching |