Active Database Software

Active Query Builder

5 / 5 6 reviews

Who Uses This Software?

Business application developers who work on a software dealing with SQL databases.


Average Ratings

6 Reviews
  • 5 / 5
    Overall
  • 4.5 / 5
    Ease of Use
  • 5 / 5
    Customer Service

Product Details

  • Starting Price
    $199.00/one-time/user
  • Pricing Details
    Lifetime license with 1 year of priority support and free upgrades.
  • Free Trial
    Yes
  • Deployment
    Installed - Windows
  • Training
    Documentation
  • Support
    Online
    Business Hours

Vendor Details

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

About Active Query Builder

Active Query Builder is a component for business applications which helps users without any SQL experience to work with SQL queries and get data fast. With Active Query Builder, users can get a clear view of database schema and design SQL queries with natural point-and-click actions rather than tedious typing. It works with dozens of database servers, supports lots of SQL dialects and development environments. Programmers get full control over the user's queries to deny unauthorized data access.


Spotlight-media-placeholder

Active Query Builder Features

  • Backup and Recovery
  • Data Migration
  • Data Replication
  • Data Security
  • Database Conversion
  • Mobile Access
  • NOSQL
  • Performance Analysis
  • Queries
  • Relational
  • Virtualization

Active Query Builder Reviews Recently Reviewed!


Simply ... a stunning piece of software for querying databases

Aug 27, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: From a developers perspective this tool is a joy to use, allowing simple drag and drop use (with very little code behind required) to a very customisable tool that can be fully integrated into your own application's environment. It allows you to provide your own end users with the freedom to interrogate their own data using a simple yet familiar visual paradigm or, for those who actually posses a good working knowledge of SQL the ability to create really quite complex queries to answer their specific needs, needs which I, as the application developer might not have even considered that they wanted.

The 'SQLTextEditor' is a joy to behold offering not only good syntax highlighting but SQL intellisense as well (particularly useful for SQL novices). Equally impressive is the ability of the tool to allow you to create a textual query and then have it produce a visual representation of it.

Within a very short time of trialing this you'll realise just what a superb tool you have found, and at the same time be cursing yourself for not having discovered it sooner. If you are looking for a way to allow your end users access to the database that holds the data your application is creating on their behalf that can is intuitively simple to use then look no further.

Cons: If I were to voice one criticism it would be that the documentation is perhaps not yet as comprehensive as it might be, although in fairness that is a failure acknowledged by the vendor themselves and is being corrected. However that isn't in reality that big a deal as the support that they offer is superb and that, from the perspective of a developer using a third party component, is worth it's weight in gold.

Overall: I have an application that uses a very complex underlying database. It has proved impossible for me to predict every which way that end users would want to query their data and whilst I'm not averse to creating new views for end users one persons wishes will not always suit everyone else's. Active Query Builder is the perfect solution, providing comprehensive visual access to data in a safe and controlled environment.

Great product! Real value for money!

May 31, 2018
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: The client did not had any way of extracting data directly from the database. With AQB and a little technical knowledge the client can themselves create custom reports as per their requirement. Previously the client had to spend money for the generating the reports and also had to wait until the reports are coded.

AQB provides a safe way of extracting data without actually creating user or granting user access on the server. This provides another layer of security.

Prompt responses on the support tickets.

Cons: It's common for there to be small bugs in each new release. With each upgrade, we have to open a ticket with AQB to get the issues resolved.

It would be helpful if AQB is made compitable with Bootstrap.

Hard to find solutions for the issues faced during integrations in the documentation provided by AQB.

Vendor Response

by Active Database Software on September 03, 2018

Hello, Shrenik.
Thank you for your feedback.
I am glad to inform you that the latest version 3.3 of Active Query Builder ASP.NET Edition is compatible with Bootstrap visual styles.

The go-to visual query designer

Sep 05, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: -> A very powerful query designer with an easy to use interface

-> Greatly adaptable to fit a whole range of applications and custom user requirements

-> The product is constantly updated and improved in meaningful ways

-> Exceptional customer support and feedback, to put it lightly

Cons: -> There are usually minor bugs with larger updates, but these are always quickly squashed

Overall: Our company has been using the Query Builder application for four years at the time of writing. The application is robust enough to create and manipulate a wide array of queries yet intuitive so that clients who have never created a SQL query before can manipulate their data and generate accurate summaries of their data in minutes. Should any error occur, a support team that sets the standard in speed and professionalism is a mere email away.

Overall, a highly recommended application

Simply a Great Software Component - and Exceptional Support

Aug 27, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: - Good quality software - it simply works

- Excellent support. Cannot say enough here!!

- Easy to get started with.

- Very powerful component set - works with all the DBs they say it does.

Cons: The documentation, while decent, could use a little work. The basics are easy to get going - but you need some support to get into the truly advanced features. However, that is where the AQB team comes to the rescue. Their support is very good.

Overall: IT has allowed our users to easily create complex queries and provides the various tools to make our software powerful and truly usable by our customers.

The software is easy to setup and use - and the support is outstanding. I would recommend AQB to anyone looking to provide a visual query building interface.

Professional application

Aug 27, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Very effective and easy to implement solution

Cons: A little difficult for our end users use union

Great product

Jul 09, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Easy to construct a SQL statement by using the drag/drop functionality. The after sales support is amazing, the guys really go over and above to assist you. Easy to implement into your own product.

Cons: Cant really fault anything on the product, it works really good! The look and feel could be better as its using a default JQuery UI

Vendor Response

by Active Database Software on September 03, 2018

Hello, Damian.
Thank you for your feedback.
I am glad to inform you that the latest version 3.3 of Active Query Builder ASP.NET Edition is compatible with Bootstrap visual styles.