Active Query Builder vs. Alteryx

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
Alteryx
Score 9.0 out of 10
N/A
Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering breakthroughs. Alteryx Designer can be used to automate every analytics step — from data prep to data science. Access any data source or type, then blend via drag-and-drop interface.…N/A
Pricing
Active Query BuilderAlteryx
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 BuilderAlteryx
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 BuilderAlteryx
Top Pros
Top Cons
Best Alternatives
Active Query BuilderAlteryx
Small Businesses
React
React
Score 8.9 out of 10
Klipfolio
Klipfolio
Score 8.5 out of 10
Medium-sized Companies
React
React
Score 8.9 out of 10
Klipfolio
Klipfolio
Score 8.5 out of 10
Enterprises
ServiceNow App Engine
ServiceNow App Engine
Score 8.7 out of 10

No answers on this topic

All AlternativesView all alternativesView all alternatives
User Ratings
Active Query BuilderAlteryx
Likelihood to Recommend
8.5
(5 ratings)
9.3
(126 ratings)
Likelihood to Renew
-
(0 ratings)
8.5
(19 ratings)
Usability
-
(0 ratings)
9.2
(52 ratings)
Availability
-
(0 ratings)
8.0
(4 ratings)
Performance
-
(0 ratings)
9.1
(37 ratings)
Support Rating
-
(0 ratings)
9.3
(52 ratings)
In-Person Training
-
(0 ratings)
7.0
(1 ratings)
Online Training
-
(0 ratings)
8.6
(2 ratings)
Implementation Rating
-
(0 ratings)
8.2
(5 ratings)
Configurability
-
(0 ratings)
7.5
(2 ratings)
Ease of integration
-
(0 ratings)
8.3
(3 ratings)
Product Scalability
-
(0 ratings)
7.7
(3 ratings)
Vendor post-sale
-
(0 ratings)
8.3
(2 ratings)
Vendor pre-sale
-
(0 ratings)
7.3
(1 ratings)
User Testimonials
Active Query BuilderAlteryx
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
Alteryx
We're trying right now to get more people using it at our company so we can send management documented cases for how we can expand and purchase Alteryx Server which will extend the capabilities even more and across more departments. It's been well suited for pretty much everything we do on a repeating schedule. It's worth the time to set up the workflows. When Treasury sends me the bank download now - I save it to a folder and run our workflows and send back 2 journal entries in .9 seconds. (yes - in less than a second it's finished running)
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
Alteryx
  • Pulling data from multiple disparate data sources.
  • Allows users to see the data at every step of the workflow to be able to cleanse, analyze, and optimize the data.
  • Provides an analytics platform that is easy for users of all levels to thrive in whether they are just starting out in their analytics journey or they have a master's degree in Data Science.
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
Alteryx
  • Alteryx is great for processes that is has already "thought through". It's more difficult to get Alteryx to deal with some customization.
  • The data visualizations with Alteryx are generally good, although I don't think the color schemes are the best.
  • I think the data science capabilities are awesome with Alteryx, although not as well used as products built with Python or R.
Read full review
Likelihood to Renew
Active Database Software
No answers on this topic
Alteryx
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
Read full review
Usability
Active Database Software
No answers on this topic
Alteryx
I've found that while some things might take a little longer to create, the flexibility of Alteryx allows you to perform any function needed. I haven't found a use that was not available in Alteryx yet. APIs and XMLs can be created to perform certain functions. In addition, CMD line commands can be sent using Alteryx to perform certain functions as well.
Read full review
Reliability and Availability
Active Database Software
No answers on this topic
Alteryx
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Read full review
Performance
Active Database Software
No answers on this topic
Alteryx
Alteryx is an extremely reliable platform. If there is an error in my workflow, I feel pretty strongly it was probably my fault. The platform also handles large amounts of data very quickly and can join/match, sort, filter, calculate on that data quickly as well. One of my favorite things to build into a workflow are the messages based on data/metadata and error messages based on errors I have come across before.
Read full review
Support Rating
Active Database Software
No answers on this topic
Alteryx
Stellar, bar-none. Some of the best support folks of any vendor. The Alteryx Community is the most responsive and supportive. On the rare occasion of a release issue or bug, we've been able to get quick help to solve the core problem. Alteryx does not play the blame game. They genuinely help the users solve their issues or respond to questions
Read full review
In-Person Training
Active Database Software
No answers on this topic
Alteryx
1st level of trainings which I've attended in Paris was easy and I was already knowing %90, that learning could have been an e-learning instead of in-person
Read full review
Online Training
Active Database Software
No answers on this topic
Alteryx
Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...
Read full review
Implementation Rating
Active Database Software
No answers on this topic
Alteryx
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
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
Alteryx
Alteryx is MUCH more user friendly. both provide the ability to code within them, but Alteryx has much nicer interface. The formula tools have a more simple language that is easier to learn than formulae in SSIS. Alteryx is easy to read with multi colored tools identifying what each one does. It also allows for macros. You can build your own tool to process records of data or batch records together.
Read full review
Scalability
Active Database Software
No answers on this topic
Alteryx
Individual analysts can quickly generate results using their own copy of Alteryx Designer. But using the Server and developing macros for more complex needs can be time consuming.
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
Alteryx
  • Error handling - allows controls to be built into workflows easily and allows them to be isolated and spat into control reports that can be easily reviewed and audited, thanks to the ability to create multiple outputs in one go.
  • Time-saving - saved huge amounts of time, especially when moving Excel processes into Alteryx.
  • Product development - allowed my firm to create products that we have been able to market and sell to clients.
Read full review
ScreenShots

Alteryx Screenshots

Screenshot of Alteryx APA - Automating asset inputsScreenshot of Alteryx APA - Automating outcomesScreenshot of Alteryx APA - Data enrichment and insightsScreenshot of Alteryx APA - Data quality and preparationScreenshot of Alteryx APA - Data science and decisions