AquaFold has released Aqua Data Studio 9.0 (http://www.aquafold.com), an upgrade to its universal database query and administration software designed to make it simple to visualize and manipulate multiple relational databases from within a single interface.

The app is designed for business analysts, software developers and database administrators (DBAs) worldwide and lets them consolidate the design, development and maintenance of enterprise relational databases into one versatile application. Among the new features in version 9.0 are AquaScript and open application programming interfaces (APIs), a set of application APIs that open up the rich core functionality of Aqua Data Studio for automating tasks, scripting and customizing the application to specific user or enterprise needs. Processes that took multiple steps within Aqua Data Studio’s graphical interface can now be automated with just a single AquaScript, explains AquaFold’s Chief Software Architect Niels Gron.

Additionally, Aqua Data Studio 9.0 offers a scripting environment based on JavaScript. Users can edit and debug AquaScripts within the same application or within a browser window for server deployment, and, like all Aqua Data Studio documents, scripts can be placed into a version control repository. AquaScripts may also be generated automatically — with no scripting required — from queries and pivot grids created using Aqua Data Studio’s graphical interface.

Version 9.0 continues to add and enhance other features that have made Aqua Data Studio the preferred tool for a whole set of data management applications. The Entity-Relationship Modeler has seen improvements in creating, understanding and sharing ER models. It now generates and publishes HTML reports listing all components in the database, and automatically formats ER diagrams.

The Charting tool in Aqua Data Studio 9.0 includes new types of visualizations to build charts in the form of a world map. Users can even highlight country borders and add numerical data in association with any region on the map.

Aqua Data Studio 9.0 works with Mac OS X, Windows, Linux, Solaris and the Java platform. The cost of a single-user commercial license for Aqua Data Studio 9.0 remains US$399. Current license holders with expired subscriptions can renew their subscriptions for $139.65 — 35% of the new license price. Multi-license purchase discounts are also available.