Brand

Aqua Data Server Features

Collaborate to Create and Deploy Custom ETL Tasks and Business Intelligence Reports

  • Add Connections
  • Share Status and Links
  • Create Public and Private Projects
  • Create AquaScripts
  • Execute, Edit and Schedule them to run queries on database servers in the Servers tab
  • Works with all major RDBMSes
  • Run scripts to migrate to/from different database vendors
  • Deploy projects from Aqua Data Studio
  • Schedule your AquaScripts
  • Automate database imports/exports and ETL to run at specific times
  • Generate daily/monthly/weekly BI reports

Aqua Data Server Projects

+ Social Enterprise

Integrated social collaborative tools with a complete range of Data Warehousing, ETL and Reporting Applications to ensure that organizations achieve maximum productivity and deliver high quality products.

+ Organize Tasks

Projects allow you to manage your team and organize your reporting workflows into Workspace, Query, AquaScripts, Servers, User Files and Scheduled Jobs.

+ Create and Manage Projects

You can create and organize Private and Public Projects from the new enhanced home page. All data in a private project is private and you control who can see what. All data in a Public project is viewable by anyone. Create and Manage Projects

+ Workspace

Write an AquaScript and select its output to be executed and displayed in the Workspace tab of a project. You can choose the output of any of your AquaScripts to be displayed from the Project Settings options.
Project Workspace

+ Explore Public Projects

You can explore the Public repository of projects, select any project and view its Workspace. Explore Public Projects

+ Building blocks of Projects

A project contains a set of AquaScripts, Servers and User Files. AquaScripts contain the source code and logic of the software solution, servers are registration parameters for database servers and User Files are a set of files which are used by the logic of the software solution for configuration or file output. Within the project, jobs may be scheduled for executing AquaScripts at defined intervals. Each project has a defined set of users, roles and permissions to control the access of the software logic.

+ Aqua Open API

The basic building block of Aqua Data Server is AquaScripts - a JavaScript based programming language which uses Aqua Open API library methods.The framework includes a web server, an AquaScripts Editor, script scheduler and a security layer to define user access control, permissions and roles. Custom solutions built with Aqua Open APIs and AquaScripts are deployed in the form of Aqua Projects on the server.

+ Project Owner

A Project Owner is the person who created the project and has full privileges to manage the project. Project Owners can transfer ownership to any other member in the project. Server Admins can assign the Project Owner role to existing users so they can access the "New Public Project" and "New Private Project" buttons.

+ Project Membership

Project Owner will invite other users to his project. Project Owner can assign team members different roles in the project - Developer, Project Administrator, QA Engineer, Technical Writer and User.

+ Role Based Security Model

Each user in a Project is associated with a role. All access permissions and other Project settings are assigned to roles.
Role Based Security

Aqua Data Server Workflow

▸ After the installation, an Aqua Data Server Adminstrator creates your account and gives you a server role with appropriate permissions.

▸ Login to Aqua Data Server, edit your profile, add a photo, experience, education and skills. Create your Project.

▸ Add existing Aqua Data Server users to your project and assign them Project Roles like User, Developer, Administrator etc.
Assign Project Roles

▸ Write AquaScripts using Open API methods, create new server registrations, execute queries.

▸ Import Projects, AquaScripts, Servers or User Files one at a time. Deploy an entire Project from Aqua Data Studio.
Deploy from Aqua Data Studio

▸ Schedule AquaScripts to automate your database and reporting tasks.

▸ Communicate with Team Members in the Network Activity Feed. Add connections, share your current status and links.

▸ Explore Public Projects, set AquaScripts for Project Workspace.


Query

+ Execute SQL Queries

As part of developing your project solution, you might want to execute some database (DB) queries from your AquaScripts. The Query tab provides a convenient mechanism for ensuring proper DB connectivity and entering, editing and executing queries for debugging purposes. Execute SQL Queries

+ Register RDBMS Server

Prior to using the Query tab, you must register your DB servers in the Servers tab.

+ View SQL Query output

When a query is executed, its results appear directly below the Query editing area within a grid layout.

+ Syntax Highlighting

Choose to view or hide syntax highlighting.

+ Find and Replace

As you would expect from a text editor, you can perform Find, Find Next, Replace, Replace All and even use Regular Expressions for complex text replacement options.

+ Full Screen Capability

Need more room to look at a larger query? Using the Full Screen mode you can have as much space as you need to examine your query.

+ Change Database Context

You can change the database context of your query and execute the query again.
Change Database Context

+ Messages and Warnings

