Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio's version 17.0 release adds native support for three very popular Big Data and cloud-based data products: SAP Hana, Google BigQuery, and Apache Spark.
Business analysts will be excited by the productivity enhancements offered in our two Excel related improvements. First, our new Excel Import Wizard directly imports your Excel files into your database. Second, our enhanced Excel SQL driver enables you to execute WHERE and JOIN clauses against your Excel file.
Database administrators will feel even more empowered by our expanded DBA tools suite to monitor and manage ten additional databases; such as Amazon Redshift, Greenplum, Teradata, Teradata Aster, and Sybase IQ. DBAs can also use our expanded Explain Plan Support to identify SQL query bottlenecks quickly.
Business intelligence users will appreciate the significant enhancements to our Visual Analytics capabilities. We have introduced nine new charts including Maps, Sunburst, and Heat Map. We have also greatly strengthened our statistical capabilities by offering Reference Lines, Box plots, and R language integration. In addition, we have focused on usability enhancements including text and image support in dashboards, an advanced gradient color legend, and date and time hierarchy navigation.
Dive into SAP HANA
You can now connect to SAP HANA, an in-memory database and application platform to query and analyze your big data and gain valuable insights. Learn More
Query Spark Clusters
You can now connect to Apache Spark, the blazing fast in-memory large-scale data processing engine. Learn More
Run MongoDB JavaScript commands
Our new MongoJS Query Analyzer, can now run MongoDB javascript commands and display the results in a tree hierarchy. Use MongoJS pretty print JSON, autocompletion, syntax highlighting and many more features. Learn More
Explain Plans for 7 More Databases
You can now use Explain Plans in Text format for Amazon Redshift, Greenplum, ParAccel, Teradata Aster, Netezza, PostgreSQL and MySQL to help reduce SQL query bottlenecks. Learn More
Query, Analyze BigQuery Datasets
Connect to Google BigQuery, a cloud-based big data analytical web service to explore your projects, run SQL queries, and use the intuitive visual editors for all your BigQuery datasets. Learn More
DBA Tools for Your Databases
We now support DBA tools for Amazon RedShift, PostgreSQL, Greenplum, Teradata Aster, Netezza, ParAccel, Informix, Sybase IQ, Teradata, and Vertica. Learn More
Excel SQL SELECT using WHERE
We now support MS Excel WHERE, ORDER BY, GROUP BY, HAVING, and JOIN clauses that give you the ability to connect, query, and generate results from the XLS and XLSX files. Learn More
Excel Import Wizard
Our new Excel Import tool imports data directly from single or multiple Excel sheets into existing or new database tables. Learn More
More DB Version Support
Connect to Cloudera 5.4, HortonWorks 2.3, MapR with Spark, PostgreSQL 9.4, VoltDB 5.5, and Informix 12. Learn More
Nine New Charts
We now offer nine new charts: Filled Map, Highlight Table, Heatmap, Funnel, Gauge, Horizon, Mekko, Radar, and Sunburst so you can produce the data visualizations you need.
Reference Lines and Box plot
Our powerful new tool highlights aspects of specific interest in a given data set using the Reference Lines. Customers can quickly and conveniently compare multiple data sets against a central theme. Learn More
Rserve Integration with Visual Analytics
Our new Rserve integration enables customers to analyze statistical computing visually and easily. Learn More
Significantly Improved Dashboard
We have significantly enhanced our dashboards by introducing Text and Image objects. These objects make dashboards more visually appealing and enable you to analyze your data easily, along with the charts. Learn More
Advanced Gradient Color Legend
Our highly customizable measure color gradient provides sequential and diverging color themes, along with the freedom to divide colors into discrete steps and customize the color gradient range. Learn More
New Date, Date and Time Hierarchy Navigation
Our new date and date and time hierarchical enhancement offers great navigational capabilities to drill down into the data. Learn More
We're excited to announce that we have completely opened up our development process. All defects and enhancements, documentation, discussions and knowledge bases are publicly accessible by anyone. Take a look at all enhancements and bug fixes in this release on our dashboard.