JavaScript IDE & Open APIs

Create AquaProjects to organize tasks

The Aqua Data Studio Tree Panel contains the Project Browser. Within the Projects Browser, right click and select New Project to create an AquaProject. Every project has an AquaScripts directory, a Servers directory and a User Files directory. You can register a database server and create, debug and execute a set of AquaScripts that work on it. AquaProjects allow you to organize your software development tasks into self contained programming units. Once a project is completed you can export or share with your team.

Use AquaScript Templates to automatically generate code for your most common scripting needs. These templates provide an easy to use interface to input values and create ready-to-execute scripts. Upon choosing a template, an AquaScript is generated & stored in the AquaScripts folder with the .xjs extension. Edit the AquaScript for further modification and execution

AquaScript Editor
New Project Without a Predefined Script
New Project With a Predefined Script

Create AquaScripts to automate tasks

Use Open APIs to write AquaScripts and build fully automated end-to-end solutions based on your business requirements. To create a new AquaScript select the AquaScripts folder from your AquaProject and use the Insert key to create a new AquaScript. AquaScripts are identified by their .xjs file extension. All of the Open APIs are available through the global variable named “aqua”, which is an instance of the “AQAqua” class. AquaScripts may also access any other proprietary or Open Source Java libraries included in the Java Virtual Machine (JVM) classpath. AquaScripts are executed within Aqua Data Studio using the Mozilla Rhino¹ engine.

New AquaScript

AquaScript Editor

The fully functional editor for AquaScripts provides autocompletion, syntax coloring, bookmarks, abbreviations, find/replace, incremental search and more.

Autocompletion
Autocompletion Options

Execute AquaScripts

Execute AquaScripts with Ctrl+E. Invoke the debugger using Ctrl+Alt+Enter. The debugger allows you to step through, pause and set breakpoints in the code. The debugger highlights the breakpoints and indicates which breakpoint paused the execution. This makes it easy to evaluate variables and conditional flow of code.

AquaScript Debugger

Debug in Browser

The AquaScript Editor debugs an AquaScript in a browser with Aqua Data Studio’s embedded web server. Form input and page interaction within this browser can dynamically interact with your AquaScripts.

Debug in Browser

Export AquaProject

AquaProjects can be exported to disk as zip files.

Export Project

Version Control Integration

Aqua Data Studio provides integration of AquaProjects with several Version Control Systems like CVS, Subversion (SVN), Git and Perforce. AquaScripts associated with a version control repository can be edited and saved in the AquaScripts Editor.

Version Control Inline Difference Indicators