Active Query Builder vs. Chartio (discontinued)

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Active Query Builder
Score 9.1 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
Chartio (discontinued)
Score 7.5 out of 10
N/A
Chartio is a visualization tool designed to enable anyone to explore, transform and visualize data on the fly through a drag-and-drop interface. Chartio was acquired by Atlassian in February 2021 so that it's capabilities could be integrated into the Atlassian product portfolio's capabilities. Chartio is no longer available to new customers, standalone. Existing customers must migrate to alternatives by March 2022, when the service will be retired.
$40
per user/per month
Pricing
Active Query BuilderChartio (discontinued)
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
Starter
$40
per user/per month
Professional
$60
per user/per month
Organization
Contact sales team
Offerings
Pricing Offerings
Active Query BuilderChartio (discontinued)
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 BuilderChartio (discontinued)
Top Pros
Top Cons
Features
Active Query BuilderChartio (discontinued)
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Chartio (discontinued)
6.0
18 Ratings
33% below category average
Pixel Perfect reports00 Ratings3.614 Ratings
Customizable dashboards00 Ratings7.718 Ratings
Report Formatting Templates00 Ratings6.714 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Chartio (discontinued)
5.7
14 Ratings
34% below category average
Drill-down analysis00 Ratings6.913 Ratings
Formatting capabilities00 Ratings6.112 Ratings
Integration with R or other statistical packages00 Ratings3.15 Ratings
Report sharing and collaboration00 Ratings6.513 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Active Query Builder
-
Ratings
Chartio (discontinued)
3.4
17 Ratings
85% below category average
Publish to Web00 Ratings2.79 Ratings
Publish to PDF00 Ratings6.117 Ratings
Report Versioning00 Ratings2.05 Ratings
Report Delivery Scheduling00 Ratings2.712 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Active Query Builder
-
Ratings
Chartio (discontinued)
7.5
15 Ratings
9% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings7.215 Ratings
Location Analytics / Geographic Visualization00 Ratings7.212 Ratings
Predictive Analytics00 Ratings8.03 Ratings
Best Alternatives
Active Query BuilderChartio (discontinued)
Small Businesses
Syncfusion Essential Studio Enterprise Edition
Syncfusion Essential Studio Enterprise Edition
Score 8.6 out of 10
BrightGauge
BrightGauge
Score 8.9 out of 10
Medium-sized Companies
React
React
Score 8.9 out of 10
Mathematica
Mathematica
Score 8.3 out of 10
Enterprises
React
React
Score 8.9 out of 10
Dataiku
Dataiku
Score 8.6 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Active Query BuilderChartio (discontinued)
Likelihood to Recommend
8.5
(5 ratings)
8.0
(30 ratings)
Likelihood to Renew
-
(0 ratings)
8.0
(24 ratings)
Usability
-
(0 ratings)
7.6
(6 ratings)
Availability
-
(0 ratings)
8.6
(2 ratings)
Performance
-
(0 ratings)
7.3
(1 ratings)
Online Training
-
(0 ratings)
8.2
(1 ratings)
Implementation Rating
-
(0 ratings)
7.3
(1 ratings)
Product Scalability
-
(0 ratings)
6.8
(2 ratings)
User Testimonials
Active Query BuilderChartio (discontinued)
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
Atlassian
Chartio is a great tool for building presentable dashboards. It can export, you can add read-only access, and it has permissions levels by dashboard for users. There are other data analysis tools that help to analyze the data, but few allow for such a nice presentation
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
Atlassian
  • Direct linkage to our databases. Abstracts away the visualization layer so we can focus on the data and the queries.
  • Host of graphs and tools that permits all types of data visualizations.
  • Haven't quite used this yet, but there is a new embedding feature that will be very helpful so that we can embed the charts into a company central dash.
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
Atlassian
  • There is not a last full month date range option. You can still get the range that you need, but the dashboards will have to be manually updated to exclusively display one whole month.
  • When building a chart, the area which displays your tables and fields is finite. You can't adjust the size to make it easier to see. They do allow a mouse-over to see the entire name of your table/field, but I would prefer to adjust the width.
  • Once you modify a query in the Custom Query tab, there doesn't seem to be a way to go back to using the U.I.
Read full review
Likelihood to Renew
Active Database Software
No answers on this topic
Atlassian
Great customer support: You will receive an answer by email usually within 20-30 minutes. Not only that but our CSMs for Chartio go out of their way to help, they have even created charts for some of the less experienced users that wanted an example to work from. We have had nothing but great experiences with this team.
Read full review
Usability
Active Database Software
No answers on this topic
Atlassian
I really like using Chartio. I use it on a daily basis for pulling data from different sources and combining data (the explore tab was a great idea for this use). I think I would give it 8/10 because there needs to be more documentation or maybe blog posts about things people are doing with it. I only have my own ideas about what to do /how to graph things. I know there are some articles, but it would be awesome to have a section on the neat dashboards people are building or how they show data in different ways. Another complaint is how much time it takes to load. I know our databases aren't set up precisely for Chartio and I have been creating data stores. But the data stores have so many more limitations that adds a whole new layer of frustration. Love the product, keep up the good work and the fast fixes.
Read full review
Online Training
Active Database Software
No answers on this topic
Atlassian
I use self learning materials. Pretty helpful. I find myself having to go back to the "drilldown" instructions though, and have a hard time finding hidden variables on a dashboard, so perhaps there is room for intuitive improvements (or maybe I'm just being lazy)
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
Atlassian
Chartio so far has been the easiest BI tool to setup and has also been the most affordable. There are some other, great, BI tools out there but they were a bit to heavy handed for what we needed. Also - despite the high cost per user in Chartio, the other tools were still more expensive.
Read full review
Scalability
Active Database Software
No answers on this topic
Atlassian
Chartio has worked well as our datawarehouse has rapidly expanded, and the usability/performance hasn't seemed to have suffered. What we haven't yet realized is additional savings from additional users. We have some dashboard needs for users who truly just view of a few charts, and the licensing structure hasn't yet been structured in a way that would support that type of approach...having 50 "core" licenses, and then potentially several hundred view only licenses for partners that would use the application infrequently.
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
Atlassian
No answers on this topic
ScreenShots

Chartio (discontinued) Screenshots

Screenshot of Sample Executive DashboardScreenshot of Sample Zendesk DashboardScreenshot of Chartio's SQL Mode Chart CreatorScreenshot of SQL EditorScreenshot of Query BuilderScreenshot of Data Pipeline