Active Query Builder vs. Composable DataOps Platform vs. OpenText Magellan

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
Composable DataOps Platform
Score 7.7 out of 10
Enterprise companies (1,001+ employees)
Composable Analytics is a business intelligence solution that provides both cloud-based services and on-premise solutions. Some key features include data flow-based applications, data process automation and application reusability.N/A
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 BuilderComposable DataOps PlatformOpenText 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
No answers on this topic
Offerings
Pricing Offerings
Active Query BuilderComposable DataOps PlatformOpenText Magellan
Free Trial
YesYesNo
Free/Freemium Version
NoNoNo
Premium Consulting/Integration Services
YesYesNo
Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Active Query BuilderComposable DataOps PlatformOpenText Magellan
Features
Active Query BuilderComposable DataOps PlatformOpenText Magellan
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Composable DataOps Platform
-
Ratings
OpenText Magellan
7.0
2 Ratings
16% below category average
Customizable dashboards00 Ratings00 Ratings7.02 Ratings
Report Formatting Templates00 Ratings00 Ratings7.01 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Active Query Builder
-
Ratings
Composable DataOps Platform
-
Ratings
OpenText Magellan
8.3
3 Ratings
3% above category average
Drill-down analysis00 Ratings00 Ratings8.03 Ratings
Formatting capabilities00 Ratings00 Ratings8.03 Ratings
Integration with R or other statistical packages00 Ratings00 Ratings9.01 Ratings
Report sharing and collaboration00 Ratings00 Ratings8.02 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Active Query Builder
-
Ratings
Composable DataOps Platform
-
Ratings
OpenText Magellan
8.3
2 Ratings
1% above category average
Publish to Web00 Ratings00 Ratings8.02 Ratings
Publish to PDF00 Ratings00 Ratings8.02 Ratings
Report Versioning00 Ratings00 Ratings9.02 Ratings
Report Delivery Scheduling00 Ratings00 Ratings8.02 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Active Query Builder
-
Ratings
Composable DataOps Platform
-
Ratings
OpenText Magellan
8.0
1 Ratings
0% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings00 Ratings9.01 Ratings
Predictive Analytics00 Ratings00 Ratings7.01 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Active Query Builder
-
Ratings
Composable DataOps Platform
-
Ratings
OpenText Magellan
9.0
2 Ratings
6% above category average
Role-Based Security Model00 Ratings00 Ratings9.02 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings00 Ratings9.02 Ratings
Single Sign-On (SSO)00 Ratings00 Ratings9.02 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Active Query Builder
-
Ratings
Composable DataOps Platform
-
Ratings
OpenText Magellan
7.0
2 Ratings
10% below category average
Responsive Design for Web Access00 Ratings00 Ratings7.02 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings00 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
Composable DataOps Platform
-
Ratings
OpenText Magellan
6.2
1 Ratings
22% below category average
REST API00 Ratings00 Ratings5.01 Ratings
Javascript API00 Ratings00 Ratings9.01 Ratings
Java API00 Ratings00 Ratings5.01 Ratings
Themeable User Interface (UI)00 Ratings00 Ratings7.01 Ratings
Customizable Platform (Open Source)00 Ratings00 Ratings5.01 Ratings
Best Alternatives
Active Query BuilderComposable DataOps PlatformOpenText Magellan
Small Businesses
React (React.js)
React (React.js)
Score 8.8 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 9.3 out of 10
Yellowfin
Yellowfin
Score 8.7 out of 10
Medium-sized Companies
React (React.js)
React (React.js)
Score 8.8 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
React (React.js)
React (React.js)
Score 8.8 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
All AlternativesView all alternativesView all alternativesView all alternatives
User Ratings
Active Query BuilderComposable DataOps PlatformOpenText Magellan
Likelihood to Recommend
8.6
(5 ratings)
7.7
(2 ratings)
9.0
(11 ratings)
Likelihood to Renew
-
(0 ratings)
8.0
(2 ratings)
3.9
(9 ratings)
Usability
-
(0 ratings)
-
(0 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
-
(0 ratings)
9.0
(2 ratings)
User Testimonials
Active Query BuilderComposable DataOps PlatformOpenText 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
Composable Analytics, Inc.
They need to better identify what their product excels at. I'm continually trying to think of new ideas to run through Composable Analytics. They need to better Identify what this product shines at and market themselves to that subset of an industry
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
Composable Analytics, Inc.
  • Flexible Dataflow Application
  • Easy to source data and then compose to create actionable items for supporting decision
  • Allowed to do different analysis
  • Extremely powerful tool to digest information to produce insight from the data
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
Composable Analytics, Inc.
  • I can not really comment because I do not have a complete fluency with the product as of now.
  • Recreating the wheel on some uses but i guess that may be user error.
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
Composable Analytics, Inc.
This is an extremely productive tool.
Read full review
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
Composable Analytics, Inc.
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
Composable Analytics, Inc.
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
Composable Analytics, Inc.
I would compare them to custom system like Morgan Stanley has that I use. A more appropriate company is Novus or LightKeeper. This product is potentially much cheaper but Novus and Lightkeeper already have built in Analytics screens that you could potential build yourself with Composable.
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
Composable Analytics, Inc.
No answers on this topic
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

Composable DataOps Platform Screenshots

Screenshot of Composable DataFlowScreenshot of Data and Analytics MarketplaceScreenshot of Screenshot of Composable DataPortalScreenshot of Composable DataPortal

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.