Active Query Builder

Active Query Builder

Active Database Software
+
+

Related Products

  • SurveyJS
    64 Ratings
    Visit Website
  • DbVisualizer
    585 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • Jotform
    8,651 Ratings
    Visit Website
  • JOpt.TourOptimizer
    10 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • ManageEngine EventLog Analyzer
    211 Ratings
    Visit Website
  • Maropost Marketing Cloud
    152 Ratings
    Visit Website
  • ActiveCampaign
    17,291 Ratings
    Visit Website
  • Google Cloud Platform
    61,049 Ratings
    Visit Website

About

A system is worthwhile for business only if it helps make business decisions, so looking at the data from different angles is crucial for business decision makers. Allowing end-users to instantly get the data they need adds value to your software, reduces end user churn, and provides a competitive advantage. It takes up to several workdays to add a new report to an IT system. Adding and maintaining dozens of reports overloads your developers, and is one of the reasons why you can't ship new versions on time. With Active Query Builder, users take control and responsibility for creating and maintaining their reports. Users can reconfigure reports whenever they need to with zero intervention from your side. If you're already using a reporting system in your app, Active Query Builder will add value to it by allowing you to create new data sources for reports.

About

QuerySurge is the enterprise-grade data quality platform that continuously automates the validation of data across your entire ecosystem ‐ from data warehouses and big data lakes to BI reports and enterprise applications. With AI-powered test creation, a scalable architecture, and seamless CI/CD integration, QuerySurge consistently ensures data integrity at every stage of the pipeline: accelerating delivery, reducing risk, and enabling confident decision-making. Use Cases - Data Warehouse & ETL Testing - Big Data Testing - DevOps for Data / DataOps / Continuous Testing - Data Migration Testing - BI Report Testing - Enterprise App/ERP Testing QuerySurge Features - Data Validation: enterprise-grade platform - AI: Automatically create data validation tests - BI Report Testing: Fully automated, no-code approach - DevOps for Data (DataOps): API w/60+ calls & Swagger docs, integrate continuous testing into your CI/CD pipelines - Data Connectors: For 200+ platforms

Platforms Supported

Windows Supported
Mac Not Supported
Linux Not Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Supported
Mac Not Supported
Linux Supported
Cloud Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Active query builder solution for product owners

Audience

Testers, Data Architects, ETL Developers, BI Analysts, & Operations teams

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Supported

Screenshots and Videos

Screenshots and Videos

Pricing

$199.00 one-time payment
Free Version Not Supported
Free Trial Supported

Pricing

Pricing can be found at QuerySurge's website.
Free Version Not Supported
Free Trial Supported

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 5.0 / 5
support 4.0 / 5

Reviews/Ratings

Overall 5.0 / 5
ease 4.9 / 5
features 4.9 / 5
design 4.5 / 5
support 5.0 / 5

Pros & Cons from Real Users

Pros

  • Very interactive user interface and very easy to use the software. Allows users to analyze their queries by converting them to a visual diagram.

Cons

  • Sometimes large updates can cause minor bugs. Integration with other tools and become hard.

Pros & Cons from Real Users

Pros

  • Quick Ramp up time. Quick Support. Documentation. Certifications that can be earned for the product.
  • QuerySurge offers in depth analysis of your data sets and provides meaningful feedback on discrepancies it finds and can be automated to correct said entries. The AI wizard is very helpful in creating test cases.
  • There is so much this software can do and even with all its features it's still relatively simple to use. No SQL is necessary with the QuerySurge Wizard which is very helpful for any user to be able to use this software.
  • QuerySurge is a great product. As a ETL Tester the tool allowed me to seamlessly connect to my source and target databases. Supports a ton of technology from Oracle DBs to flat files. Highly recommended for any data related testing.
  • QuerySurge is a tool that was very easy to navigate and ensures the validation of big data as well as all types of data. The QuerySurge Wizard option allows you to validate your data without any knowledge of SQL which is amazing! This tool also allows you to have various connections to retrieve data from, giving a plethora of options!

Cons

  • I have not had any significant problems that support could not explain very easily.
  • Can feel a bit daunting at times with how many features are available but they provide fantastic customer support and certification courses to assist the user.
  • There are so many different features which at first can be overwhelming for the lay person but thankfully after a short while the features become intuitive and an invaluable resource for obtaining meaningful data from such large sets.
  • UI seems a bit old fashioned. Some times navigation seems a little confusing. Don't worry though support team helps out with any issues you have!
  • QuerySurge has too many features! This is definitely a good thing once you get used to it, but at first it can be a little tricky! Once you get all the features down, QuerySurge becomes the most powerful tool to use!

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Supported
Live Online Supported
In Person Supported

Company Information

Active Database Software
Founded: 2005
Canada
www.activedbsoft.com

Company Information

RTTS
Founded: 1996
United States
www.querysurge.com

