Aqua Data Studio simplifies data-centric tasks by working on data sources without exposure to complex technical elements, detailed technical skills, or detailed knowledge of vendor-specific SQL dialects.
Schema and 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.
Files and 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.
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.