Active Query Builder vs. Oracle Analytics Cloud

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Active Query Builder
Score 9.8 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
Oracle Analytics Cloud
Score 8.0 out of 10
N/A
The Oracle Analytics Cloud service is a public cloud service that provides a full set of capabilities to explore and perform collaborative analytics.
$16
per month per user
Pricing
Active Query BuilderOracle Analytics Cloud
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
Professional - BYOL
$0.3226
OCPU per hour
Enterprise - BYOL
$0.3226
OCPU per hour
Oracle Analytics Server for Oracle Cloud Infrastructure
$1.75
OCPU per hour
Professional
$16.00
per month per user
Enterprise
$80.00
per month per user
Offerings
Pricing Offerings
Active Query BuilderOracle Analytics Cloud
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details—OCPUs represent physical CPU cores. Most CPU architectures, including x86, execute two threads per physical core, so 1 OCPU is the equivalent of 2 vCPUs for x86-based compute. The per-hour OCPU rate customers are billed at is therefore twice the vCPU price since they receive two vCPUs of compute power for each OCPU.
More Pricing Information
Community Pulse
Active Query BuilderOracle Analytics Cloud
Top Pros
Top Cons
Features
Active Query BuilderOracle Analytics Cloud
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.1
29 Ratings
1% below category average
Pixel Perfect reports00 Ratings8.026 Ratings
Customizable dashboards00 Ratings8.029 Ratings
Report Formatting Templates00 Ratings8.328 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.5
33 Ratings
6% above category average
Drill-down analysis00 Ratings8.532 Ratings
Formatting capabilities00 Ratings8.332 Ratings
Integration with R or other statistical packages00 Ratings8.725 Ratings
Report sharing and collaboration00 Ratings8.829 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.2
30 Ratings
1% below category average
Publish to Web00 Ratings8.328 Ratings
Publish to PDF00 Ratings8.029 Ratings
Report Versioning00 Ratings8.028 Ratings
Report Delivery Scheduling00 Ratings8.326 Ratings
Delivery to Remote Servers00 Ratings8.322 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.6
29 Ratings
9% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.728 Ratings
Location Analytics / Geographic Visualization00 Ratings8.724 Ratings
Predictive Analytics00 Ratings8.324 Ratings
Pattern Recognition and Data Mining00 Ratings8.73 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.6
26 Ratings
1% above category average
Multi-User Support (named login)00 Ratings8.325 Ratings
Role-Based Security Model00 Ratings8.325 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.826 Ratings
Report-Level Access Control00 Ratings8.84 Ratings
Single Sign-On (SSO)00 Ratings9.022 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.5
21 Ratings
8% above category average
Responsive Design for Web Access00 Ratings8.019 Ratings
Mobile Application00 Ratings8.010 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings8.019 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Active Query Builder
-
Ratings
Oracle Analytics Cloud
8.3
21 Ratings
7% above category average
REST API00 Ratings8.717 Ratings
Javascript API00 Ratings8.316 Ratings
iFrames00 Ratings9.010 Ratings
Java API00 Ratings8.716 Ratings
Themeable User Interface (UI)00 Ratings7.817 Ratings
Customizable Platform (Open Source)00 Ratings7.311 Ratings
Best Alternatives
Active Query BuilderOracle Analytics Cloud
Small Businesses
Syncfusion® Essential Studio®
Syncfusion® Essential Studio®
Score 6.6 out of 10
Yellowfin
Yellowfin
Score 9.0 out of 10
Medium-sized Companies
React
React
Score 9.2 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
React
React
Score 9.2 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 BuilderOracle Analytics Cloud
Likelihood to Recommend
8.6
(5 ratings)
8.5
(37 ratings)
Usability
-
(0 ratings)
8.3
(4 ratings)
Support Rating
-
(0 ratings)
10.0
(1 ratings)
User Testimonials
Active Query BuilderOracle Analytics Cloud
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
Oracle
I would say if you are already using Oracle products, it's smart or wise to utilize this and any other product from Oracle. A bundle package is always helpful. The migration to everything to the cloud makes practical and business sense, given the major upside. Cost and the training associated with it are always an impediment.
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
Oracle
  • Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake.
  • We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs.
  • OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations.
  • OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler.
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
Oracle
  • Reports that output data to portable and mobile devices should be in a better and more appropriate form and improved.
  • In the beginning, the initial settings take some time, which I think requires a smart wizard to set up and get started.
  • Must add mores diagrams and graphs
Read full review
Usability
Active Database Software
No answers on this topic
Oracle
I gave this rating because it's near perfect. A rating is 9 for the tremendous work being put behind the tool. The tool that is safe and easily accessible to all colleagues in the company with the help of various levels of security or data accessibility to each colleague/team. It is fast, accurate, and downloads the data in no time.
Read full review
Support Rating
Active Database Software
No answers on this topic
Oracle
Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.
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
Oracle
If compared with other major BI and data visualization tools ODVC guarantees a higher level o scalability. In fact, ODVC is ideal to be used to cover very complex use cases with data coming from different enterprise systems through different integration technology. ODVC can easily deal with millions of records.
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
Oracle
  • Consolidated data. Cloud analytics makes it easier to gain a unified view, bringing together all your disparate data sources from different business systems in one place.
  • Data preparation – OAC can ingest data from multiple sources, profiling and cleansing data as loaded into the cloud service.
Read full review
ScreenShots