Aqua Project Solution Examples

Below are AquaProjects which are example solutions to common database and IT related problems. Click on one to find out what it does. After downloading a solution, follow the steps listed below.

Get Started With an Example Project

Below are the steps for using a download, zipped AquaProject.

After downloading the .zip file containing the Solution Example, extract (unzip) it.
Within Aqua Data Studio’s Projects Browser, right click and select Mount Project.
Browse to the unzipped directory and select it.
Project mounts and is ready to be edited.

1. Extract the download

2. Right Click select Mount

3. Select unzipped directory to mount

Screenshot of Aqua Data Studio’s Schema Compare feature, showing a comparison of database objects between a master and slave database. The top section lists objects by type, schema, name, state (indicating differences found), and difference count. The bottom section highlights detailed DDL differences between the objects, with differences color-coded as Deleted (red), Changed (blue), or Added (green). Callouts indicate key features such as state indicators, difference counts, and HTML outputs for comparison results.

4. Project mounts, ready to be edited

"Hello World!" Project

Starter project. Demonstrates project creation, debugging and deployment techniques, basic input/output functions and GUI controls in HTML forms.

Download example file

Overview

Browser output

Database Schema and Data exporter

Exports the schema DDL and table data of a database. Creates a .ddl file for each instance of a schema object type in the database. Also creates either a csv, xml or xls file containing all table data. If generating csv or xml files, a separate file is created per table. Optionally, creates a zip, tar or gz archive containing all generated files.

Download example file

Aqua Data Studio create a server registration inside the Database exporter project. Database extracts all table data into individual files. Database exporter literates through all schema metadata and exports DDL statements.

Overview

Aqua Data Studio exports list of schema object types and folder contests showing the DDL scripts for schema Index.

Random tables and columns created

Tables populated with random data

Random table and data generation

Generates a table creation script containing varying number of tables, columns and field types and executes the script against the specified DB. Also populates the tables with random data based upon field type.

Download example file

Overview

Screenshot of Aqua Data Studio 9.0.0 displaying the executeTableGenerationScript.xjs for creating random database tables and columns. The left panel shows the project structure with a focus on the Random Database Generator and the Adventureworks 2008 database under User Tables, which includes generated tables and their columns. The main panel displays the script editor with variables defining the database, schema, and server. A callout highlights that the script executes create table statements generated by RandomTableGenerator.xjs.

Random tables and columns created

Screenshot of Aqua Data Studio displaying two tables (AQDustStorm and AQDeepPink) in the AdventureWorks 2008 database. The tables are populated with data generated by executing the RandomDataGenerator.xjs script. The upper window shows the AQDustStorm table with various columns and data, while the lower window displays the AQDeepPink table with columns like AQGold, AQLima, and more. A callout highlights that the data was populated after running the script.

Tables populated with random data

Schema Compare of many slave servers to a single master server

Iterates through each slave server and compare its schema with the master server. Any schema differences are written to disk in HTML format.

Download example file

Screenshot of Aqua Data Studio 9.0.0 displaying the master_slave_compare.xjs script for comparing master and slave database servers. The left panel lists the project structure with defined servers, including a master server and multiple slave servers. The script editor in the main panel highlights variables for folders containing master and slave server connection information, as well as the database and schema names for both master and slave. Callouts identify the master DB server connection, folders for server connection information, and the databases to be compared.

Overview

Diff output

Run multiple SQL Scripts against multiple servers

Executes the set of SQL Scripts contained in the Project’s “User Files” folder against the set of defined servers in the Project’s “Servers” folder.

Download example file

Screenshot of Aqua Data Studio 9.0.0 showing the execution of a multiserver script file (ExecuteScriptFiles.xjs). The left panel lists the set of database servers (e.g., Sybase ASE servers) and the SQL scripts to be executed against each server. The main panel displays the script editor with database and schema variables defined for execution. The bottom panel contains a sample SQL script (InsertStatements.sql) inserting data into a table. Callouts highlight the database servers, SQL scripts, database/schema name, and a sample SQL script in execution.

Overview

Screenshot of Aqua Data Studio 9.0.0 displaying a table from the AdventureWorks database being populated with data. The top panel shows the table AQDeepPink with columns and rows of data. The bottom panel shows the Multiserver Script Execute tool running an SQL script (ExecuteScriptFiles.xjs), with output indicating the status of executed SQL statements, including affected rows and execution time.

