Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the potential for collaboration.
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 the history of run SQL 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.
Data and 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.
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.