1. Secure Shell (SSH) Environment (Revision #145)

Today's high-performance servers and highly-scalable databases are important both for data processing and for reporting. Most Fortune 500 companies will have 1000's of employees and 1000's of servers for their critical business initiatives. Managing 1000's of multiple remote users as well as 1000's of DB servers can be a hurdle in ensuring rapid analysis and timely reporting. AquaFold's goal is to help organizations simplify tasks and lower costs by streamlining development and production environments. The result is a combination of a complete Integrated Development Environment (IDE) for databases and a Secure Shell (SSH) Environment within a single interface in the latest release. With the release of Aqua Data Studio v10.0, companies can now replace many single purpose tools with a unified consistent interface.

What can I do with Aqua Data Studio's SSH Environment?

Connect, Visualize, Execute and Share.

• Register SSH Server connections in Aqua Data Studio v 10.0 and Connect to remote hosts with a secure interface
• Visualize and manage 1000s of terminals in multiple tabbed sessions
• Open display oriented interactive Text Editors like vi, vim, emacs
• Execute commands on remote servers. Supports common Unix file operations (chmod, chown, ln, find), Unix system status commands(last,w,who,uname), advanced process management commands (ps, ptree, top), Unix filesystems commands(fstyp,df,du), and Unix filesystem management (mount, umount, fsck, mkfs) etc.
• Share datastudio SSH Environment configurations with other users to save time
• Save your workspace; so that on restart Aqua Data Studio displays all your multiple tabbed sessions, without the need to open each individual connection

What's new?

SSH Server Menus	SSH Servers in Tabs	SSH Options and Reconnect Button	SSH Find in Buffer

Register multiple SSH Server connections in the Schema Browser: 

You can register a SSH Server just like any other DB Server connections in the application. You need to provide the authentication and host details. The connections can be customized in the Servers Browser and opened (one or several at a time) by using Shortcut Toolbar shortcuts and Shortcut Toolbar folders. The inclusion of the SSH Shell Environment allows secure command-line server and database interaction.

Connect and Connect As Options

With the Connect option you can establish a secure SSH connection with the supplied authentication information. You can use the Connect As option to SSH directly if you have many remote user logins. This prompts for the username and password.

Clone a registration

You can quickly create a clone of an already registered server using the Register SSH Server Clone option.

Session Tabs: Like Database Server Connections, SSH Connections also open in individual tabs which can be organized within Aqua Data Studio's Workspace and Docking Framework. The Docking Framework allows grouping, coloring, stacking and navigating tabbed SSH terminal windows in a workspace.  

SSH Server Workspace Tabs	SSH Server Docking Framework

Reconnect to a server

You can quickly reconnect to registered servers using the Reconnect Icon available on the toolbar.

Copy and Paste commands

Aqua Data Studio v10.0 has options in the SSH terminal for the user to copy unix commands and paste them by selecting then right-clicking or by selecting and clicking the copy and paste icons in the toolbar.

Find in Buffer

Find in Buffer allows searching and highlighting text in the current SSH connection tab. Navigating the found highlighted items can be done with Previous and Next buttons at the bottom of the SSH connection frame. This functionality is similar to the Search functions in the other Aqua Data Studio editors. It supports searching for Match Case, Whole Word and Regular Expressions.

SSH Server Find in Buffer

Font/Background Color, Tab Size (Indentation) Options

SSH Connection tab appearance can be customized by choosing a font size, tab size (indentation), foreground color, background color and the format of tab labels to visually identify SSH terminals among other opened connection tabs.

SSH Server Terminal Options	SSH Server Tab Color