AquaFold Releases Aqua Data Studio 14

SUNNYVALE, Calif., Oct. 14 — AquaFold, Inc. has released Aqua Data Studio 14, a major upgrade to its universal database query and management software, allowing users to design and administer the latest class of databases, including relational, embedded, NoSQL, and even databases hosted in the cloud. NoSQL and cloud databases have grown in importance as both startups and large enterprises face the challenge of working with massive data sets.

“Aqua Data Studio is the first to market with a multi-database GUI that also supports NoSQL, Cloud and Hadoop-based databases,” says AquaFold’s CEO, Niels Gron. “Our customers see huge value in these specialized databases that provide low cost and highly scalable solutions for their business analytics.”

Adding support for NoSQL required the AquaFold development team to develop creative ways to provide a relational “SQL” frontend to databases that explicitly do not support it. The team designed its own MongoSQL language specific to MongoDB, as well as a command line shell that places an interactive JavaScript MongoDB shell directly in Aqua Data Studio. The team also worked to bring Aqua Data Studio’s full toolset to users of Apache Hive and the open source distributed database Apache Cassandra.

Connecting to Microsoft’s relational database-as-a-service, SQL Database (Azure), is now also possible in version 14 of Aqua Data Studio using the same tools users have come to expect when connecting to Microsoft SQL Server.

“Hosted databases offer cost savings and simplicity that are very attractive to companies,” says Gron. “We’ve ensured that they can continue using Aqua Data Studio whether that database is on the company’s own server or moves to the cloud.”

Aqua Data Studio’s built-in Git client was rebuilt from the ground up and vastly improved. The overhauled interface supports all of the source control tasks customers expect, including branching, tagging, fetching, merging and pushing. A complete history graph makes tracing changes and finding forks and branches effortless.

Aqua Data Studio 14 also features additional enhancements, including connection clustering, which allows users to use a single registered server to access multiple databases from PostgreSQL, nCluster, Greenplum, Netezza or ParAccel. The Table Data Editor and Sybase import have seen dramatic performance improvements, and configurable keyboard shortcuts help make Aqua Data Studio adapt to individual users, including with preconfigured Emacs key mappings. Database support has also been upgraded to include Sybase IQ 16, Oracle 12c, Teradata Aster Database 5.0, Teradata Database 14.0, ParAccel 4.0, MySQL 5.6, SQLite 3.7.15 and Apache Derby 10.10.1, and more.