Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio includes a 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 a 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 these 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
To Register a SSH Server :
To configure Port Forwarding :
If you face any problem during SSH Server Registration, there might be a few things which you are doing wrong :
Tip : Tick the ’Save Password’ check box and you may quickly connect to a SSH Server without having to type in the authentication every time you Open.
How to edit SSH server properties
You can change Server Properties like
To create a 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 a SSH Server
To Open a registered Server :
Once a connection succeeds, the Connection Toolbar becomes visible. It includes buttons which 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 affect immediately.
To share or copy registered server connections for use on another computer, see Configuration & Connection Files
Edit the SSH Server Properties to use Advanced Properties:
With the options in Advanced properties of a Server, you can:
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.
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.