Integration with Aqua Data Studio

• Scripts developed with Aqua Data Studio can be deployed on Aqua Data Server
• Shared set of Aqua Open APIs
• Access Project Containers from Aqua Data Studio
• Shared server connections with Aqua Data Studio
• Access project files from Aqua Data Studio

Development with JavaScript

• Easy to learn AquaScript = JavaScript + Aqua Open APIs
• Set of Aqua Open APIs with combination of database, charting and web GUI functions
• Access to Aqua Open APIs and other JAVA libraries from AquaScript
• Online AquaScript applications deployment
• Multiuser access to AquaScript applications

Web Based GUI

• Online JavaScript editor and Debugger
• SQL editor for adhoc quering of connected servers
• GUI based server administration

Projects

• Grouping applications by Project Containers
• Project level permissions to modifying and executing JavaScript applications
• Project level access to application data via Secure Storage
• Project level Server Connections
• Project level automated script execution scheduling

Built-in Services

• Mail Queue for sending e-mails from AquaScript applications
• Job Scheduler for launching AquaScript applications automatically

Site Based Security Built-in

• Password protected user Accounts
• Role based access framework
• Brute Force login prevention
• Captcha and ReCAPTCHA support
• Login attempts history

AquaScript Open APIs

• 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

Database Support

• Oracle - 11g, 10g, 9i, 8i
• DB2 iSeries V5R3, V5R4, V6R1, V7R1
• DB2 LUW - 9.7/9.x/8/7
• DB2 z/OS - V8/V9
• MS SQL Server - 2008/2005/2000/7/MSDE
• Sybase ASE - 15.5/15/12.x/11.x
• Sybase Anywhere - 11/10/9/8
• Sybase IQ - 12.x, 15
• Teradata 12/13
• Aster nCluster 4.0/4.5
• Netezza 5.x/6.x
• Informix IDS - 11.x/10/9.x/7.x
• PostgreSQL - 9.x/8.x/7.x
• MySQL - 5.x/4.x/3.x
• Apache Derby 10.x

Operating System Support

• Windows
• Linux
• OSX
• Solaris
• Java

Language Support

• Chinese (Simplified)
• Chinese (Traditional)
• Czech
• Danish
• Dutch
• English
• Finnish
• French
• German
• Greek
• Hindi

• Italian
• Japanese
• Korean
• Norwegian
• Polish
• Portuguese
• Portuguese (Brazil)
• Russian
• Spanish
• Swedish