- Get link
- Other Apps
qua Data Studio Features
Database IDE
Aqua Data Studio is a modern integrated development environment (IDE) with a workspace environment. A docking & windowing framework allows tabbed documents for query windows, which can be grouped or floated for flexibility. Easily manage and navigate all of your open query windows and files with selections for viewing modes, orientation styles, and controls for resizing and showing/hiding of panels.
screenshotWorkspace Environment
screenshotDocking and Windowing Framework
Query & Analysis Tool
An advanced Query Analyzer allows you to connect to any database server and execute SQL Queries. SQL formatter, syntax coloring, and autocomplete features save you time in writing SQL statements. Query results can be viewed in text, grid, pivot or form views with quick filtering and export functionality. SQL History allows you to quickly retrieve any previous queries without losing them.
screenshotPivot Grids
screenshotCharting Tool
screenshotAutocompletion
screenshotSQL History And Archive
Visual Query Builder
The Visual Query Builder lets you select database tables directly from the GUI, and then specify columns to retrieve, joins, sorting options, filtering criteria and other query parameters in a grid format. Along with selecting tables and adding query parameters, the Visual Query Builder will generate a complete SQL statement that can be viewed, copied and executed from the Visual Query Builder dialog window.
screenshotVisual Query Builder
screenshotQuery Builder Pivot Grid Results
Visual Explain Plans
Use Visual Explain Plans to display an execution plan for a query, allowing for query tuning to enhance query and server performance. Aqua Data Studio provides explain plans for Oracle, DB2 LUW, DB2 z/OS, MariaDB, Microsoft SQL Server, MySQL, PostGreSQL, Redshift, Greenplum, ParAccel, Teradata Aster, Netezza, Hive, Spark, Impala, and Sybase platforms.
SQL Debuggers
Debuggers for Oracle, Sybase ASE, DB2 LUW, and SQL Server allow for tracing and debugging stored procedures to identify any development or production issues.
screenshotOracle SQL Debugger
screenshotSybase ASE SQL Debugger
screenshotDB2 LUW SQL Debugger
screenshotSQL Server SQL Debugger
SSH Terminal
Register and connect to as many SSH servers as you need and run commands in a tabbed window GUI. For added security it also has a Key Generator and Key passphrase Agent.
screenshotSSH Terminal
screenshotSSH Terminal - Key Generator
FluidShell
FluidShell is an interactive shell which combines the power of SQL command line with the versatility of a Unix shell.
screenshotFluidShell
MongoShell for MongoDB
MongoShell provides an interactive JavaScript shell with nearly identical syntax and functionality to the native mongo shell.
screenshotMongoShell for MongoDB
Version Control
A full and integrated version control client for Subversion, CVS, Git and Perforce allows you to manage your SQL scripts and other database files from within the tool for a much smoother working environment.
screenshotPerforce Version Control
screenshotGit Version Control
screenshotSubversion (SVN) Version Control
screenshotCVS Version Control
Visual Analytics
Create beautiful visualizations and dashboards of your data to explore or share with others. Identify patterns and trends to find opportunities for further analysis. Use filters, data labels, and table calculations to create charts that give you the ability to improve business decisions, limit risk and solve difficult problems.
screenshotVisual Analytics
Table Data Editor
Aqua Data Studio provides a Table Data Editor that allows you to edit the result-set of an executed query on a table using a convenient graphical interface. This makes it easy to alter data and add or delete rows using an editable, Excel-like grid.
screenshotTable Data Editor
Import & Export Tools
The Import and Export tools allow data of different formats to be imported and exported to and from databases, tables, objects and files.
screenshotImport Tool - CSV
screenshotImport Tool - Excel
screenshotExport Tool
Database Object Navigator and Visual Editing
Browse database objects and visually edit them with a few simple clicks. Create, Alter and Delete without having to write a line of code.
screenshotVisual Editing
Scripting & Open APIs
A scripting development environment with a set of Open APIs allows you to develop and debug scripts to automate your database tasks using the full set of functionality of the product.
screenshotProject Environment
screenshotDebug AquaScripts
Database Administration Tools
Administration tools for Amazon Redshift, DB2 LUW, Greenplum, Informix, MariaDB, Microsoft SQL Server, MySQL, Netezza, Oracle, ParAccel, PostgreSQL, Sybase Anywhere, Sybase ASE, Sybase IQ, Teradata Aster, Teradata, and Vertica allow you to manage core aspects of your servers. For most of these databases, there are Instance, Storage, Security, and Session Managers. For Oracle, there's also a Rollback, Log, and SGA Manager. For MS SQL Server, there's an additional Agent Manager. For Amazon Redshift, Netezza and Vertica, there's a Query History view as well.
screenshotDB2 Storage Manager
screenshotSybase ASE Security Manager
screenshotSQL Server Agent
screenshotOracle Rollback Manager
screenshotAmazon Redshift Query History
Compare and Synchronization Tools
Compare and synchronize the DDL of schema objects from different databases in an easy to navigate graphical interface. See database and object level differences and synchronize your source schema to your target schema. Use the same compare tool to compare query results and folders and files on your local machine.
screenshotSchema Compare
screenshotSchema Synchronization
screenshotQuery Results Compare
screenshotFile Compare
screenshotDirectory Compare
ER Modeler
Create and manage ER diagrams with the ER Modeler. From a simple reverse engineering of your existing database to designing a detailed physical ER diagram, you can annotate, forward engineer, perform diffs, generate HTML reports, and more.
screenshotER Diagram Generator
screenshotER Modeler - Script Generator
Download Here
Comments
Post a Comment