Active Query Builder vs. SAP Lumira Discovery

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Active Query Builder
Score 9.2 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
SAP Lumira Discovery
Score 7.6 out of 10
N/A
SAP Lumira Discovery is SAP’s data visualization and discovery application. It facilitates data discovery, visualization, and analysis by assisting users with creation of dashboards, infographics, presentations, data facets, tag clouds, and more.
$185
per user
Pricing
Active Query BuilderSAP Lumira Discovery
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
SAP Lumira, standard edition
$185
per user
Offerings
Pricing Offerings
Active Query BuilderSAP Lumira Discovery
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 BuilderSAP Lumira Discovery
Top Pros
Top Cons
Features
Active Query BuilderSAP Lumira Discovery
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Active Query Builder
-
Ratings
SAP Lumira Discovery
7.5
96 Ratings
9% below category average
Customizable dashboards00 Ratings7.596 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Active Query Builder
-
Ratings
SAP Lumira Discovery
7.6
102 Ratings
6% below category average
Drill-down analysis00 Ratings7.799 Ratings
Formatting capabilities00 Ratings7.9102 Ratings
Report sharing and collaboration00 Ratings7.497 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Active Query Builder
-
Ratings
SAP Lumira Discovery
7.2
94 Ratings
15% below category average
Publish to Web00 Ratings7.781 Ratings
Publish to PDF00 Ratings7.693 Ratings
Report Delivery Scheduling00 Ratings6.355 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Active Query Builder
-
Ratings
SAP Lumira Discovery
5.6
103 Ratings
36% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.2101 Ratings
Location Analytics / Geographic Visualization00 Ratings6.794 Ratings
Predictive Analytics00 Ratings2.072 Ratings
Best Alternatives
Active Query BuilderSAP Lumira Discovery
Small Businesses
Syncfusion Essential Studio Enterprise Edition
Syncfusion Essential Studio Enterprise Edition
Score 8.5 out of 10
BrightGauge
BrightGauge
Score 8.9 out of 10
Medium-sized Companies
React
React
Score 8.9 out of 10
Reveal
Reveal
Score 9.9 out of 10
Enterprises
React
React
Score 8.9 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Active Query BuilderSAP Lumira Discovery
Likelihood to Recommend
8.5
(5 ratings)
6.8
(104 ratings)
Usability
-
(0 ratings)
7.8
(14 ratings)
Availability
-
(0 ratings)
9.0
(1 ratings)
Performance
-
(0 ratings)
7.0
(1 ratings)
Support Rating
-
(0 ratings)
7.0
(11 ratings)
In-Person Training
-
(0 ratings)
6.0
(1 ratings)
Online Training
-
(0 ratings)
6.0
(1 ratings)
Implementation Rating
-
(0 ratings)
10.0
(3 ratings)
Configurability
-
(0 ratings)
2.0
(1 ratings)
Ease of integration
-
(0 ratings)
5.0
(1 ratings)
Product Scalability
-
(0 ratings)
6.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
8.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
8.0
(1 ratings)
User Testimonials
Active Query BuilderSAP Lumira Discovery
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
SAP
Infographics derived from specific data sources appears to be well suited for development using Lumira. The development of executive level dashboards was less appropriate from my perspective. The software does not provide sufficient demonstration or samples for the users to learn from in my opinion.
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
SAP
  • SAP has built in features you would expect from a data visualization package, like easy import from other SAP systems.
  • SAP has most of the typical charts that you would expect in order to visualize your data.
  • SAP allows you to have multiple charts on one visualization for your data.
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
SAP
  • Even though the process of creating visualizations of data is now greatly improved, it could still be a lot better as users become accustomed to this kind of tool and bring forward edge cases the developers did not anticipate.
  • It would be awesome to have a cross platform tool that works on more than just Windows.
  • Some options for specific graphs feel limiting.
Read full review
Usability
Active Database Software
No answers on this topic
SAP
SAP Lumira is very good self service analytical tool with powerful capabilities. However need to look into other SAP products in BI space, like SAP SAC. SAP Lumira is more used for custom and complex analytical need in business intelligence area. Also SAP Lumira is going out of maintenance in coming future replaced by SAP SAC.
Read full review
Reliability and Availability
Active Database Software
No answers on this topic
SAP
Lumira is a desktop application runs in its own JVM. It installs its own java runtime libraries to avoid any core java version conflicts. The availability of the application is completely relies on individual machine hardware configuration. On a decent desktop, it performs well and always launches in either 32 or 64 bit environment based on the hosts system's OS
Read full review
Performance
Active Database Software
No answers on this topic
SAP
The performance is linear with amount of data that is being explored. We have done some benchmarks acquiring 10million data cells without having any performance problems. We need to make proper adjustments to jvm run time properties to start with higher heap size and other parameters that optimizes the run time performance
Read full review
Support Rating
Active Database Software
No answers on this topic
SAP
It does not have many bugs or issues since not a lot of new features are being added. The customer support for SAP Lumira Discovery is good and anyone considering this as a self-service tool would be happy. It integrates well in the SAP BI suite of products and the overall experience is positive.
Read full review
In-Person Training
Active Database Software
No answers on this topic
SAP
We did not take in-person training
Read full review
Online Training
Active Database Software
No answers on this topic
SAP
Most of the user guides are pretty comprehensive and very easy to understand. The product itself is designed to be self-serve tool, did not need much of the end-user training. Most of the training we had is to how to read the data, how to explore the data, how to acquire the data etc.
Read full review
Implementation Rating
Active Database Software
No answers on this topic
SAP
Installing the desktop software on end-user machines is always challenging. The machine specifications are the biggest factor when running Lumira and be able to handle large datasets during data exploration. This often demands beefy machines at least for power-users. Although Lumira software licensing is not a big problem but managing partner's extensions and keeping track of their individual licenses may be an issue. If there is a way to bundle the more popular extensions such as vSQL or vOLAP should be bundled in core product and offer them as part of Lumira license instead of a separate license which causer operational burden.
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
SAP
Even though SAP Analytics Cloud is considered to be better in aspects such as data connectivity or analytics, we decided to choose Lumira as it was easier to understand, learn and use. As our business is not really that big and does not require the inclusion of large amounts of data, Lumira was overall the safest and most comfortable option. Also, some members in our team had previous knowledge so it was easier to adapt
Read full review
Scalability
Active Database Software
No answers on this topic
SAP
Enterprise wide implementation is a challenge with data security and trustedness. No easy installation can be done across the enterprise. no upgrade paths also available from SAP. They have so much of experience with desktop implementation, there it could be a controlled environment with a capital budget. These may be resolved in the upcoming releases
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
SAP
  • We could obtain original data from vast and detailed corporate and personal data sources.
  • We could share visual analysis results with stakeholders via the cloud, and it could also be viewed on a tablet.
  • It is very flexible and accurate to use. It can be used for forecasting sales, resource planning, and scheduling.
Read full review
ScreenShots

SAP Lumira Discovery Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of