AquaFold has released Aqua Data Studio 15, a major upgrade to its universal database query and management software, with new features to create visualisations that illuminate your underlying data. In just a few clicks, Aqua Data Studio 15 can now combine pivot tables, charts, graphs and other visualisations into interactive dashboards and workbooks, which can then be shared with colleagues and customers.
"Instinctively we make more thoughtful observations about large amounts of data when we see it visually as graphs, charts and trends," explains AquaFold's CEO, Niels Gron. "Aqua Data Studio 15 turns any query into visuals that are immensely useful. You can share data in a way that is instantly accessible and allows others to navigate and interact with it freely."
Bringing data to life in Aqua Data Studio has never been simpler. Users drag and drop elements to combine and pivot datasets into visual representations, from pie graphs to trend lines. Even different types of charts can be combined to display data individually or merged into a single graph. Additional calculations and filters, including moving averages or running totals, can be added instantly to gain greater insight.
"The possibilities to create and share compelling visualisations and dashboards in Aqua Data Studio 15 is limitless," notes Gron. "You can analyse and share big data faster and more effectively than ever, which leads to better collaboration and smarter decision-making."
Along with Aqua Data Studio's visualisation improvements, the completely redesigned Visual Query Builder is more powerful and easier to use than ever. Users can now generate complex queries visually by dragging and dropping without ever typing a SQL statement. New to this version is a better way to visualise table unions, and support for subqueries. The main query appears in its own tab, while unions and subqueries are built in additional tabs to keep complex queries more organised.
Also improved in version 15 is Bulk Import of data. Multi-megabyte files with hundreds of thousands of rows now take seconds instead of minutes to import.
"The enhanced speeds are remarkable," says Gron. "Vertica imports of 100 000 rows that took 70 minutes before now take just 49 seconds. Netezza imports that took 65 minutes now take less than four minutes."
Aqua Data Studio 15 has also gained the ability to connect, query and generate database-style results from Microsoft Excel files, making one of the most frequently used file formats on the planet even more useful.
Support has been added for Amazon Redshift and the NewSQL relational database VoltDB. Hive support is much improved with drivers for MapR, Cloudera, and Hortonworks, support for HiveServer 2 and legacy support for HiveServer 1, as well as greater security with Kerberos authentication. Database support has also been upgraded to include Vertica 7, DB2 10.5, MongoDB 2.6 and more.
Aqua Data Studio availability and pricing
Aqua Data Studio 15 is localised into 21 languages and works with Windows, Mac OS X, Linux, Solaris and the Java Platform. It is available for immediate download at http://www.aquafold.com/aquadatastudio_downloads.html. A complete list of new features and enhancements may be viewed at http://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/New-Features-15.0/page/0/What-s-New-in-Version-15-0.
The cost of a single-user commercial licence for Aqua Data Studio 15 remains $499. Current licence holders with expired subscriptions can renew their subscriptions for $174.65, just 35% of the new licence price.
