Active Query Builder vs. Dundas BI

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Active Query Builder
Score 9.0 out of 10
Small Businesses (1-50 employees)
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…
$199
per developer
Dundas BI
Score 8.9 out of 10
N/A
Dundas BI is a business intelligence and data visualization software that includes customizable dashboards, reporting, and visual data analytics. Dundas BI can be integrated into users’ existing business applications and its visualization and reporting tools can be customized to their needs.N/A
Pricing
Active Query BuilderDundas BI
Editions & Modules
VCL Edition (Delphi, C++Builder)
$199.00
per developer
Core .NET Edition (non-visual)
$199.00
per developer
ActiveX Edition
$299.00
per developer
WinForms Edition
$399.00
per developer
WPF Edition
$399.00
per developer
ASP.NET Edition
$399.00
per developer
Java Edition
$450.00
per developer
.NET All-in-One Edition
$899.00
per developer
No answers on this topic
Offerings
Pricing Offerings
Active Query BuilderDundas BI
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Active Query BuilderDundas BI
Top Pros
Top Cons
Features
Active Query BuilderDundas BI
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
8.4
51 Ratings
3% above category average
Pixel Perfect reports00 Ratings8.443 Ratings
Customizable dashboards00 Ratings8.651 Ratings
Report Formatting Templates00 Ratings8.139 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
8.1
51 Ratings
0% above category average
Drill-down analysis00 Ratings7.951 Ratings
Formatting capabilities00 Ratings8.250 Ratings
Integration with R or other statistical packages00 Ratings7.633 Ratings
Report sharing and collaboration00 Ratings8.645 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
7.9
49 Ratings
6% below category average
Publish to Web00 Ratings8.442 Ratings
Publish to PDF00 Ratings7.845 Ratings
Report Versioning00 Ratings7.838 Ratings
Report Delivery Scheduling00 Ratings8.337 Ratings
Delivery to Remote Servers00 Ratings7.23 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
7.8
49 Ratings
4% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.148 Ratings
Location Analytics / Geographic Visualization00 Ratings7.941 Ratings
Predictive Analytics00 Ratings7.432 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
8.2
49 Ratings
5% below category average
Multi-User Support (named login)00 Ratings8.648 Ratings
Role-Based Security Model00 Ratings8.045 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.246 Ratings
Single Sign-On (SSO)00 Ratings8.25 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
8.2
45 Ratings
3% above category average
Responsive Design for Web Access00 Ratings8.344 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings8.140 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Active Query Builder
-
Ratings
Dundas BI
7.8
7 Ratings
2% below category average
REST API00 Ratings8.25 Ratings
Javascript API00 Ratings8.66 Ratings
iFrames00 Ratings7.05 Ratings
Themeable User Interface (UI)00 Ratings7.76 Ratings
Customizable Platform (Open Source)00 Ratings7.52 Ratings
Best Alternatives
Active Query BuilderDundas BI
Small Businesses
React
React
Score 8.9 out of 10
BrightGauge
BrightGauge
Score 8.9 out of 10
Medium-sized Companies
React
React
Score 8.9 out of 10
TIBCO Jaspersoft Community Edition
TIBCO Jaspersoft Community Edition
Score 9.7 out of 10
Enterprises
React
React
Score 8.9 out of 10
TIBCO Jaspersoft Community Edition
TIBCO Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Active Query BuilderDundas BI
Likelihood to Recommend
8.5
(5 ratings)
8.3
(52 ratings)
Likelihood to Renew
-
(0 ratings)
7.0
(1 ratings)
Usability
-
(0 ratings)
8.0
(6 ratings)
Support Rating
-
(0 ratings)
8.8
(11 ratings)
Implementation Rating
-
(0 ratings)
7.3
(1 ratings)
User Testimonials
Active Query BuilderDundas BI
Likelihood to Recommend
Active Database Software
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.
Read full review
Dundas Data Visualization
For all the scenarios I have so far worked on or I am currently working on, Dundas BI has proved to be more than adequate and apt to handle all of those. It is a very easy-to-use tool with quick shortcuts enabling you to prepare ad-hoc reports or dashboards in a matter of minutes.
Read full review
Pros
Active Database Software
  • 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.
