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 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.
Usability and Functional Enhancements
The redesigned editors offer enhanced Status, Annotation, and Marker bars, streamlined Find and Replace functionality, changing font size (zooming) in active editor, and Punctuation completion features. Learn More
SQL Editor Enhancements
The 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 Enhancements
We 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 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
Performance Improvement
Our Excel JDBC driver delivers a 10x performance improvement when expanding schema objects in large Excel workbooks. Learn More
Reduced Memory Footprint
The Excel JDBC driver consumes 6x less memory when expanding schema objects in large Excel workbooks. Learn More
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 Enhancements
The 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
Find Amazon Redshift Query Bottlenecks
Our Visual Explain Plan capabilities are now available for Amazon Redshift. Learn More
Find Teradata Query Bottlenecks
You can now use Explain Plans in Text format for Teradata to help reduce SQL query bottlenecks. Learn More
Standard SQL Support
Aqua Data Studio now supports BigQuery Standard SQL syntax. Learn More
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
More DB Version Support
Connect to MongoDB 3.2, SQL Server 2016, Apache Hive 2.1, Cloudera 5.8, Hortonworks 2.5, MapR 5.1, DB2 LUW 11.1, MySQL 5.7, PostgreSQL 9.5, Vertica 8, and VoltDB 6.8. Learn More
Microsoft JDBC Support
You can now use the Microsoft JDBC driver to connect to SQL Server and Azure. Learn More
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
More Charting Enhancements
Split large composite strings into multiple fields. Export view data to CSV or Excel. Add effects to your plotted data by applying borders, markers, and halos. Leverage table calculation productivity enhancements and newly added functions.
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.