If there are problems executing your query, any warnings or errors get displayed to help you debug. Successful executions provide messages on execution duration, time and the number of rows affected.
Messages and Warnings

+ Max Results

Adjust how large your resultset is with Max Results, limiting what gets displayed in the results area. Max Results

+ Results Row Highlighting

Once results are displayed for your SQL query, mouse hovering over a row highlights it. Rows are numbered and presented in alternating colors to make them easier to read. Results Row Highlighting

+ Line and Character Position

Cursor Line and Character position get updated at the bottom of the query editor window as you type. The total number of lines and characters is also visible.

+ Multiple Statements Support

If you have multiple statements separated by GO or /, the results get displayed separately below the query editor area. Multiple Statements Support


AquaScripts

+ AquaScripts Tab

To create software solutions, you will be developing AquaScripts that address your business needs. The AquaScripts tab provides you the ability to create, edit and execute your AquaScripts.
AquaScripts Tab

+ Write AquaScripts

Using the javascript programming language, and AquaFold's Aqua OpenAPIs, write scripts that access database content, read and import data from text files, export database contents and much more.

+ Open API Documentation

The full documentation of Open APIs is available with a single click at the top of the AquaScript Editor.
Open API Documentation

+ AquaScripts Editor

The AquaScripts Editor provides an easy interface to view and navigate your AquaScript code, make minor code modifications and enable limited script debugging.

+ Panes of Editor

