Aqua Data Studio

---

Aqua Data Studio

Original author(s)	Niels Gron
Developer(s)	AquaFold, Inc.
Initial release	2002 (2002)
Stable release	19.5.0. / 21 February 2019 (2019-02-21)
Written in	Java
Engine
Operating system	Cross-platform (Microsoft Windows, Linux, and Apple MacOS)
Platform	Java
Available in	9 languages
List of languages American English, French, German, Japanese, Korean, Portuguese (Portugal), Simplified Chinese, Spanish, Traditional Chinese
Type	database IDE, visual analytics
License	Trialware
Alexa rank	Global Rank 313,626 53,641, Rank in United States 211,631
Website	www.aquafold.com/aqua-data-studio

Search Aqua Data Studio on Amazon.

Aqua Data Studio

Aqua Data Studio is an integrated development environment (IDE) for data sources such as Microsoft Excel and databases. It integrates database management, database design, database administration, SQL programming, data management, and visual analytics into a single application software. Aqua Data Studio is intended for use by software developers, database administrators, business analysts, and data analysts. It is commonly used for exploratory data analysis and data visualization, specifically for business intelligence.

Aqua Data Studio uses proprietary database drivers to connect to a range of databases including relational databases, NoSQL databases, and cloud databases. It also uses the Java database connectivity (JDBC) and open database connectivity (ODBC) application programming interfaces (APIs) to interact with databases via JDBC and ODBC database drivers. It integrates with the programming language R for computational statistics.

Aqua Data Studio is a desktop application software that is written in Java with a graphical user interface. It is proprietary software that is distributed under a software license for commercial software as trialware.

Aqua Data Studio is being developed by AquaFold, Inc. which is a division of Idera, Inc. in Houston, Texas.

Refer also to the German (Deutsche), Italian (Italiano), and Spanish (Español) version of this page.

History

Aqua Data Studio was created in 2001 by Niels Gron shortly after founding AquaFold, Inc. in Sunnyvale, California. Its first release to general availability was in 2002.

In July 2017 AquaFold was acquired by Idera, Inc. in Houston, Texas .

Aqua Data Studio is currently part of the portfolio of Idera, Inc. under the brand of AquaFold, Inc. .

Feature summary

The prominent software features of Aqua Data Studio are :

• database administration
• entity relationship modeler
• grid and pivot table charts
• import and export of data
• database scripting shell
• JavaScript shell for MongoDB
• database schema object search
• open application programming interface (open API)
• database schema comparison with synchronization and data comparison
• secure shell (SSH) environment
• SQL debuggers
• SQL history
• SQL and analysis tool
• table data editor
• version control with clients for Apache Subversion (SVN), Concurrent Versions System (CVS), Git, and Perforce
• visual analytics including integration with R for computational statistics
• visual explain query plan
• visual SQL builder

Data sources

Aqua Data Studio can query proprietary and open-source platforms, relational databases, NoSQL databases (including column-oriented databases and document-oriented databases), embedded databases, in-memory databases, distributed databases, massively parallel processing (MPP) databases, data warehouses, and spreadsheets. Further, Aqua Data Studio can connect to additional data sources via Java database connectivity (JDBC) and open database connectivity (ODBC).

Natively, Aqua Data Studio can connect to the following data sources:

• Amazon Redshift
• Apache Cassandra
• Apache Derby
• Apache Hive, Apache Impala, and Apache Spark
• Google BigQuery
• Greenplum
• IBM Db2 for iSeries
• IBM Db2 for LUW
• IBM Db2 for z/OS
• IBM Informix
• IBM Netezza
• Microsoft Excel
• MariaDB
• Microsoft Azure SQL Database
• Microsoft SQL Server
• MongoDB
• MySQL (also on Amazon Aurora and Google Cloud SQL)
• Oracle Database
• ParAccel Analytic Platform
• PostgreSQL (also on Amazon Aurora and Google Cloud SQL)
• SAP Adaptive Server Enterprise (ASE)
• SAP HANA
• SAP IQ
• SAP SQL Anywhere
• SQLite
• Teradata Aster Database
• Teradata Database
• Vertica
• VoltDB

Platforms

Aqua Data Studio is a cross-platform application software written in Java that executes on Microsoft Windows, Linux, and Apple MacOS .

Languages

Aqua Data Studio is available in American English, French, German, Japanese, Korean, Portuguese (Portugal), Simplified Chinese, Spanish, and Traditional Chinese .

Versions

The list of the released versions of Aqua Data Studio is :