Execution Output

Encrypted backup of multiple SVN projects

Backs up a user specified set of SVN folders and stores the contents into a single AES encrypted zip file.

Download example file

Overview

Screenshot of a WinZip interface displaying an encrypted zip file named ‘svn_snapshot_encrypt.zip,’ containing two SVN backup files: ‘test-svn-Basic Javascript.zip’ and ‘test-svn-Unit Test For Applications.zip.’ The interface highlights the file names, sizes, modification dates, and compression ratios, with a note pointing out that the zip file contains SVN backups.

Encrypted Zip File Output

Financial Overlays

Overlay charts for securities price data, including Moving Average, Envelopes, Keltner Cannel, Bollinger Bands. Allow selecting securities and changing chart parameters.

Download example file

Chart showing candlestick price data with open, high, low, and close values represented for each time period. The green candlesticks indicate upward price movement, while red candlesticks signify downward movement. The x-axis represents time, and the y-axis displays price values, illustrating overall market trends.

CandleStick Plot

Chart displaying candlestick price data with multiple moving averages: MA9 (blue), MA20 (green), EMA39 (purple), and EMA100 (red). The moving averages highlight short-term and long-term trends, with the x-axis representing time and the y-axis showing price values. The chart emphasizes trend dynamics and price movement relative to these averages.

Moving Average (MA), Exponential Moving Average (EMA)

Chart showing candlestick price data with a 20-day moving average (MA20) line in blue and its corresponding MA20 envelope bands in gray. The envelope bands highlight upper and lower price thresholds around the moving average. The x-axis represents time, and the y-axis displays price values, emphasizing trends and price movement relative to the MA20.

Moving Average Envelopes

Bollinger Bands

Keltner Channel

Chart illustrating an Ichimoku Cloud indicator with high, low, open, and close prices, along with Leading Span A (green), Leading Span B (red), Baseline (blue), Conversion Line (purple), and Lagging Span (black). The x-axis represents time, and the y-axis displays price values, showcasing market trends and key support/resistance levels.

Ichimoku Clouds

Technical Indicators

Charts of widely used technical indicators for securities price data including Moving Average Convergence-Divergence, Relative Strength Index, Stochastic Oscillator, On Balance Volume and Detrended Price Oscillator. Allow selecting security and changing chart parameters.

Download example file

MACD

A screen shot of Aqua Data Studio visual analytics of a combined bar and line graph. The X-axis is months from January 20th to June 10th.

Relative Strength Index (RSI)

Aqua Data Studio screenshot showing a multiple-line graph.

Stochastic Oscillator

Aqua Data Studio screenshot of a combination graph. The black line graph represents the on balance volume. The red and green bar graph represents volume.

On Balance Volume (OBV)

An Aqua Data Studio Screenshot shows price volatility over the course of a week.

Detrended Price Oscillator (DPO)

Portfolio Management and Risk Analysis Charts

Examples of reports and charts that use and compare data of a set of securities (a portfolio), including risk analysis for a given security vs. a portfolio of securities, risk/performance analysis for different portfolios, stock prices correlation data and reports that help selecting stocks for a diversified portfolio.

Download example file

Aqua Data Studio screenshot of a line graph. The blue line represents BAC, the red line represents GOLD, and the green line represents GOOG.

Stock Volatility

Risk / Performance

Aqua Data Studio Screenshot showing Aqua Projects stock bar graph of stock holdings.

Stock Correlations

Using a custom Java library in an AquaScript

Example AquaScript which uses a custom Java library. The custom Java library can be used in Aqua Data Studio.

Download example file

Aqua Data Studio Screenshot of custom jar example copied to AquaData Studio lib directory.

Aqua Data Studio Custom Java Library Location

The Aqua Data Studio screenshot shows results generated from custom jar-example-1.0.jar located in Aqua Data Studio lib directory.

Aqua Data Studio Custom Java Library Output

Company Revenue Project: Generate Pivot Charts from HTML form input and email results as Excel

Example AquaProject that connects to a database, creates a Basic and Advanced report containing charts and pivots from the data, responds to form input, generates an Excel file of the report, and allows emailing the report as an attached Excel file through an HTML form within the report itself. Icons in the dashboard toolbar link the Basic and Advanced Report AquaScript (.xjs) files.

Download example file