Active Query Builder Reviews and Ratings

Rating: 9.8 out of 10

Score

9.8 out of 10

Community insights

TrustRadius Insights for Active Query Builder are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Useful Tool for SQL Queries: Active Query Builder has proven to be a valuable tool for users in preparing SQL queries for any database. Many reviewers have expressed their satisfaction with the ability to visually create queries and test them on different database servers.

Easy Data Transformation: Users highly appreciate the seamless data transformation capabilities of Active Query Builder. The software makes it easy to convert various file formats such as CSV, XML, Text, and Excel files into SQL format.

Constant Improvement and Responsive Support: Active Query Builder consistently receives positive feedback regarding its continuous improvement efforts. Reviewers find it impressive how the software caters to both newcomers and experienced professionals. Additionally, users praise the support team for their fast, friendly, and professional assistance with prompt responses on support tickets.

Reviews

5 Reviews

It makes it possible to create queries in a simple and fast way.

Rating: 9 out of 10

Incentivized

June 22, 2022

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.

Likelihood to Recommend

This is a good framework to use if your project requires frequent database queries. The product is made for both complete amateurs and seasoned experts. Prompt, courteous, and expert assistance; any problems are addressed and fixed without delay. Relatively inexpensive Inadequate, if there are new people involved, delays due to a lack of documentation are likely, and issues with code completion may arise.

Verified User

Analyst in Information Technology (10,001+ employees)

Vetted Review

3 years of experience

Faster and safer query creation

Rating: 7 out of 10

Incentivized

March 10, 2022

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

Likelihood to Recommend

Query creation is possible with being a sql server user, this is a well suited use-case for us. This helped us in controlling our user access on the sql servers. The major issue is safety auditing of data corruption on server, this way we are able to limit the data corruption .

Nagendhar Reddy Vuppunuthula

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

Vetted Review

1 year of experience

View profile

Active Query Builder - Great software for querying DB

Rating: 8 out of 10

Incentivized

March 7, 2022

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

Likelihood to Recommend

Suited 1) If the project involves lot querying to DB, this is apt framework 2). The product is designed to be used for anyone ranging from newcomers to professionals. Very fast, friendly, and professional service, if any issues are discovered they are quickly acknowledged and dealt with in a timely manner.3) Cost-effective Not suited - If there are new folks, lack of documentation will delay things, Sometimes code completion cause problems.

Kalavati Singh

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

Vetted Review

1 year of experience

Active Query Builder - a powerful handy little tool!

Rating: 9 out of 10

Incentivized

March 2, 2022

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.

Likelihood to Recommend

It is a good one for business users who are in no way technical and do not have any insights about the backend databases and do not have any SQL experience. They can simply go in and create queries without any SQL knowledge by just using a drag and drop way..now tell me how cool is that? :)

Verified User

Employee in Information Technology (10,001+ employees)

Vetted Review

10 years of experience

Great Tool for creating robust queries

Rating: 9 out of 10

Incentivized

March 2, 2022

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

Likelihood to Recommend

primarily for orgs with a lot of data that is not centralized, this helps visualize data that is not easily accessible

Verified User

Manager in Sales (501-1000 employees)

Vetted Review

1 year of experience