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
For the Aqua Data Studio v16.0 release, we are dramatically enhancing Visual Analytics, giving you more charts, features, capabilities and options to produce the data visualizations you need. We've introduced a new chart type for Treemap Charts. There are more options for Trend Lines. You can create Bins to group ranges of continuous measure values to create Histograms. Quickly copy spreadsheet content and paste it in as a datasource with Paste Data. An Undo/Redo framework is now available in Visual Analytics. We're including support for newer versions of databases we already supported: Sybase ASE, Sybase Anywhere, SQL Server, MongoDB, VoltDB, Greenplum, Vertica, Hortonworks, Cloudera, Teradata, Netezza, ParAccel, Informix, and Apache Derby.
More Choices for Trendlines
Choose from several Trendline types like Linear, Logarithmic, Exponential and Polynomial. You can now display Confidence Bands and see more information on how lines are calculated to get full line details.
Learn more
Domain Padding for Date Fields
In cases where dates are missing in your data, Trend Lines now fill in the gaps to make your visualizations more coherent.
Learn more
Pop-up Filters Dialog
With our improved Filters Deck, you now get a popup showing you filter options before your filter is created to make it easier to choose the filter you want.
Learn more
Parameter Enhancements
With our improved Parameters, you can use a range of values as a parameter instead of just a static value. Parameters can be chosen from preconfigured lists, too.
Learn more
Parameterized Queries
Queries in Visual Analytics can now be paremeterized, allowing you to set values as the queries are executed. If your query included a parameter, we automatically add it to the Parameters pane.
Learn more
Generate Bins
Create bins to group continuous measure values into meaningful groups, which is particularly useful in our new Histograms.
Learn more
Improved Excel Query Performance
Excel query results from large XLSX and XLS files are much faster. Queries that took nearly 40 seconds now complete in less than 15 seconds.
Learn more
Keep Previous Results Visible
You can now pin a query result so that it does not get cleared when a query is reexecuted. Each Result Pane can have multiple pinned or unpinned tabs.
Learn more
Find DB2 zOS Query Bottlenecks
Our Visual Explain Plan capabilities are now available for DB2 zOS versions 9 and above.
Learn more
Generate a Treemap Chart
Treemaps allow you to represent specific values with colors, making many types of data easier to understand. They are useful for showing hierarchical data by representing it as nested rectangles.
Learn more
Chart Properties Enhancements
Our improved Chart Properties let you have even more control. Drag Dimensions into new positions for nesting in Tree Map charts.
Learn more
Multiple Hidden Dimension Fields
As part of supporting the new Tree Map Chart, we now allow multiple hidden dimension fields in the Chart Properties.
Learn more
Increased Flexibility
Table Calculations can now be applied to any Dimension field in the Table view.
Learn more
Use Table Calculation Types Rank and Percentile
See how a particular value ranks, or discover what percentile a dimension falls in to.
Learn more
Replace a Data Source
Now it is possible to change an existing valid Data Source to use a different connection than what it started with
Learn more
Paste clipboard data as a Data Source
Quickly create a Data Source from your clipboard with Data > Paste Data to generate an Excel file of it and use it as a connection within Visual Analytics ...
Learn more
Autocomplete Queries Within Visual Analytics Worksheets
The Edit Query dialog within Visual Analytics now supports Query Autocompletion, giving you the power of our Query Analyzer from within a Visual Analytics Worksheet.
Learn more
Implement Aggregation Formulas in Calculated Fields
Calculated Fields now give you the ability to apply aggregation formulas like STDEV and VARP.
Learn more
Use More Calculated Field Functions
Calculated Fields now offer several more options for strings, dates, numbers, logical functions and table calculation functions.
Learn more
Use Table Calculation Functions
By adding INDEX, FIRST, LAST and LOOKUP Table Calculation Functions, we're giving you the more power to visualize what you need from your Table Calculations.
Learn more
See Better Visualization Suggestions
Multiple new formulas have been added to our Visualization list, expanding the possibilities of what your data can help you visualize.
Learn more
Undo Changes
Now it is possible to undo or redo changes within Visual Analytics.
Learn more
Save and Share as HTML
Now it is possible export the currently viewed pivot table as HTML, making it easy to share your work.
Learn more
Pass Sessions from Fluidshell to the Query Analyzer
Now it is possible generate FluidShell sessions and pass their session IDS to a currently open Query Analyzer.
Learn more
More DB Version Support
Connect to Sybase ASE 16.0, Sybase Anywhere 16.0, SQL Server 2014, MongoDB 3.0, VoltDB 4.9, Greenplum 4.3, Vertica 7.1, Hortonworks 2.2, Cloudera 5.2, Teradata 15, Netezza 7.1, ParAccel 5.1, Informix 12.10, Apache Derby 10.11 and MySQL 5.6 Fractional Second support.
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.