For information about unsupported versions, contact Licensing. An interactive shell allows you to edit and execute SQL using the SQL command line. It also offers the flexibility of a Unix shell for automating database tasks. Aqua Data Studio can be installed and used seamlessly on Windows, Linux, and macOS. Learn quickly about Aqua Data Studio’s many powerful features.
Aqua Data Studio 19
Developers can use one consistent interface to work across all databases platforms. This maximizes database development efficiency. A forward engineer can model tables, views, and indexes and generate SQL scripts. To visualize a database model, reverse engineer existing databases. Convert models quickly from one platform to the next. • Manage SQL scripts, database, and Aqua Data Studio files using the integrated version control client for Subversion CVS Git, Git, Git, and Perforce.
You can install in seconds and evaluate the versatile database idea
The graphical user interface allows you to select columns and tables. You can use extensive visual options such as joins, group bys, and sort order to create equality comparisons.
SQL Abbreviations and Automate features can save time when writing SQL statements. To format your SQL statements, you can use the Beautify options. With a single click, query results can be exported to Excel or sent as an email attachment. Aqua Data Studio’s Version Control Integration makes SQL Scripts display Inline Diff indicators in the Query Window. The Grid and Pivot Grid results include a Charting Toolkit. — Create sophisticated queries in databases without writing any SQL.
To save time when writing SQL statements, automatically format SQL and color syntax. You can view query results in text and grid views. Aqua Data Studio provides a comprehensive integrated development environment for visual analytics and databases. It allows database administrators, database developers, data, and business analysts to manage multi-platform databases as well as the data within them. You can manage, develop, and administrate databases. Access, manage, visual analyze, and manage data.
With just a few clicks, you can browse database objects and edit them visually. You don’t need to write any code. One interface allows you to connect natively with over 40 NoSQL DBMS platforms. You can access your data sources, no matter if they are on-premises or in the cloud. Aqua Data Studio provides a GUI interface to schedule SQL in Windows. Parameterized Scripts allows you to define variables in your SQL Scripts by using a top “&”. After running the script, you will be prompted to enter the parameter value in a popup.
The built-in SSH client allows you to securely log in to any server. It offers a wide range of features, including copy and paste, Unicode, encryption, ciphers, and support for multiple terminal emulators. The tool allows you to configure SSH tunnel connections, including port forwarding as well as server connections tied to the tunnels. A graphical interface allows you to edit the result-set from a query executed on a data grid. Autocompletion5 allows you to speed up the creation and editing of SQL scripts for databases tables, columns, views. As soon as you enter the query analyzer, autocompletion will be invoked immediately. Aqua Data Studio will pop up a list of all objects that match your query, making it easier to work.
Create advanced visualizations quickly for data analysis by using statistical analysis with R. Create a calculated field to invoke R commands, and then plot the data as any other field.
Compare schema objects from different databases using a graphical interface that is easy to use. Compare query results, folders, and files on local computers.
To tune query performance and improve query execution, view a visual display of the execution plan and statistics. You can import and export data from different formats to and from databases, tables, objects, and files. You can quickly choose to extract, transform, or load using the convenient import and export wizards. A graphical interface allows you to edit the result-set from an executed query. You can easily alter the data and add or delete rows with an Excel-like grid. Before you execute the SQL statements, preview them. Make engaging dashboards and data visualizations that you can share with others.
Aqua Data Studio releases and patches for Supported Versions are available to exist customers by logging in to the customer support portal. You can create and debug scripts using the scripting environment that includes a variety of open API programming interfaces. You can automate all the functionality of the product’s database tasks. — Find and fix any production or development issues by debugging stored procedures, functions, and packages. Single-step code. Pause and set breakpoints. Evaluate variables and conditional flows.
Aqua Data Studio 19 System Requirements
- Memory (RAM): 1 GB of RAM required.
- Operating System: Windows XP/Vista/7/8/8.1/10
- Processor: 1 GHz of Intel Pentium processor or later.
- Hard Disk Space: 500 MB of free space required.