Active Query Builder vs. OpenText Magellan

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
OpenText Magellan
Score 9.0 out of 10
N/A
OpenText Magellan Analytics Suite leverages a comprehensive set of data analytics software to identify patterns, relationships and trends through data visualizations and interactive dashboards.N/A
Pricing
Active Query BuilderOpenText Magellan
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 BuilderOpenText Magellan
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Active Query BuilderOpenText Magellan
Top Pros
Top Cons
Features
Active Query BuilderOpenText Magellan
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
7.0
2 Ratings
16% below category average
Customizable dashboards00 Ratings7.02 Ratings
Report Formatting Templates00 Ratings7.01 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
8.3
3 Ratings
2% above category average
Drill-down analysis00 Ratings8.03 Ratings
Formatting capabilities00 Ratings8.03 Ratings
Integration with R or other statistical packages00 Ratings9.01 Ratings
Report sharing and collaboration00 Ratings8.02 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
8.3
2 Ratings
1% below category average
Publish to Web00 Ratings8.02 Ratings
Publish to PDF00 Ratings8.02 Ratings
Report Versioning00 Ratings9.02 Ratings
Report Delivery Scheduling00 Ratings8.02 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
8.0
1 Ratings
1% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings9.01 Ratings
Predictive Analytics00 Ratings7.01 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
9.0
2 Ratings
4% above category average
Role-Based Security Model00 Ratings9.02 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings9.02 Ratings
Single Sign-On (SSO)00 Ratings9.02 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
7.0
2 Ratings
13% below category average
Responsive Design for Web Access00 Ratings7.02 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.02 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Active Query Builder
-
Ratings
OpenText Magellan
6.2
1 Ratings
24% below category average
REST API00 Ratings5.01 Ratings
Javascript API00 Ratings9.01 Ratings
Java API00 Ratings5.01 Ratings
Themeable User Interface (UI)00 Ratings7.01 Ratings
Customizable Platform (Open Source)00 Ratings5.01 Ratings
Best Alternatives
Active Query BuilderOpenText Magellan
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
TIBCO Jaspersoft Community Edition
TIBCO Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Active Query BuilderOpenText Magellan
Likelihood to Recommend
8.5
(5 ratings)
9.0
(11 ratings)
Likelihood to Renew
-
(0 ratings)
3.9
(9 ratings)
Usability
-
(0 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
9.0
(2 ratings)
User Testimonials
Active Query BuilderOpenText Magellan
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
OpenText
If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.
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
OpenText
  • The report outputs can vary across different types such as HTML, PDF, and Excel
  • Their open source offering is very sufficient
  • There are great boards and blogs for developers and engineers to expand and use their features.
  • The people from the company that I've worked with are professional and courteous.
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
OpenText
  • The documentation on all the available features, but most importantly on the scripting side, can be improved
  • The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
  • The server portal needs to provide better tools
  • More integration is needed with other OpenText products
Read full review
Likelihood to Renew
Active Database Software
No answers on this topic
OpenText
I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite
Read full review
Usability
Active Database Software
No answers on this topic
OpenText
It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.
Read full review
Support Rating
Active Database Software
No answers on this topic
OpenText
Always there on the front and backend for us and the client.
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
OpenText
It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.
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
OpenText
  • Actuate can handle 50 to 60 sub reports inside a report very well.
  • Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.
Read full review
ScreenShots

OpenText Magellan Screenshots

Screenshot of A Magellan BI & Reporting dashboard that an individual can interact with and personalize to their needs, such as changing chart types or computations.Screenshot of Magellan Data Discovery provides a Smart User Interface, designed to equip new users and users seeking a more streamlined set of features for insightsScreenshot of Magellan Data Discovery provides an Advanced User Interface that allows data analytics pros to leverage its breadth of sophisticated capabilities for insightsScreenshot of Magellan Text Mining insights can be displayed within easy-to-use dashboards.Screenshot of Data scientists can create visualizations within the Magellan Notebook and see it dynamically update as they write changes to it.