AquaProject 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 downloaded, 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.
unzip-download.png1. Extract the download
mount-project.png2. right click select Mount
mount-unzipped-folder.png3. Select unzipped directory to mount
mounted-project.png4. 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

helloworld-project-screenshot-overview.png

Overview

helloworld-project-screenshot-results.png

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

DBexporter_1.png

Overview

DBexporter_2.png

Schema DDL output

DBexporter_3.png

Table data output

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

Random_1.png

Overview

Random_2.png

Random tables and columns created

Random_3.png

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

MasterSlave_1.png

Overview

MasterSlave_2.png

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

MultiServerScriptExecute_1.png

Overview

MultiServerScriptExecute_2.png

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

BackupSVN_1.png

Overview

BackupSVN_2.png

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

candlestick%20plot.png

CandleStick Plot

moving%20averages.png

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

envelopes.png

Moving Average Envelopes

movingstandarddeviation.png

Bollinger Bands

keltner%20channel.png

Keltner Channel

ichimoku%20clouds.png

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.png

MACD

rsi.png

Relative Strength Index (RSI)

stochastic%20oscillator.png

Stochastic Oscillator

obv.png

On Balance Volume (OBV)

detrended%20price%20oscillator2.png

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

Analysis Charts

stock-volatility.png

Stock Volatility

individual-stock-risk-performance.png

Risk / Performance

stock-correlation.png

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

custom-jar-directory.png

Aqua Data Studio Custom Java Library Location

custom-jar-executed.png

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

company_revenue_basic_930x1034.png

Aqua Data Studio Company Revenue Basic

company_revenue_advanced_1006x1164.png

Aqua Data Studio Company Revenue Advanced

company_revenue_advanced_generate_excel_1006x1164.png

Aqua Data Studio Company Revenue Generate Excel Report

company_revenue_advanced_email_report_1006x1164.png

Aqua Data Studio Company Revenue Email Excel Report

company_revenue_advanced_xjs_1018x677.png

Aqua Data Studio Company Revenue Files Linked by Icons