TechValidate Research on AquaFold

These pages present data that TechValidate has sourced via direct research with verified customers and users of AquaFold. TechValidate stands behind the authenticity of all published data. Learn more »



393 Customers Surveyed

3,121 Data Points Collected

199 Published TechFacts

20 Published Charts

28 Published Case Studies



Featured Research Collections for AquaFold

Curated collections and slideshows of TechValidate research data on AquaFold.



Selected Research Highlights


Aqua Data Studio Customer Research

What percentage of your databases are deployed in the cloud (instead of on premises)?

Greater than 75%: 13%
51% to 75%: 5%
26% to 50%: 12%
10% to 25%: 12%
Less than 10%: 59%

Aqua Data Studio Case Study

Medium Enterprise, Computer Software, USA

Introduction

This case study of LivePerson, Inc. is based on an October 2017 survey of Aqua Data Studio customers by TechValidate, a 3rd-party research service.

“There is a definitive time-saving in being able to manage all data sources within a single framework. Prior to Aqua Data Studio, we would have to remote into firewalled servers and run queries through remote windows. With Aqua Data Studio we no longer have to do that. We no longer have to worry about adding tools for additional data sources as we know Aqua Data Studio will be able to handle them.”

“The multi-platform and data source feature of Aqua Data Studio is by far my most used capability. The query tools are great.”

Challenges

The business challenges that led the profiled company to evaluate and ultimately select Aqua Data Studio:

  • Used the following products before selecting Aqua Data Studio:
    • IDERA (Embarcadero) Rapid SQL
    • Quest Toad
    • Oracle SQL Developer
    • MySQL Workbench
    • Microsoft SSMS
    • Microsoft Visual Studio / SSDT
    • DbForce Studio
    • EMS SQL Manager for SQL Server
  • Top challenges or pain points:
    • Managing a complex database environment with multiple database platforms
    • Pressure to constantly improve performance on production code
    • Tracking database sessions, instances, and security
    • Comparing and synchronizing data and schema objects between databases
    • Collecting data from queries and putting it in useful formats for evaluation and analysis
    • Managing version control for both SQL scripts and database files
  • Was looking for the following features when considering Aqua Data Studio:
    • Support multiple database platforms, including relational, NoSQL, and cloud
    • Compare and synchronize data and schema objects from same or different databases
    • Reverse-engineer databases into a physical ER diagram
    • Easily build complex SQL queries with a flexible user interface
    • Create, edit, and execute SQL statements, then view and filter the results
    • Develop and debug scripts to automate routine database operations
    • Create visualizations to analyze data with an easy-to-use drag and drop interface

Use Case

The key features and functionalities of Aqua Data Studio that the surveyed company uses:

  • Has the following database platforms in their database architecture:
    • Relational database
    • Relational cloud-based database
    • NoSQL/big data database
    • Data warehouse
  • 26% to 50% of their databases are deployed in the cloud.
  • Uses the following Aqua Data Studio features most often:
    • Database object navigator
    • Query builder
    • Query analyzer (SQL editor)
    • Database administration tools

Results

The surveyed company achieved the following results with Aqua Data Studio:

  • Improved the following:
    • Improved SQL query performance for creation, edits, and debugging
    • Increased efficiency for SQL development tasks
    • Improved consistency within and across database designs
    • Streamlined management of SQL script and database file versions
    • Reduced time and effort spent creating visual reports to analyze data
    • Improved and accelerated data and schema object synchronization
    • Improved their understanding of databases with ER diagrams
    • Simplified tool usage (one tool to manage more tasks)
  • Rated improvement seen in the following areas:
    • Analyzing data from query results: remarkable improvement
    • Managing version control: notable improvement
    • Comparing and syncing between DBs: remarkable improvement
    • Creating, editing, and executing queries: remarkable improvement
    • Reverse-engineering to the ER model: notable improvement

Aqua Data Studio Customer Testimonial

Like Best for Medium Enterprise, Retail, Italy

I like best that Aqua Data Studio provides autocompletion and editing of results in a table. It lets me do my work in a very fast way.

Alessandro Lachina, Application Developer, Ali Supermercati S.P.A.

Aqua Data Studio Customer Satisfaction Rating

Recommended for Small Business, Computer Software, USA

Mark Phillips, an Engineering Director at Mophilly, would be very likely to recommend Aqua Data Studio for this reason:

Aqua Data Studio has the features that I need for the design and administration of database systems.

Aqua Data Studio Case Study

State & Local Government, USA

Introduction

This case study of Origami-Analytics LLC is based on a February 2019 survey of Aqua Data Studio customers by TechValidate, a 3rd-party research service.

“I have used Aqua Data Studio since version 4 so that it has been one of my “must have” tools for over 10 years.”

“We like best that AquaScript can automate complex tasks, Query Analyzer provides great code completion, and we can morph to a delimited list.”

Challenges

The business challenges that led the profiled organization to evaluate and ultimately select Aqua Data Studio:

  • Top challenges or pain points:
    • Managing a complex database environment with multiple database platforms
    • Comparing and synchronizing data and schema objects between databases
    • Simplifying and automating admin tasks to focus on other work
    • Collecting data from queries and putting it in useful formats for evaluation and analysis
  • Used the following products before selecting Aqua Data Studio:
    • Quest Toad
    • Microsoft Visual Studio / SSDT
  • Was looking for the following features when considering Aqua Data Studio:
    • Support multiple database platforms, including relational, NoSQL, and cloud
    • Install and run the tool on Linux or Mac OS instead of Windows
    • Compare and synchronize data and schema objects from same or different databases
    • Reverse-engineer databases into a physical ER diagram
    • Create, edit, and execute SQL statements, then view and filter the results
    • Edit table data from query results with an Excel-like grid with copy-and-paste capabilities
    • Develop and debug scripts to automate routine database operations
    • Create visualizations to analyze data with an easy-to-use drag and drop interface

Use Case

The key features and functionalities of Aqua Data Studio that the surveyed organization uses:

  • Has the following database platforms in their database architecture:
    • Relational database
    • Relational cloud-based database
  • Have 1 to 10% of their databases deployed in the cloud (instead of on-premises).
  • Features of Aqua Data Studio used most often:
    • Query analyzer (SQL editor)
    • Table data editor (Excel-like grid)
    • Compare and synchronization tools
    • Visual analytics
    • ER modeler
    • Database administration tools

Results

The surveyed organization achieved the following results with Aqua Data Studio:

  • Improved the following:
    • Improved SQL query performance for creation, edits, and debugging
    • Increased efficiency for SQL development tasks
    • Improved consistency within and across database designs
    • Improved and accelerated data and schema object synchronization
    • Improved their understanding of databases with ER diagrams
    • Simplified tool usage (one tool to manage more tasks)
  • Improvement seen in the following areas:
    • Comparing and syncing between databases: a notable improvement
    • Analyzing data from query result: a remarkable improvement
    • Creating useful charts and graphs: a remarkable improvement

Aqua Data Studio Customer Research

Top Team Impact

How has Aqua Data Studio helped your team?

Simplified tool usage - one tool to manage more tasks
72%
Increased efficiency for SQL development tasks
69%
Improved SQL query performance for creation, edits, and debugging
56%


More to Explore



About AquaFold

AquaFold builds tools to help organizations deliver innovative solutions to real-world problems using its database, collaborative and analytics products.

AquaFold Website   Idera, Inc. Website