Aqua Data Studio Technical Features

Why Technical Users Love Aqua Data Studio

Aqua Data Studio provides comprehensive, scalable, cross-platform data management. It improves the productivity of data-centric specialists, including developers, database administrators, as well as data analysts, data modelers, and data architects.

  • Simplify Tasks

    Simplify tedious tasks involving SQL queries, data, result sets, schema, data models, files, instances, servers, as well as automation.

  • Install and Run

    Install and run Aqua Data Studio on the three most popular operating systems: Microsoft Windows, Apple macOS, and Linux.

  • Language Support

    Display the graphical user interface in nine of the most widely spoken languages: English, Spanish, French, German, Korean, Portuguese, Japanese, and Chinese.

  • Data Source Support

    Aqua Data Studio supports over 40 of the most popular data source platforms, including relational, NoSQL, as well as managed cloud data sources.

  • Simplify Tasks

    Simplify tedious tasks involving SQL queries, data, result sets, schema, data models, files, instances, servers, as well as automation.

  • Install and Run

    Install and run Aqua Data Studio on the three most popular operating systems: Microsoft Windows, Apple macOS, and Linux.

  • Language Support

    Display the graphical user interface in nine of the most widely spoken languages: English, Spanish, French, German, Korean, Portuguese, Japanese, and Chinese.

  • Data Source Support

    Aqua Data Studio supports over 40 of the most popular data source platforms, including relational, NoSQL, as well as managed cloud data sources.

Contact Sales
REQUEST DEMO

Product Features

SQL Queries
Data & Result Sets
Visual Analytics
Schema & Models
Files & Servers
Automation

SQL Queries

Build SQL Queries by dragging and dropping schemas, tables, views, and columns into workbooks to generate executable SQL statements without typing code.
Debug SQL Queries by single-stepping, pausing, and break pointing packages, procedures, and functions to troubleshoot complex queries and statements
Analyze SQL Queries by running SQL queries and statements and displaying the results as text, grids, charts, and execution plans to tune queries to improve their performance.
Access History of Run Queries to write selected queries into the active tool for re-execution and editing. Also, use the SQL history as audit trails for regulatory compliance.
Contact us

Data & Result Sets

Edit data and result sets of run SQL queries by using graphical, Excel-like grids. View, change, add, remove, search, sort, and filter data and export the SQL statements for the changes.
Import and export data of different formats from and to data sources, tables, files, and other objects, including JSON for NoSQL.
Protect sensitive data by masking selected columns of result sets with values of the same data type or null values. Prevent the exposure of sensitive data while keeping the data structure intact.
Generate test data by creating arbitrary tables with no data, arbitrary tables with arbitrary data, and populating arbitrary data into existing tables to facilitate tests without compromising sensitive data.
Contact us

Visual Analytics

Run visual data analytics by dragging and dropping dimensions and measures from data sources into advanced visualizations to share the derived information with colleagues and customers.
Perform advanced statistical data analysis by calculating fields that invoke commands from the “R” programming language to use the resulting data like any other field, including for visual analytics.
Contact us

Schema & Models

Manage data source objects by navigating the schema browser to locate objects and run commands for the object. Use the visual editors to handle schema objects, storage, and security objects.
Develop stored procedures, functions, and packages by browsing schemas to access, change, debug, compile, and run the SQL code.
Compare and synchronize schema and data by analyzing schemas, schema objects, SQL queries, result sets, directories, files, clipboard history content, and version control history.
Model entity relationships by designing and editing schemas and relationships via graphical representations of complex abstract interactions and processes in coherent diagrams.
Contact us

Files & Servers

Manage version control repositories by using a consistent graphical user interface to handle the history of folders and files, including viewing, comparing, updating, committing, deleting, adding, and searching.
Edit source code (such as SQL, JavaScript, Java, AquaScript, XML, HTML, and text) by using advanced editors to aid in the rapid development of data-centric environments.
Manage instances, storage, security, and sessions by monitoring and administering core aspects of the servers to ensure the performance, availability, and security of the data sources.
Set up secure communication with servers by using the interactive command-line interface of a secure shell. Maintain the registered servers and display detailed server information with drill down capability.
Contact us

Automation

Schedule tasks by running commands at specific time intervals while managing the logs and results, as well as sending email notifications when the tasks are run.
Automate tasks with an advanced script language, AquaScripts, that includes many powerful capabilities, including projects, templates, and an advanced editor to develop custom functionality.
Automate tasks with an advanced command shell, FluidShell, which provides the combined functionality of a Unix shell with a SQL command-line tool to script and launch custom solutions.
Contact us

Why Organizations Recommend Aqua Data Studio

Daniel Chernopolskii, IT Project Manager
Deutsche Bank AG
(Global 500, Banking, USA)

“Aqua Data Studio is so simple to use.”

Chad Laurent, Data Analyst
Comcast Corporation
(Global 500, Telecommunications, USA)

“Aqua Data Studio lets us connect to any kind of database we need. We are huge fans of Aqua Data Studio as it allows us to get more done in our day.”

Bala Kodumudi, System Administrator
Kaiser Permanente
(Fortune 500, Health Care, USA)

“Aqua Data Studio provides us with a single simplified tool with zero connectivity issues to multiple database platforms.”

Jared Rypka-Hauer, Application Developer
Continuum Media Group LLC
(Large Enterprise, Computer Software, USA)

“Aqua Data Studio is the best database IDE in existence. It gives us great pleasure to use it.”

Michael Delany, IT Manager
Fox Chase Cancer Center
(Large Enterprise, Health Care, USA)

“Aqua Data Studio is a great SQL tool.”

Bradley Skidmore, Application Developer
XLSure Software
(Large Enterprise, Insurance, USA)

“Aqua Data Studio is the only tool that can organize, connect, export, and relay critical information daily. We do not know how anyone could work well without Aqua Data Studio.”

What Others Are Saying...
Surveyed Users Report:

86% of surveyed organizations improved the analysis of data from query results since using Aqua Data Studio.

What Others Are Saying...
Surveyed Users Report:

85% of surveyed organizations saw a notable improvement in creating, editing, and running queries since using Aqua Data Studio.

Contact Sales
REQUEST DEMO

Licensing

All licenses for Aqua Data Studio are annual subscription licenses. The license includes all product version releases and customer support services during the subscription. Multiple-year licenses are available. Aqua Data Studio has several licensing options. Each license provides unlimited access to all supported data source platforms.

Contact us

Each user receives an individual license key.

An enterprise license for a single key distribution on a wide area network for a specified number of named user accounts.

A flexible enterprise license for a single key distribution for all users within an organization.

Customer Support

When you become a customer of Aqua Data Studio, our goal is to keep it that way. That is why we provide world-class, worldwide customer support.

Contact us

Pricing

Aqua Data Studio’s Ultimate edition costs USD $699 per user per year. Please request a price quotation for larger quantities and multiple-year licenses.

Contact us

Resources

WHITEPAPER

Key Considerations for Database Tools

Download >

VIDEO

Aqua Data Studio Overview Video

Watch Now >

CASE STUDY

Jackson National Life Insurance

Download >

Less Labor, Better Results

Less Labor,
Better Results

The Best Database IDE with Visual Data Analytics


By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.

Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.

Copyright © 2004-2023 IDERA, Inc.