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 1 with a SQL command line 2 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
Example: Extract Data from Oracle and Export to Excel
Schedule Scripts for Automation
FluidShell scripts may be executed from the Operating System terminal without launching the Aqua Data Studio GUI. This allows scheduling their execution from an Operating System scheduler such as a Unix cron 3 job or with Windows Task Scheduler 4. There are two files in the root install directory called "runfluidscript.sh/bat" and "runfluidscript-bundled.sh/bat" which allow you to execute FluidShell scripts from the command line.
Technical Overview
...
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 6 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.
...