Alternatives

Alternatives

DBHawk

DBHawk

Datasparc
Keysight Eggplant

Keysight Eggplant

Keysight Technologies
Tricentis Tosca

Tricentis Tosca

Tricentis

Categories

Database Supported

Categories

Automated Testing Supported
Big Data Supported
Continuous Testing Supported
Data Analysis Supported
Data Governance Supported
Data Migration Supported
Data Pipeline Supported
Data Quality Supported
Data Validation Supported
Data Warehouse Supported
Database Supported
ETL Supported
Functional Testing Supported
NoSQL Database Supported
Test Management Supported

Database Features

Backup and Recovery Not Supported
Creation / Development Not Supported
Data Migration Supported
Data Replication Not Supported
Data Search Not Supported
Data Security Not Supported
Database Conversion Not Supported
Mobile Access Not Supported
Monitoring Not Supported
NOSQL Not Supported
Performance Analysis Not Supported
Queries Supported
Relational Interface Not Supported
Virtualization Not Supported

Automated Testing Features

Hierarchical View Supported
Move & Copy Supported
Parameterized Testing Supported
Requirements-Based Testing Supported
Security Testing Not Supported
Supports Parallel Execution Supported
Test Script Reviews Not Supported
Unicode Compliance Not Supported

Big Data Features

Collaboration Not Supported
Data Blends Not Supported
Data Cleansing Not Supported
Data Mining Not Supported
Data Visualization Not Supported
Data Warehousing Not Supported
High Volume Processing Not Supported
No-Code Sandbox Not Supported
Predictive Analytics Supported
Templates Not Supported

Data Analysis Features

Data Discovery Not Supported
Data Visualization Not Supported
High Volume Processing Not Supported
Predictive Analytics Supported
Regression Analysis Not Supported
Sentiment Analysis Not Supported
Statistical Modeling Not Supported
Text Analytics Not Supported

Data Quality Features

Address Validation Not Supported
Data Deduplication Not Supported
Data Discovery Supported
Data Profililng Not Supported
Master Data Management Not Supported
Match & Merge Not Supported
Metadata Management Not Supported

Data Warehouse Features

Ad hoc Query Not Supported
Analytics Not Supported
Data Integration Not Supported
Data Migration Not Supported
Data Quality Control Supported
ETL - Extract / Transfer / Load Not Supported
In-Memory Processing Not Supported
Match & Merge Not Supported

ETL Features

Data Analysis Supported
Data Filtering Not Supported
Data Quality Control Supported
Job Scheduling Supported
Match & Merge Not Supported
Metadata Management Not Supported
Non-Relational Transformations Not Supported
Version Control Supported

Functional Testing Features

Automated Testing Supported
Interface Testing Not Supported
Regression Testing Supported
Reporting / Analytics Supported
Sanity Testing Not Supported
Smoke Testing Supported
System Testing Not Supported
Unit Testing Not Supported

Test Management Features

Automation Integration Supported
Collaboration Tools Not Supported
Pass/Fail Results Tabulation Supported
Reporting / Analytics Supported
Requirements Management Not Supported
Test Scheduling Supported
Test Tracking Supported
Time/Budget Tracking Not Supported

Integrations

Amazon DynamoDB Not Supported
Amazon Redshift Not Supported
Azure Data Lake Not Supported
Azure Database for PostgreSQL Not Supported
Azure Databricks Not Supported
Databricks Not Supported
IBM Cognos Analytics Not Supported
IBM Db2 Big SQL Not Supported
Microsoft Power BI Not Supported
MySQL Not Supported
Oracle Database Not Supported
Oracle Database@AWS Not Supported
SAP BusinessObjects Business Intelligence Not Supported
SAP HANA Not Supported
SQL Server on Azure Virtual Machines Not Supported
Salesforce CRM Analytics Not Supported
Snowflake Not Supported
Tableau Not Supported
Teradata Enterprise AgentStack Not Supported
Teradata VantageCloud Not Supported

Integrations

Amazon DynamoDB Supported
Amazon Redshift Supported
Azure Data Lake Supported
Azure Database for PostgreSQL Supported
Azure Databricks Supported
Databricks Supported
IBM Cognos Analytics Supported
IBM Db2 Big SQL Supported
Microsoft Power BI Supported
MySQL Supported
Oracle Database Supported
Oracle Database@AWS Supported
SAP BusinessObjects Business Intelligence Supported
SAP HANA Supported
SQL Server on Azure Virtual Machines Supported
Salesforce CRM Analytics Supported
Snowflake Supported
Tableau Supported
Teradata Enterprise AgentStack Supported
Teradata VantageCloud Supported
Claim Active Query Builder and update features and information
Claim Active Query Builder and update features and information
Claim QuerySurge and update features and information
Claim QuerySurge and update features and information