Aqua Data Studio
Versatile database IDE with data management and visual analytics for relational, cloud, and NoSQL databases
Why Aqua Data Studio
Database developers are tasked with creating software applications that include complex business logic and access ever-changing database ecosystems, while database administrators must manage these complex environments that may incorporate a myriad of platforms and versions. Today’s database environments are growing exponentially in volume, velocity,
and variety, making the database professionals’ roles even more challenging and time-consuming. Additionally, database developers are expected to work seamlessly across disparate DBMSs and integrate their work with source control systems as part of their regular software development cycle.
Database administrators have different levels of responsibilities, and it depends on exactly what they are managing. Those that need a generalpurpose tool to compare and synchronize schema objects and data and to track database sessions, instances and security will find that Aqua Data
Studio meets these needs and more for many different platforms.
Business and data analysts often need to manipulate the data from the SQL queries in order to use it for analysis and decision-making, but they don’t need a high-end technical tool for this. Visual Analytics lets them create beautiful visualizations and dashboards of the data to explore or share with others. Reduce costs for non-power users with Aqua Data Studio.
Aqua Data Studio provides an extensive toolset that combines SQL scripting, query building, and debugging with database object navigation and table data editing, to address the variety of tasks being done by database professionals. Aqua Data Studio’s single interface lets developers work across database platforms so organizations can standardize on one solution and maximize database development efficiency
Overview of Aqua Data Studio Benefits
Database IDE With A Workspace Environment
Aqua Data Studio is a modern database IDE that provides users with a workspace environment to streamline and automate the administration and designing of databases, regardless of their type or class. This workspace environment enables them to organize and navigate through query windows, files, and documents with flexibility.
Visual analytics is among the noteworthy features available in Aqua Data Studio. Designed with an easy-to-use drag-and-drop interface, Aqua Data Studio lets users create different visual representations of data by pulling in query results and aggregating datasets into individual pages which are referred to as worksheets.
These worksheets then together with the visual representations that comprise them can be placed on dashboards that provide a single and summary view of the worksheets. The layout of the dashboards can also be customized and their content can be filtered, making them more interactive. These dashboards can be shared with colleagues and customers, and worksheets can be saved in workbooks so others can explore and analyze data.
Watch an eight minutes long demo of Visual Analytics.
Advanced Query And Analysis Tools
Aqua Data Studio is built with query and analysis tools which permit users to connect to database servers and create and execute queries effortlessly. One of these tools is its powerful visual query builder which enables them to construct SQL queries without the need of typing any SQL statements. In addition, they will be able to directly select tables or views directly from Aqua Data Studio’s UI using column selection options. A rich set of visual options are also provided in order for users to combine SQL properties which include JOINs, indexes, operators, aliases, and criteria.
Another query and analysis tool offered by Aqua Data Studio is its advanced query analyzer. This tool helps users save time in writing SQL statements. It has the capability to automatically insert frequently used SQL statements in a code such as select, deselect, or insert. Through its SQL abbreviation feature, users can define SQL abbreviations to automatically complete lengthy blocks of SQL statements with just a few keystrokes. The query analyzer delivers a feature called Pivot and Charts which assist users in quickly analyzing large amount of table data and generating graphical representations of datasets.
Powerful Table Data Editor
Aqua Data Studio is equipped with a powerful table data editor that has grid editing features and functionalities similar to Excel. Users will be able to fill, copy or paste, or find and replace cell data like how they do it in Excel. The table data editor also checks whether the entered data has the proper format based on its type. In addition, color codes are applied to cells as users edit table data. This way, they can easily track the changes they have made.
Object Search And Visual Editing
To quickly search for objects within a database, Aqua Data Studio introduces a tool named as Object Search Tool. With this tool, database objects can be searched based on type, schema name, object name, column name, index columns, constraint columns, trigger columns, or systems objects. Search results can also be filtered and sorted. As users browse database objects, Aqua Data Studio lets them visually edit these objects.
Entity Relationship Modeler
Aqua Data Studio comes with an ER or Entity Relationship modeler which is used to build and manage ER diagrams and physical database models. It supports the creation of physical database models for all major RDBMS or Relational Database Management System vendors and versions. The modeler permits users to reverse engineer existing databases so they can generate and visualize database structures and models. They can import tables and views from databases to their ER models as well as compare two ER models. The ER modeler can also forward engineer models into databases. Thus, ER diagrams are converted into DDL or Data Definition Language scripts.
Schema Comparison With Synchronization
The database IDE provides compare and synchronization tools which enable users to identify the differences in DDL between two schema objects from different databases. Through the aid of a color-coded grid, they will be able to quickly view the differences between schema objects. Differences can be deployed from the source schema to the target schema, allowing synchronization between the two schemas. Additionally, the results of the schema comparison can be saved as an HTML report.
Interactive Database Shells
Aqua Data Studio is built with interactive database shells which make the administration of databases a breeze. One of these database shells is the FluidShell, a database shell which integrates the functionality of a Unix shell with the SQL command line. As a result, it enables users to automatically extract, transform, and load data from a single database shell.
Integrated SQL Debuggers
Summing it up, Aqua Data Studio offers integrated SQL debuggers for Oracle, IBM DB2 UDB, Microsoft SQL Server, and Sybase ASE. With these debuggers, users can debug stored procedures, functions, and packages. They will be able to easily assess the variables and conditional flows of codes by setting breakpoints and using stepping functionalities – step into, step over, and step return.
• Visually create and execute SQL queries against multiple database platforms
• Access and alter query data quickly and easily with a convenient table data editor
• Create visualizations to analyze data with an easy-to-use drag-and-drop interface
• Compare and synchronize data and schema objects from same or different databases
• Develop and debug scripts to automate routine database operations
• Installs and runs on Windows, Linux, and Mac OS X
• Universal IDE for Databases
• Visual Analytics
• Query and Analysis
• Visual Query Builder
• Query Analyzer
• Object Search Tool
• Visual Object Editing
• Table Data Editor
• ER Entity Relationship Modeler
• Schema Compare with Synchronization and Data Compare File Compare
• MongoShell for MongoBD
• Database Administration Tools
• Integrated SQL Debuggers
• Import and Export
• SSH (Integrated Secure Shell)
• Open APIs
• Integrated SVN, Git, CVS and Perforce Version Control
• Spectacular 2D and 3D Charts
• Visual Explain Plans
Supported operating systems
• Chinese (Simplified | Traditional)
• Portuguese (Portugal)
• Amazon Redshift
• Apache Cassandra - 3.x, 2.x
• Apache Derby - 10.x
• DB2 iSeries - V7Rx, V6Rx
• DB2 LUW - 11.1, 10.x, 9.x
• DB2 z/OS - V12, V11, V10, V9
• Greenplum - 5.6, 4.3
• Generic JDBC
• Generic ODBC
• Google BigQuery
• Hive, Impala, Spark connectors within these distributions:
Amazon EMR - 5.x
Apache - 2.1
Cloudera - 5.1.x
Hortonworks - 2.6.x
MapR - 5.2.x
• Informix - 12.x, 11.x
• MariaDB - 10.2
• Microsoft Azure SQL Database
• Microsoft SQL Server - 2017 - 2000
• MongoDB - 3.4, 3.2, 2.6
• MySQL - 8.0, 5.x
Amazon Aurora MySQL - 5.7
Google MySQL - 5.7
• Netezza - 7.x
• Oracle - 12c, 11g, 10g, 9i
• ParAccel Analytic Platform - 5.x, 4.x
• PostgreSQL - 10.4, 9.x
Amazon Aurora PostgreSQL - 9.6
Google PostgreSQL - 9.6
• SAP HANA -2.0, 1.0
• SQLite - 3.x
• Sybase Anywhere - 17.0, 16.0
• Sybase ASE - 16.0, 15.x, 12.x
• Sybase IQ - 16.0, 15.x
• Teradata Aster Database - 7.x, 6.x
• Teradata Database - 16.x, 15.0, 14.0
• Vertica - 9.1, 8.0
• VoltDB - 8.0, 7.0
• Annual subscription
• Cloud Hosted
• Open API
Aqua Data Studio Licensing
• Licensing Options
o Single license key per user – Normally used by groups with less than 50 users.
o One Enterprise license for single key distribution for named users – Generally used by groups with 50 to 200 licenses.
o One Enterprise license for single key distribution for all users – Generally used by organizations with 200+ licenses.
• Subscription -Provide access to customer support, maintenance and upgrades to the purchased software product.
• Evaluation – You may download and evaluate a fully functional version of Aqua Data Studio for 14 days before purchasing a license.
IDERA Product Support is included with every purchase of IDERA software. IDERA´s goal is to provide their customers with the assistance and information they need to achieve success with IDERA's products. 24x7 worldwide customer support is available to IDERA customers that hold a current maintenance contract.
Supporthelp can be received at: https://www.idera.com/support/productsupport
IDERA Customer Support Portal includes:
Access information about IDERA products that you have purchased
Search our Knowledge Base
Submit/track technical support cases
Review current product versions and release dates.