Page History

Aqua Data Studio includes an integrated shell named FluidShell.  FluidShell is an interactive database shell for all major database vendors which provides the combined functionality of a Unix Shell ¹ with a SQL command line ² tool.  This combination of functionality grants users the power to automate the extraction, transformation, and loading of data from within a single shell.  FluidShell includes commands that match common Unix commands and functionality similar to most Unix shells such as variable substitution, alias commands, command substitution, input/output redirection, pipelines, and command history.  FluidShell can execute SQL scripts, shell scripts, and AquaScripts to provide a diverse and flexible method to automate your daily tasks.  Automate more and do more in less time.

Learn FluidShell in 10 Minutes : Quick Tutorial

Automate Database Tasks with FluidShell

FluidShell includes a complete set of commands for quickly scripting and executing custom solutions for data mining, ETL operations, database/file system data exchange, data warehousing, and other data processing tasks. FluidShell provides several popular Unix-like commands and includes a large number of commands for shell terminal, database access, data manipulation, filesystem navigation, file and data archiving, network operations, and general utilities. See the complete list of FluidShell Commands.

Example: Extract Data from Oracle and Load into SQL Server

...

FluidShell includes commands which can be executed from the shell's command line.  The commands provide a variety of functionality that are common to Unix shells and/or SQL shells.  FluidShell includes a large number of commands for a shell terminal, database access, data manipulation, filesystem navigation, file and data archiving, network operations, and general utilities. See the complete list of FluidShell Commands.

FluidShell presents users a smooth combined interface of the SQL command line and Unix command line by providing a highly configurable command-line interpreter ⁶ which can be customized with shell variables or with the [cli] command.  The [cli] command provides an easy way to change between a "SQL", "shell" or "fluid" command-line interface (CLI).  The "fluid" CLI is configured to automatically determine whether the user is entering a shell command or a SQL command.  If a SQL command is entered, the shell will add it to the SQL buffer while if it is a shell command, FluidShell will execute the command.  To execute the SQL Buffer on the current connection a user may use the go command.

...