Release version	Date	Notable features
1.0	2002
1.5	2003
2.0	2003
3.0	2003
3.5	October 2003	DDL and DML scripting for tables, views, stored procedures, and triggers; pop-up query analyzer; SQL history window; Oracle Database DBMS_OUTPUT support; text history results; print SQL scripts and results; open and save scripts and query results in differing encoding types
3.7	June 2004	Visual object editors for developers and database administrators; visual explain plan; schema extraction and SQL scripting for developers and database administrators; import tool; new look and feel; encoding support for Eastern languages; Microsoft SQL Server named instances
4.0	February 2005	Visual editing for security; enhanced and customizable query analyzer; variable binding; export tool
4.5	August 2005	Database script generator; ER diagram generator; procedure editor; enhanced save results; enhanced visual explain and explain whiteboard; enhanced query analyzer; enhanced import and export; visual editing
4.7	May 2006	Oracle Database DBA tools; visual query builder; super auto-completion; SQL formatter; parameterized scripts; shortcut toolbar; schema browser filtering; mountable server connections; query analyzer permissions
6.0	January 2007	Apple OSX and Microsoft Windows integration; enhanced object or column permission dialog; schema browser scripting; customizable view for objects; enhanced schema and script browser
6.5	October 2007	Version control support for Subversion and CVS; pivot grid and graphs; grid graphs; grid aggregate functions; SQL history archive; results compare tool; Sybase and Oracle Debuggers
7.0	October 2008	ER modeler; support Apache Derby and IBM Db2 iSeries; localized to 11 languages; IBM Db2 and Microsoft SQL Server debuggers; MySQL and IBM Db2 DBA tools; charts; compare tools; version control repository browsers
7.5	April 2009	Memory optimizations; localized to 21 languages; JavaScript and Java Editors; enhanced editor; new chart types; support Subversion 1.5; file search tool; DBA tools storage manager
8.0	October 2009	Memory optimizations; support Aster nCluster, DB2 z/OS, Teradata, and Subversion 1.6; object search tool; schema object sorting; enhanced schema compare tool; visual editing permissions
9.0	October 2010	Open APIs; AquaScripts; Support IBM Netezza; enhanced charts and ER modeler; table and index partitioning; source control status indicators; form results tab; configurable query results
10.0	September 2011	SSH environment; multi-threaded user interface; Support Git and Perforce; autosave workspace; compression tool; PDF viewer; operating system shell integration; shortcut toolbar folders; enhanced grid and pivot grid chart
11.0	May 2012	Support ParAccel, Microsoft SQL Server 2012; SQL log capture; SSH browser; enhanced ER modeler; scripting Sybase ASE server role permissions; enhanced pivot grid
12.0	October 2012	FluidShell to automate database interactions; big data performance; more powerful user interface; connection pooling; database upgrades; support SVN 1.7
13.0	May 2013	Support Greenplum, SQLite, Vertica, IBM Netezza 7, Sybase ASE 15.7, Sybase IQ 15.4, and MySQL 5.5
14.0	October 2013	Support MongoDB, Hive, Cassandra, Microsoft SQL Database, Oracle Database 12c, Sybase IQ 16, MySQL 5.6, SQLite 3.7.15; revamped Git client
15.0	September 2014	Support Amazon Redshift, VoltDB, Vertica 7, IBM Db2 10.5, MongoDB 2.6, more bulk import, more Hive distributions; visual analytics; revamped query builder
16.0	March 2015	Enhanced visual analytics; pin query analyzer results; DB2 z/OS visual explain plan; improved Microsoft Excel performance; support Sybase ASE 16.0, Sybase Anywhere 16.0, SQL Server 2014, MongoDB 3.0, Apache Hive 0.14, Amazon EMR Hive, Hortonworks 2.2, and Cloudera 5.2
17.0	February 2016	Support SAP HANA, Google BigQuery, Apache Spark, newer Hive distributions, and DB2 z/OS 11; MongoJS query analyzer; DBA tools for 11 more databases; visual explain plans for 7 more databases; Microsoft Excel SQL SELECT using WHERE; Microsoft Excel import wizard; enhanced visual analytics
18.0	March 2017	Redesigned editors; schema synchronization; AquaScript templates; Google BigQuery enhancements; visual explain plans for Amazon Redshift and Teradata; connection monitor; enhanced visual analytics; support MongoDB 3.4, Microsoft SQL Server 2016, newer Hive distributions, PostgreSQL 9.5, and Vertica 8
18.5	December 2017	Database enhancements for Apache Cassandra, Vertica, Google BigQuery and IBM Netezza; improved table calculation dialog, open workbook processing; label deck for bar charts; enhanced table data editor; SQL history archive; key bindings
19.0	May 2018	Enhanced flexibility for docking framework; schema synchronization for MySQL, PostgreSQL, and Sybase IQ; visual explain Plans for Hive, Spark, and Impala; MongoDB support for views; Decimal128 data type, and collation, and object search for Google BigQuery; numerous platform version updates, enhanced visual analytics
19.5	February 2019	Support MariaDB; platform currency for Apache Derby, Microsoft SQL Server, MySQL, PostgreSQL, Teradata, and more; updates for Amazon Aurora for MySQL and PostgreSQL, and Google SQL Cloud for MySQL and PostgreSQL; enhanced visual analytics

