Aqua Data Studio updated to v9, adds Netezza support
updated 07:05 pm EDT, Mon October 4, 2010
New AquaScript, open APIs add customization
Aquafold today updated its flagship product Aqua Data Studio, a universal database query and administration program, to version 9.0. The major upgrade includes two user-requested features, AquaScript and Open APIs, allowing users new methods to automate repetitive tasks and making it easier to customize the program.
The software is mainly employed by business analysts and database administrators to develop and maintain enterprise-level relational databases. Additional improvements in v9 include adding HTML-based reports to the Entity-Relationship Modeler, the automatic formatting of ER diagrams for printing, table partitioning and new chart visualization types centered around a world map -- ideal for viewing numeric data in relation to specific countries or regions.
Native Netezza support means that data from the v5 and v6 analytic applications made by the company (which was just acquired by IBM two weeks ago) can now be easily brought into Aqua Data Studio.
Routine data management tasks can now be automated with the new AquaScript function, a Javascript-based environment using the Mozilla Rhino engine that can be written and debugged manually, or generated automatically from queries and pivot grids. Scripts can be edited either in the application itself or using a browser window for server deployment. The Open APIs behind the scripting environment make querying and modifying multiple server connections possible, even with a mix of database management systems.
The software is available for Mac OS X, Windows, Linux, Solaris and the Java platforms. Single-user commercial licenses are priced at $399, upgrades are available for $140.
