Aqua Data Studio

Aqua Data Studio is a productivity software for Database Developers, DBAs and Analysts. It allows you to develop, access, manage and visually analyse data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports all major database vendors, works on all major operating systems and is localised to 9 languages.

Aqua Data Studio's Visual Analytics allows you to analyse data with an easy-to-use drag & drop interface. You can pull query results into worksheets to create beautiful visualisations of your data, you can create dashboards by dragging in visualisations from many worksheets and you can save and share them in workbooks with colleagues and customers allowing them to easily navigate and interact with your data.

Key Features:

• Database IDE: Aqua Data Studio is a modern IDE with a workspace environment. A Docking & Windowing framework allows tabbed documents for query windows, which can be grouped or floated for flexibility.
  
• Query & Analysis Tool: An advanced Query Analyser 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.
  
• Visual Analytics: Create beautiful visualisations and dashboards of your data to explore or share with others. Identify patterns and trends to find opportunities for further analysis. Giving you the ability to improve business decisions, limit risk and solve difficult problems.
  
• 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.
  
• 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.
  
• 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.

Aqua Data Studio - Features

Current Features

• Microsoft SQL Server 2012: Now with native support.
• ParAccel Analytic Platform: Now supports ParAccel, a leading enterprise analytic platform provider.
• SQL Log Capture: Gives you total insight by logging all SQL queries executed by the application along with the execution time.
• Support for Secure Shell Browser: Allows our customers to remotely view system resources, including hardware information, for any registered SSH server.
• ER Modeler Enhancements: Supports newer versions of Teradata, PostgreSQL, Sybase IQ, Sybase ASE and nCluster.
• Query & Analysis Tools: Including a pivot grid, charting tool, auto completion, visual explain, multi results format and SQL formatter.
• 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.
• SQL Debuggers: Including Oracle, Sybase, DB2 and SQL Server debuggers.
• SSH Terminal: Register and connect to as many SSH servers as you need and run commands in a tabbed window GUI.
• Compare Tools: Including schema, file, text, directory and results compare.
• ER Modeler: Used in designing, editing and reverse engineering database schemas
• Visual Query Builder: 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.
• Table Data Editor: Allows you to edit the result-set of an executed query on a table using a convenient graphical interface. Import & Export Tools: Allows data of different formats to be imported and exported to and from databases, tables, objects and files.
• Autosave Workspace: Automatically saves your workspace content and layout and reopens it exactly as you had it the next time the application is started.
• Shortcut Toolbar Enhancements: Allows grouping shortcuts into user-created folders so that all shortcuts can be opened at once.
• Multithreaded UI: GUI has been designed to implement a multithreaded architecture.
• Integrated Compression Tool: Includes an integrated Compression Tool which can compress or uncompress files and folders directly from the IDE as well as encrypt and decrypt with 128, 192 and 256 AES Encryption.
• Integrated PDF Viewer: Includes an integrated fully featured Portable Document Format (PDF) Viewer.
• OS Shell Integration and File MIME Types: Users can associate file types to open them in Aqua Data Studio by double-clicking on the file within the operating system.
• Grids, Pivot Grids and Charts: Can be opened in Excel or Emailed as an Excel attachment directly from the results with one click.
• Quick Excel and Excel 2007 Support: Users can view and export data from Aqua Data Studio grids and pivot grids to MS Excel 2007.
• ER Modeler: Users can edit entity and region colors on a per-entity basis, hide relationship lines, Auto-fit entities and use @ as a statement separator when generating scripts.
• Database IDE: Workspace Environment and Docking & Windowing Framework
  

Aqua Data Studio - System Requirements

Recommended System and Hardware

• Dual Core Processor (Intel/AMD)
• 1 GB of RAM
• Minimum 200 MB of Disk space

• Dual Core Processor (Intel/AMD)
• 1 GB of RAM
• Minimum 200 MB of Disk space

• Dual Core Processor (Intel/AMD)
• 1 GB of RAM
• Minimum 200 MB of Disk space