AquaScript Editor provides three panes: “AquaScript” editor for entering and editing AquaScript code, the "Results" pane which shows output created from the aqua.response.write API (this is also what is shown in the project's workspace) and the “Console Output” pane which shows messages that are sent to the console - typically output of aqua.console API methods.
Editor Panes

+ Organize AquaScripts

Create and Edit folders to organize your AquaScripts, move them wherever you need and search them to find what you are looking for. Expand and collapse the directory tree to see what's inside each folder.
Organize AquaScripts

+ Import from Aqua Data Studio

If you have some .xjs files you've made in Aqua Data Studio, it's easy to import and edit them.

+ Deploy from Aqua Data Studio

Quickly deploy just your AquaScripts from a Project in Aqua Data Studio into Aqua Data Server with just a few clicks, even if you have hundreds of .xjs files.

+ AquaScript: Project Workspace

Any AquaScript within a project can be chosen by the Project Owner as the Project's Workspace: a script that executes for, and displays its results on, the Workspace tab. Workspace Ichimoku Cloud Chart

+ View Script Details

When viewing the AquaScripts tab, you get to see Creation and Update datetime, Creator and Owner, and File Size of all your files.

+ Edit the AquaScript Description

Add a description to go along with your filename to help explain what the script is for. This description is visible with a mouse hover over the script's name within the AquaScripts list.

+ Rich Text Editor

Simple, powerful and easy to use text formatting. Find and Replace with Regular Expressions, Syntax Highlighting, Line and Character position. AquaScript Editor

+ Aqua OpenAPIs

  • archive - methods and algorithms to archive files
  • chart - methods for creating charts
  • compare - methods for comparing files, directories and schemas
  • crypto - cryptographic functions
  • data - methods for working with data grids and pivot tables
  • filesystem - methods for accessing and managing computer file system
  • form - methods for implementing HTML forms
  • io - methods for reading and writing in TXT, HTML and Excel formats
  • mail - methods for sending and receiving e-mails
  • math - mathematical and statistical functions
  • net - networking methods
  • project - methods for managing application project conatainers
  • random - random data generators
  • rdbms - methods for accessing various types of databases
  • schema - methods for manipulating database objects
  • rdbms.util - methods for parsing and formatting SQL statements
  • report - methods for database querying and reporting
  • random - random data generators
  • type - methods for various data types manipulation and validation
  • util - methods for development and debugging
  • vcs - methods for working with CVS, Subversion, GIT and Perforce version management systems

Server Registration - RDBMS Support available with Aqua Data Server

+ Register a Server

The Register Server action allows you to register any server that is supported by Aqua Data Server. Aqua Data Server supports all databases that are supported by Aqua Data Studio and provides a nearly identical interface for server registration. Server registartion is specific to the type of database server selected, and the input fields vary depending on the database vendor and version chosen.

+ Add or Edit a Server

Add a New server or Edit an existing one to use it in an AquaScript. Run a Query on it from the Query tab to check results and view Messages and Warnings.
Add or Edit a Server

+ Simple GUI

If you're familiar with Aqua Data Studio, then Registering a Server in Aqua Data Server will be a snap. The interface is nearly identical so it's very easy to navigate and enter database properties.

+ Import Server Registrations

Either import .conn files one at a time directly from your Aqua Data Studio Connections folder, or Deploy all of an AquaProject's Servers from the Projects Browser in Aqua Data Studio 9.x and 10.x
Import Server Registrations

+ Edit Filters

Create and Edit filters for your server connections.

+ Edit Advanced Properties

Set your Transaction Isolation Level, Fetch Size, Data Warehouse Mode, Display, and Enable or Disable DB Filters.
Edit Advanced Properties

+ Include Driver Parameters

Want ensure you connect via an SSL connection with PostgreSQL? The Server Driver tabs allows including Driver Parameters like "?ssl=true"

+ Include Login Scripts

In the Server Properties Scripts tab, include a script that you need to run when a connection is established, like a database context change.
Include Login Scripts

+ Manage Servers

Group your Servers into folders and subfolders to keep them organized. Expand and collapse folder views to assist in finding the server you need to work with.
Manage Servers

+ Query a Server

Once your server is registered, you can easily run a query on it through the Query tab.

+ RDBMS and NoSQL Support :

  • Amazon Redshift
  • Apache Cassandra - 2.0, 1.2
  • Apache Derby - 10.11, 10.x
  • Apache Hive - 0.14
  • DB2 iSeries V7R1, V6R1, V5R4, V5R3
  • DB2 LUW - 10.5, 10.1, 9.7, 9.x, 8, 7
  • DB2 z/OS - V10, V9, V8
  • Excel
  • Greenplum
  • Informix IDS - 12.10, 11.x, 10, 9.x, 7.x
  • MongoDB - 3.0, 2.6, 2.4.x, 2.2.x
  • MS SQL Server - 2014, 2012, 2008, 2005, 2000, 7, MSDE
  • MySQL - 5.x, 4.x, 3.x
  • Netezza - 7.1, 7, 6.x, 5.x
  • Oracle - 12c, 11g, 10g, 9i, 8i
  • ParAccel - 5.1, 4.x, 3.5, 3.1
  • PostgreSQL - 9.x, 8.x, 7.x
  • SQLite - 3.x
  • SQL Database (Azure) - 11.x
  • Sybase ASE - 16.0, 15.7, 15.5, 15, 12.x, 11.x
  • Sybase Anywhere - 16.0, 12, 11, 10, 9, 8
  • Sybase IQ - 16.0, 15.4, 15.2, 15, 12.x
  • Teradata Database - 15, 14, 13, 12
  • Teradata Aster Database - 6.0, 5.1, 5.0, 4.6, 4.5, 4.0
  • Vertica - 7.1, 7.x, 6.0
  • VoltDB - 4.9, 4.0, 3.7

+ Clone Existing Connections

Want to reuse Server Properties you already entered to save time? Use the Clone Server button and simply change what you need for the new connection. Clone Existing Connections

+ Security

Access to the Servers tab can be restricted so that only appropriate users can view or edit your database connections. Saved Passwords for Server connections are always encrypted and never visible to the end user.

+ Servers List Details

The Servers list includes details about Server Name, Creation Date, Update Date, Creator and Owner so that changes can be monitored.


User Files

+ Graphical View

The User Files tab gives you a graphical view of what is currently in the User Files folder and lets you import new user file as well.
Graphical View

+ AquaScript Input/Access

If you have an AquaScript that needs to access a file for input or output, import it to the User Files tab. AquaScripts that read Excel or Text files, display icons for buttons in your Workspace, or parse XML data can point to this location for what they need.
AquaScript Input/Access

+ Deploy from Aqua Data Studio

User Files from an AquaProject can be deployed directly to Aqua Data Server, instead of having to import them one at a time.
Deploy from Aqua Data Studio

+ Security

Access to User Files can be completely restricted with Roles. Want someone to run an AquaScript that reads a User File, but don't want that user to see the User Files tab? No problem.
Security

+ Organize

Just like the other areas of Aqua Data Server, you can create, expand and collapse folders, move and rename, or delete. Only file names can be edited in the User Files tab, file contents is not editable.

+ User Files Details

View a file's Creation and Update Date, Creator and Owner or check its file size in the User Files list.

+ Create Downloadable Reports

It's possible to have an AquaScript generate a downloadable file (.xls, .txt, .csv, .html, .zip etc.) and store in the User Files tab so users can access it.

+ Export from a Database

For ETL processing, your AquaScript can place exported database content in the User Files tab.


Scheduled Jobs

+ Automate Tasks

After you have developed production ready AquaScripts, you might want to execute some of them on a periodic basis or in a background thread. Aqua Data Server's scheduled job functionality is designed to address these requirements.
Automate Tasks

+ Select AquaScripts

In a scheduled job, you specify the AquaScript to run and how often the AquaScript should be executed. Aqua Data Server's Scheduler engine automatically invokes the AquaScript at the designated time.

Select AquaScripts

+ Customize your Run Time

With the new Date Picker and Hour and Minute sliders, it's easy to choose the date and time durations you need.
Customize your Run Time

+ To the Minute and Second

Any AquaScript can be scheduled to run precisely when you want it to. Want it to run every 3 seconds for the next month? No problem.

+ Monitor Scheduled Jobs

View a Scheduled Job's Next Run Date, Last Run Date, Execution Duration, Created Date and Updated Date from the Scheduled Jobs tab. The Scheduled Jobs list also displays who created and last edited the Job.
Monitor Scheduled Jobs

+ Pause, Start and Stop

If you need to edit an AquaScript that's scheduled to run, simply pause the job or disable it while you or your coworkers work on it.

+ Run Once or Run Forever

Set a job to only run once at some future date, or have it run daily for as long as you like.

+ Job Management

The New Job button and the Edit Job action enable you to specify all Job related parameters for scheduling an AquaScript's execution.

+ Execute

Clicking the Execute action will immediately run the job in a background thread. Similar to a job that is invoked automatically, the job's execution history will be updated, and the job can be viewed in the Scheduled Jobs -> Jobs Detail page.
Execute


Connections

+ Collaborative tools

Collaborative tools in Aqua Data Server are designed to collect, organize, manage and share information in an effective way. Collaborative tools

+ Connections

You can add connections and grow your professional network. Connections are displayed in the user profile page.
Connections

+ Network Activity

The new Network Activity feature helps you keep track of your connections' activities.

+ “Status” and “Link” Sharing

You can share your current "Status" and a URL with the entire community, so that everyone knows what you are working on at a given moment.

+ “Like” Tag

Practically every item in a user's Home Network Activity, such as comments, statuses and shared links can be Liked.
Like tag

+ Private and Public User Profiles

Aqua Data Server users can choose to make none, some or all of their profile information available to the Public.
Private and Public User Profiles

+ Privacy Settings

You can control how much of your activity gets seen by your connections.
Privacy Settings


Internationalization

+ Interface Languages

The language drop down allows you to change to any of the supported 21 languages. Interface Languages

+ Translated Menus and Prompts

Tabs, Menus, Confirmations, Warnings and Error Messages in Aqua Data Server are translated into the supported 21 languages.

+ Notification Language Preference

Set your preferred language to receive Email notifications.

+ Display Language Preference

Set your preferred language for your display when you login to Aqua Data Server.
Display Language Preference

+ User Time Zones

Set your preferred Time Zone. All posts or comments added by other team members are converted and displayed in the local time of your settings.

+ Date / Time Format

Set your preferred format for Date/ Time display using Custom Date/Time formatting within your User Settings.
Date / Time Format


System Administration

+ Role-based Security

Project level permissions for modifying and executing JavaScript applications are set with Roles, which are then assigned to users. System and Project Permissions and access are very granular. Restrict who gets to see what tabs.
Role-based Security

+ Require HTTPS login

If enabled, the only way to log in is via HTTPS. It's also possible to restrict logins to only private IP address ranges.

+ Email Queue

If your AquaScripts are designed to send email, the System Administrator's Email Queue tab handles the delivery process and gives you details on its status and SMTP Email Service settings. Pause, Stop and Restart the Email Queue as needed.
Email Queue

+ Security Features

Password Policies control password complexity, minimum length, expiration, reset code expiration, password history and the use of "Forgot your password" links. If you enable the added security of captcha or ReCAPTCHA and Brute Force Login prevention mechanisms, you can protect Aqua Data Server from unauthorized attempts to access it.
Security Features

+ Login Attempts

The Login Attempts tab allows System Administrators to track who's trying to login and from where, with what kind of browser. Failed login attempts are highlighted in red.
Login Attempts

+ Scheduler

System Administrators get a complete view of all Scheduled Jobs for all projects in Aqua Data Server. Scheduled and Running Jobs details can be examined, the jobs can be executed on demand and stopped if need be.
Scheduler

+ Change Project Ownership

System Administrators get a complete list of all Projects (Private and Public) and can transfer project ownership easily from one user to another. They also have the ability to delete or edit projects, and they can export the projects list as a CSV, Excel or XML file.
Change Project Ownership