Read full review
Dundas Data Visualization
  • Project organization from Development to Production, you get a production and development license but I think the best way to do it is with DEV and Prod project in the Production box. Use the development box for testing updates and really crazy things. With the Dev and Prod projects on the same box, you just publish from Dev to Prod and you are done. Users only have access to the Prod projects so no one can mess up what you are working on.
  • Security - If you have a hierarchy (subsidiaries, divisions, department, teams) and you want each group to see only their data, then Security hierarchies are for you!
  • Dependent filters! What's this you ask? Here is an example of how it can be used, in your company you have departments and who works for what department is in your database. You make a dashboard that has a department filter (only show these departments), a managers filter, and employee filter. Not every manager or employee is in multiple departments usually only one. With dependent filters you can say that the manager and employee filter are dependent on what is selected in the departments filter so when you go to filter them they only show the managers or employees that are part of that department, and you can even it do so employees are not only dependent on department but on manager as well. Then it gets even better as it can be done in reverse as well so when you select a manager then go to the department it only shows the departments he works for (there are better situations where this is more useful).
  • It is scriptable! From calculate columns, null replacements, button actions, load actions, hover over events there a way to do what you want.
  • They are constantly improving and listens to your suggestions.
Read full review
Cons
Active Database Software
  • 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
Read full review
Dundas Data Visualization
  • Not too many cons for how we use the application. It really is easy and powerful. Very powerful.
  • Licensing is one thing that could be looked into. It is simple, but a little confusing. For example, if I get a license today, but a new release comes out tomorrow, it seems that the license doesn't work with the new release. Maybe that is by design, but it would be nice to clearly understand.
Read full review
Usability
Active Database Software
No answers on this topic
Dundas Data Visualization
We are still in the implementation phase, but so far we are finding it to be easy to use and learn. The eLearning courses that they have made available for free, as well as User Forums and other training videos have made even difficult concepts easier to understand.
Read full review
Support Rating
Active Database Software
No answers on this topic
Dundas Data Visualization
We have bi-weekly calls with our Success Manager, as well as access to support as needed. Any question that I have had, multiple people have been willing and able to jump on a call to talk me through it, or send an email with the solution
Read full review
Implementation Rating
Active Database Software
No answers on this topic
Dundas Data Visualization
Providing that you have the client's needs well known, creating BI content using Dundas BI is a walk in the park!
Read full review
Alternatives Considered
Active Database Software
I have used Flutter to begin and with flutter you need learn a language called Dart which is not needed with AQB, which is the main reason for us to pick Active Query Builder as a choice over Flutter. AQB supports all the merchant SQL databases with native syntax support, query optimizations and more
Read full review
Dundas Data Visualization
Per dollar spent, it offers the widest range of features of the tools that we evaluated. It offers lots of options for how to configure your environment, though they are not always intuitive to figure out. Having an ETL layer was a must have for us, as well as the ability to host to secure HIPAA compliance. It is not a replacement for ad hoc reporting, but does a great job of creating parameterized reports and dashboards that look great.
Read full review
Return on Investment
Active Database Software
  • better business decisions allow us to maximize revenue for the company
  • awesome ROI
Read full review
Dundas Data Visualization
  • Coming from an SQL based standard delivery model, Dundas BI has provided a fantastic rate of ROI.
  • The preparation and delivery time has reduced from weeks to just a few hours.
Read full review
ScreenShots

Dundas BI Screenshots

Screenshot of Dundas BI Dashboard Sample - EducationScreenshot of Dundas BI Dashboard Sample - Sales Team PerformanceScreenshot of Dundas BI Dahsboard Sample - Sales PerformanceScreenshot of Dundas BI Dashboard Sample - InsuranceScreenshot of Dundas BI Dashboard Sample - EmbeddedScreenshot of Dundas BI Dashboard Sample - Sales and Marketing