Aqua Data Studio is a complete
Integrated Development Environment (IDE) for
database query, administration and development.
It supports all major database vendors, works on
multiple operating systems and is localized for over
20 languages. With version 9.0 of Aqua Data Studio,
we've introduced Aqua Open APIs, offering developers
access for the first time to all of Aqua Data
Studio's capabilities. The Aqua Open API library is
editor and debugger.
Open APIs enable developers to write scripts that access the functionality of ADStudio to create custom solutions and tasks that fall outside of the product's GUI restrictions. This includes current functionality around database access, database schema DDL generation, compare tools, version control, data pivoting, charts and much more. We have also introduced new functionality, including random data generation, statistical functions, local file system and Hadoop file system.
AquaScripts are executed within ADStudio using the Mozilla Rhino engine. The AquaScript language itself is standardized by Standard ECMA-357 ECMAScript for XML (E4X): A general purpose, cross-platform programming language. Any script executed has full access to the Java API in addition to the Aqua Open API. Scripts may also access any other proprietary or Open Source Java libraries included in the Java Virtual Machine (JVM) classpath.