Active Query Builder

What is Active Query Builder?

Ad-hoc reports

• Allow users to query your database for the data they currently need.
• Incorporate the visual query builder into your reporting system to allow accurate data selection for custom reports.

Data filtering

• Allow users to define filters for fields and columns of database objects from the provided query, through practical tree-like control.
• Change the classification and calculate the totals for a given dataset.

Data import

• Connect to the external database
• Create SQL queries to extract data
• Map query columns to internal database object fields for data import

Active Query Builder is a component for software developers to enable users to create SQL queries visually and get data from SQL databases quickly and securely.

Active Query Builder is a complete set of features for programmers to handle SQL queries and make the database schema clear to end users. It has powerful SQL analyzer and API to analyze, modify and create new queries from scratch.

Active Query Builder is designed to:

Developers

• Enable ad-hoc reporting for business users
• Provide users with secure access to data
• Set up data flow in your app the way you need it

Database administrators

• Control data access permissions while querying data at all levels: objects, fields, and records
• Analyze SQL queries and understand complex structures

Database users

• Get data in seconds
• Create queries quickly without sql knowledge
• View SQL queries and database schema as a diagram

Get SQL database data quickly and securely

• Active Query Builder provides easy access to data within SQL databases for users with any level of experience in SQL and database management. Create queries with smart drag'n'drop instead of typing tediously.
• Integration with your software solution takes only a few minutes, so users can extract the data they need immediately to handle business tasks without hitting a wall.
• Bridge your data and access it regularly, such as an Excel spreadsheet

System requirements

WinForms and WPF editions of Active Query Builder

Native WinForms and WPF component, for .NET 4.0+ with optional support of DevExpress WinForms controls

Active Query Builder ASP.NET Edition

Web component for WebForms, ASP.NET MVC, and Core with client or server rendering

Active Query Builder Java Edition

Swing-based Java Bean component for all modern Java development environments

Active Query Builder ActiveX Edition

ActiveX control (COM object) for multiple development environments

Active Query Builder VCL Edition

Delphi and C++ Builder component set for VCL or DevExpress VCL libraries

End-user SQL query tool for Windows

Create SQL queries and work with data with dozens of database servers