Brand

JavaScript IDE & Open APIs

Aqua Data Studio offers a full-fledged Integrated Development Environment (IDE) with a set of programming interfaces called Aqua Open APIs that access built-in functionalities such as database access, schema DDL generation, grid and pivot charts, compare tools, version control and much more. Developers can invoke Aqua Open APIs via AquaScript — a simple JavaScript based programming language supported both in Aqua Data Studio and Aqua Data Server. The IDE also provides tools for executing and debugging AquaScripts and deploying the scripts to Aqua Data Server. AquaScripts have full access to the Java APIs and any proprietary Java libraries that you include in the Aqua Data Studio classpath.

AquaScript Templates greatly simplify the task of writing AquaScripts by offering templates for your most common scripting needs. Six in-built templates are included: creating and emailing Excel files, exporting schema objects and data, transferring files to/from remote systems, executing multi-server scripts, random table and data generation, and comparing schemas.

 

Aqua Data Studio scripting IDE includes the following functions:

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, share with your team or deploy it to Aqua Data Server.

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

screenshotAquaScript Editor screenshotNew Project Without a Predefined Script screenshotNew 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 Rhino1 engine.

screenshotNew AquaScript

AquaScript Editor

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

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

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

screenshotDebug in Browser

Deploy AquaProject to Aqua Data Server

You can deploy AquaProjects to Aqua Data Server, our specialized application server. Aqua Data Server is a software framework that implements the JavaScript2 engine and the Aqua Open API library for ETL, Reporting and Data Analysis. This functionality is possible because AquaScripts allow database access and schema DDL generation3. To deploy a project, right click on the AquaProject and select the option Deploy. The deploy URL can be obtained by logging in to Aqua Data Server, browsing into the project that you want to deploy to and then navigating to Settings-> Import Project Package.

screenshotDeploy Project

Export AquaProject

AquaProjects can be exported to disk as zip files. They may then be imported into Aqua Data Server using the web interface.

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

screenshotVersion Control Inline Difference Indicators

Context-sensitive Help

The editor provides context-sensitive help as you write your scripts. Simply press Shift-F1 and the API documentation of the object you are currently working on (or have selected) will open in your web browser.

screenshotAPI Help

List of Aqua Data Studio/Server Open APIs

JavaDoc for OpenAPI

References

  1. ^ Rhino (JavaScript engine) Wikipedia article. Rhino is an open source JavaScript engine.
  2. ^ JavaScript Wikipedia article. JavaScript is a prototype-based scripting language that is dynamic, weakly typed and has first-class functions.
  3. ^ DDL (Data Definition Language) Wikipedia article. A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.