JavaScript and Cookies must be enabled in order for you to use AquaClusters.
Either JavaScript or Cookies is disabled or your browser doesn't support them.
If you enable JavaScript and Cookies you can try again by clicking here.

What's New in Version 18.0

For the Aqua Data Studio version 18.0 release, we have added significant usability and functional enhancements to all our editors. We are also introducing schema synchronization which enables you to deploy differences from your source schema to your target schema. In addition, we now offer Visual Explain plans for Amazon Redshift and Teradata databases. We now support Google BigQuery Standard SQL syntax along with several new data types. Version 18.0 also offers a new tool called Connection Monitor which provides the ability to ping database connections on a periodic basis, refresh results in your Query Window at a specified interval, and turn on auto-commit after the idle threshold is exceeded.

Significant enhancements in Visual Analytics provide business intelligence users more ways to analyze their ever-growing data volumes quickly and efficiently. Added to this release are symbol map and bullet charts, fixed axes support, many new ways to sort your data, relative date filters, exporting to PDF files, redesigned calculated field editor, chart highlighting, and much more.

SQL Editor EnhancementsThe SQL Editor has been enhanced to support code folding, navigating amongst errors in text results pane, an improved autocompletion matching algorithm and sorting autocompletion entries either lexicographically or by relevance.Learn More

AquaScript Editor EnhancementsWe have introduced six new templates for creating AquaScripts. The AquaScript Editor has also been enhanced to support code folding, provide an improved autocompletion matching algorithm, navigate amongst errors/warnings, and facilitate real-time indexing. Learn More

Diff and Compare Enhancements
We now provide a smarter difference engine and have simplified your diff related tasks. An improved UI supports syntax highlighting, an annotation bar to customize your editor settings, collapsing unchanged fragments, and more. You can now compare and synchronize the content of your directories using our brand new Directory Compare interface. Learn More

CONNECTION MONITOR

Connection Monitor Tool
Our new all-in-one connection monitor tool offers the ability to ping database connections on a periodic basis, refresh results in your Query Window at a specified interval, and turn on auto-commit after the idle threshold is exceeded. Learn More

SCHEMA SYNCHRONIZATION

Schema Synchronization
You can now seamlessly deploy differences from your source schema to your target schema for Oracle, MS SQL Server, Sybase ASE, and DB2 LUW. A wizard allows you to select dependencies, map missing columns, configure your script to fix potential deployment issues, view a summary of actions and warnings, and generate the deployment script to execute in Query Analyzer. Learn More

Schema Compare EnhancementsThe Schema Compare Results UI now groups results according to the type of differences and offers a more powerful and streamlined Search capability. You can also specify the source and the target schema objects to synchronize. Learn More

GOOGLE BIGQUERY ENHANCEMENTS

Insert Performance Optimization
Aqua Data Studio can now insert multiple records in a single INSERT statement, thereby significantly reducing the time it takes to import a large amount of data into BigQuery. Learn More

Microsoft JDBC Support
You can now use the Microsoft JDBC driver to connect to SQL Server and Azure. Learn More

More Visual Analytics

Axes Enhancements
Our enhanced axes support lets you specify a fixed axis range, reverse the order of values on an axis, display a separate axis per measure, and retain measure colors as you change your axes type.Learn More

Sorting Enhancements
You can now choose to sort data based on any field in your dataset or a custom order. Sorting shortcuts have been added in the toolbar, chart tooltips, and most row and column headers. Learn More

Filter Enhancements
Our new filtering capabilities enable you to create relative date filters. Moreover, you can keep only/exclude selected records directly from the chart view or legends. Learn More

Export Enhancements
Export your visualizations to PDF. Also, large charts can now be exported without being cropped to PNG, HTML, and PDF formats. Learn More

Symbol Map & Bullet Charts
We now offer Symbol Map and Bullet charts so you can produce the data visualizations you need.

Calculated Field Enhancements
Our redesigned Calculated Field Editor provides many new functions such as autocompletion, syntax highlighting, find and replace, punctuation completion, and much more. New calculated fields and table calculation functions have also been added. Learn More

Chart Highlighting
Chart Highlighting allows you to emphasize specific chart segments and perform an empirical analysis on them. Trend lines and reference lines have been enhanced to dynamically recalculate based upon the highlighted data points. 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.