Features

The prominent features of Aqua Data Studio are :

• Database administration tools to manage core aspects of database servers with managers for database instances, storage, security, and sessions.

• An entity-relationship (ER) modeler to create and manage entity-relationship diagrams, reverse engineer existing databases , design detailed physical entity-relationship diagrams, annotate , forward engineer, perform differencing, and generate HTML reports.

• Grid and pivot table charts to pivot data and create charts based on the pivoted data. Further, choose from a comprehensive range of chart types and customize each chart. All charts update in real-time based on the result set of queries.

• Import and export data of different formats to and from databases, database tables, database schema objects, and data files .

• A database scripting shell that combines the power of a SQL command-line interface with the versatility of a Unix shell.

• A JavaScript shell for MongoDB with nearly identical syntax and functionality to the native MongoDB shell.

• A search tool for database schema objects to quickly find any object within the database server. Focus searches by filtering for object type with wildcards and restricting searches.

• A scripting development environment with an open application programming interface (open API) to develop and debug scripts to automate database tasks using the full set of functionality of the application software.

• Compare and synchronize the data definition language (DDL) of database schema objects from different databases in the graphical user interface. See differences at the level of databases and objects and synchronize source schemas to target schemas. Use the same tool to compare result sets from SQL and folders and files on local machines.

• A secure shell (SSH) environment to register and connect to multiple SSH database servers and execute commands in a graphical user interface with tabbed windows. For added security, it also has a key generator and key passphrase agent.

• SQL debuggers to trace and debug stored procedures to identify any development or production issues.

• A SQL history tool to quickly retrieve any previous queries without losing them.

• An advanced SQL analyzer to connect to any database server and execute queries . Format SQL, highlight syntax with color, and autocomplete to save time in writing SQL. View result sets of SQL in plain text, grid, pivot table, and form views with filtering and export.

• A table data editor to edit the result set of an executed query on a database table using the graphical user interface to alter data and add and delete database rows using an editable, spreadsheet-like grid.

• A full and integrated version control client for Apache Subversion (SVN), Concurrent Versions System (CVS), Git, and Perforce to manage scripts and other database files from within the application software.

• Visual analytics to create data visualizations and dashboards to explore and share. Recognize patterns and estimate trends to find opportunities for further analysis. Use filters, data labels, and database table calculations to create charts to improve business decisions, manage risk, and solve complex problems. Integrate with R for computational statistics.

• Visual explain query plans to display an execution query plan to tune queries to improve the performance of queries and database servers .

• A Visual SQL builder to select database tables directly from the graphical user interface, and then specify database columns to retrieve, join, sort, and filter in a grid format. Along with selecting database tables and adding SQL parameters, the visual SQL builder generates complete statements that can be viewed, copied, and executed from the dialog window of the visual SQL builder.

Licensing

Aqua Data Studio is a desktop application software with a trialware software license and end-user license agreement to prevent copyright infringement .

Support

• AquaFold, Inc. provides customer support via help desk software .
• Users can get support via the virtual community Internet forum of AquaFold, Inc. .
• User can get support via the software documentation and blog posts of Aqua Data Studio .
• Users can view case studies, datasheets, streaming media digital videos of product demonstrations, webcasts, and white papers in the learning resource center of Aqua Data Studio .
• Users can request personalized, one-on-one product demonstrations .
• Users can register for scheduled, interactive, group-based web conferences .

Notable users

Notable users include Anaqua , CenturyTel , Comcast , Croatian Post , Deutsche Bank , Duke University , Fox Chase Cancer Center , Huawei , International Informix Users Group (UUIG) , Kaiser Permanente , LivePerson , Mississippi College , Natixis Global Asset Management , Naver , Thomas Cook Airlines , and Troy University

See also

• Altova DatabaseSpy
• Business intelligence software
• Comparison of data modeling tools
• Comparison of database tools
• DBeaver
• DBEdit 2
• Domo
• Dundas
• GoodData
• HeidiSQL
• IBM Cognos
• JetBrains DataGrip
• Microsoft Power BI
• Microsoft SQL Server Management Studio
• MySQL WorkBench
• Navicat Premium
• Oracle Enterprise Manager
• Oracle SQL Developer
• Orbada
• Quest Software Toad
• Sisense
• SQuirreL SQL Client
• SQL Database Studio
• Tableau Software
• TOra
• Upscene Productions Database Workbench
• Qlik QlikView
• Webyog SQLyog

References

This article "Aqua Data Studio" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Aqua Data Studio. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.

📰 Article(s) of the same category(ies)

• Cyllista Game Engine
• WebSocketRPC
• Codacy
• CloudTest
• Vtiger Customer Relationship Management
• D-Back
• Electra Protocol

---