Active Query Builder

Score9.8 out of 10

8 Reviews and Ratings

What is 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. Users can get a clear view of database schema and design SQL queries with natural point-and-click actions rather than tedious typing.

Active Query Builder assists novice users learning SQL and allows experienced users to analyze and understand their queries better by parsing them and building the visual diagram.

With Active Query Builder, programmers get full control over the user's queries to deny unauthorized data access so that it's safe to allow even non-technicians run SQL queries against the database.

Active Query Builder works with dozens of database servers, including Oracle, MS SQL Server, MySQL, PostgreSQL, DB2 and many others. It supports all popular SQL dialects and development environments. You can add it to various desktop and web projects .NET WinForms, WPF, WebForms, ASP.NET MVC, ASP.NET Core, Delphi, C++Builder, Java (Swing control), ActiveX.

Integration of Active Query Builder requires little attention from developers. The component's fine tuning can be performed later by an admin with the built-in setup module.

Categories & Use Cases

Kalavati Singh

Program Manager in Information Technology at Thougthworks (10,001+ employees employees)

Use Cases and Deployment Scope

It's a great framework to query databases, Our company has been using the Query Builder application for a couple of 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

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."
Software is brilliant for all sorts of reporting we use it daily and do extremely complex SQL reports across MSSQL, PSQL, MySQL, and ODBC.
Very effective and easy to implement solution
If you want to prepare SQL queries for any database this is for you.
This provides another layer of security.
Review collected by and hosted on G2.com.

Cons

Features are good but lacks documentation
It would be great it were adaptive to Embarcadero/Dev Express Skins that would be very cool
Modifying SQL code is difficult

Most Important Features

Simple and fast execution of querying DB
Exceptional customer support and feedback, to put it lightly
The 'SQLTextEditor' is a joy to behold offering not only good syntax highlighting but SQL IntelliSense as well (particularly useful for SQL novices)."

Return on Investment

The tech depts were cleared faster and had high impact on quality
Active Query Builder is the perfect solution, providing comprehensive visual access to data in a safe and controlled environment.

Alternatives Considered

Flutter, by Google, Selenium and Cognia (formerly Measured Progress and AdvancED)

Other Software Used

Corcentric Source-to-Pay Platform (Determine / Selectica), Flutter, by Google, JobProgress

Nagendhar Reddy Vuppunuthula View profile

Principal Software Engineer in Information Technology at AVEVA (5001-10,000 employees employees)

Use Cases and Deployment Scope

Easy and safe way of SQL extraction is needed without actually allowing users access to SQL . Hence this allow users of a wide spectrum to write SQL queries for dashboards. we are using the Query Builder component to do exactly that use-case and it solves the requirement needed for our purpose.

Pros

Safer way of extracting data without creation of user or providing access on the Sql server
Using query builder to allow wide spectrum users to create dashboards
Review the risk of data corruption

Cons

More flexibility in query creation
Token based or Jwt access control as optional feature
More interactive analytical dashboards

Most Important Features

Query builder without being user
Data safety and corruption risk elimination
Very fast query execution

Return on Investment

Helped in data safety auditing
Dashboards help decision making better
Easy query creation reduces training time for professionals

Alternatives Considered

AWS Database Migration Service and AWS IoT Analytics

Other Software Used

AWS Batch, AWS CloudFormation, AWS CloudTrail

Verified User

Analyst in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

We have used the Query Builder program for a few years now, and it has proven to be an excellent platform for querying databases. Clients who have never made a SQL query before may easily edit their data and obtain accurate summaries of their data in minutes because of the application's straightforward design and powerful query manipulation capabilities. In the unlikely event of a problem, you can reach a helpful support staff that consistently exceeds expectations in response time and expert-level service with just a quick email. Overall, it's a great program that you should try out.

Pros

Using the Query Builder, a large group of people may collaborate on dashboard development.
This is the place to be if you need to build SQL queries for any database.
Extraction data is made more secure by not requiring the formation of a user or the provisioning of access on the SQL server.

Cons

Improved query customization options.
Aside from some missing documentation, the features are solid.
Access control using either tokens or Jwt is a feature that may be enabled.

Most Important Features

Data integrity and loss prevention.
Quick response times for queries.
Database queries may now be executed quickly and easily.

Return on Investment

It takes less time to teach experts because queries can be created easily.
Clearing out the technical departments was easier and had a greater effect on quality.
Since it allows users to see all of their data in one place while keeping it secure, Active Query Builder is the optimal choice.

Alternatives Considered

QlikView

Other Software Used

React, Flutter, by Google, AWS Database Migration Service, AWS CodeBuild, AWS Backup

Verified User

Employee in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

It is a query tool for retrieving data from SQL for users even without any SQL database experience. It is best suited for business users who work on data and software dealing with SQL databases. It gives a clear view of the database schema. Unfortunately, it does not have a free version hence I will give a 9!

Pros

Pull data from SQL even if you do not know SQL.
Provides clear database information.
Works with multiple databases at once.
Data access and security.

Cons

Pricing - no free version..they should provide one for evaluation.
Not so easy to use core SQL function for end users.
It can be more user friendly or may be more of user guidance providing tips to users.
And perhaps a better documentation of the product.

Most Important Features

It's ease of use or user friendly.
Features are good..can be improved.
Integration which can be quick.

Return on Investment

Active Query Builder provides a safe way of extracting data without actually creating users or granting user access.
And the above point gives another layer of security.
With no or little technical knowledge any one can create custom reports.

Alternatives Considered

Quickbase

Other Software Used

Microsoft Power BI, Adobe Analytics, MariaDB Platform

Verified User

Manager in Sales (501-1000 employees employees)

Use Cases and Deployment Scope

active query builder allows our company to centralize the data into a warehouse and then allows us to build awesome data visuals which in turn makes for better business decisions

Pros

quick data visuals
better business decisions

Cons

user interface

Most Important Features

providing a user friendly environment to create sql queries
users ability to use this tool with limited sql knowledge

Return on Investment

better business decisions allow us to maximize revenue for the company
awesome ROI

Alternatives Considered

Tableau Desktop