Aqua Data Studio 15 With New Visual Analytics and Visual Query Builder

September 16, 2014 in Software (E)

[] Sunnyvale, California - AquaFold, Inc. today is proud to announce the release of Aqua Data Studio 15, a major upgrade to its universal database query and management software, with new features to create visualizations that illuminate your underlying data. In just a few clicks, Aqua Data Studio 15 can now combine pivot tables, charts, graphs, and other visualizations 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 visualizations and dashboards in Aqua Data Studio 15 is limitless," notes Gron. "You can analyze 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 visualization 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 visualize 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 organized.

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 4 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.

Pricing and Availability:
Aqua Data Studio 15 is localized into 21 languages and works with Windows, Mac OS X, Linux, Solaris, and the Java Platform. It is available for immediate download from AquaFold online. A complete list of new features and enhancements is available. The cost of a single-user commercial license for Aqua Data Studio 15 remains $499.00 (USD). Current license holders with expired subscriptions can renew their subscriptions for $174.65, just 35% of the new license price.

Headquartered in Sunnyvale, California, AquaFold, Inc. is a provider of database software tools for relational databases. AquaFold builds tools that help anyone deliver innovative solutions to real world problems using their database, collaborative and analytics products. More than 300,000 users from over 98 countries use AquaFold's products to design, develop, model, and administer their relational databases. The company's social collaboration network helps their customers connect with a distributed team to build software products. Their database and analytics software allows them to develop and deploy cost effective analytics and reporting solutions. All Material and Software (C) Copyright 2014 AquaFold, Inc. All Rights Reserved. Apple, the Apple logo, Mac OS X and Macintosh are registered trademarks of Apple Inc. in the U.S. and/or other countries. Other trademarks and registered trademarks may be the property of their respective owners.


LinkedIn Profile: View
Twitter: View

Print this page | PDF | TXT | Read other releases by this member.