Active Query Builder vs. QlikView vs. Syncfusion Essential Studio

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.

Incentivized

Sales data validations have helped manage our justifications in the past, especially with regard to new product development and new business introduction. It has also been helpful in identifying trends with business impact and direction specific to quarter and monthly sales from ERP data as well as decisions to purchase equipment of staffing based on run rates and product demand.

One thing that can get out of hand is data output - if you aren't careful in your query, you may be overloaded with data dumps and drown in the amount of info you have to filter through. This is a user caution, not a comment on the software itself.

Incentivized

The datagrid is probably their most popular control I would think. It is so flexible and configurable. Most of mine are plain views in ASP.NET Core, but I have a whole bunch that are dynamically created at runtime in my controller. That is so powerful.

• 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.

Incentivized

• QlikView has a simple, relational data model that's REALLY fast. Filtering and changing data is dead simple results are almost immediately available.
• The free version of Qlikview is almost completely featured, so you roll a pro-level product out to an entire department for really cheap.
• QlikView is really flexible--if you can imagine it, you can build it.

Incentivized

• Integrates well into Microsoft tech stack. i.e. ASP.NET, Blazor etc. So it acts as a plug-n-play, which is great!
• Shrinks the development cycle without adding too much of its own ecosystem overhead.
• Provides different UI skins so the controls don't appear as "stitched".

• 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

Incentivized

• We found that QlikView can be a bit slow in supporting some forms of encryption. It is web-based and we needed to upgrade all of our server to not support the older SSL and TLS 1 protocols, only support TLS 1.2 and TLS 1.3. However, QlikView could not run with TLS 1.2 and TLS 1.3. We had to wait over six months to get a version that would handle the newer TLS versions.
• There are so many options with QlikView that you can get lost when developing a visualization. There are still items I have not yet figured out, such as labeling a graph with the name of a selected detail item.
• QlikView works by pulling the data it is going to use for visualization into its database. I am a security reviewer and I need to make certain that PII and PHI is not pulled by QlikView for a visualization, otherwise this could become a reportable indecent.

Incentivized

• Sometimes links point to dead addresses in the documentation.
• Some components have a difficult learning curve but that is usually due to the complexity of the control.
• Minor version changes introduce breaking changes, for example updating from 20.1.x to 20.2.x gives us licensing errors, which in my opinion is a kind of breaking change as it requires all users to update their licenses.
• Theming with CSS variables is not possible. Access to Theme Studio code is not possible. So a fully custom solution is needed to make Syncfusion Essential Studio Enterprise Edition components themeable with CSS variables.

Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.

Incentivized

It takes effort to include a new component library into existing software, especially in our case where we have 5 large applications that are written and maintained by about 100 developers. So changing such a core thing comes with a lot of effort. The other reason we will very likely renew our use of Syncfusion Essential Studio Enterprise Edition is that it works really well and has helped us to speed up the development process.

QlikView is very easy to implement. The installation is very straight forward. QlikView has several different data connectors that can connect to different data sources very smoothly. The user interface to build the reports is very easy to understand. This helps to have a smaller learning curve. Something very helpful is that QlikView is a browser application for the end users. So, you don't need to install any applications on the user's computer.

Incentivized

I would rate Syncfusion® Essential Studio® a 10 out of 10 for overall usability. The components are intuitive to implement, with clear APIs and consistent design patterns across the suite. This makes it easy for developers to get started quickly and reduces the learning curve even when working with new controls.
In addition, the documentation and sample projects provide practical guidance that helps accelerate development. The built-in customization options also allow us to adapt the components to fit our branding and business requirements without excessive effort. Overall, the usability is one of the key reasons why Syncfusion has become an essential part of our development toolset.

We have not had any downtime issues with the product nor uncovered any significant bugs

It is not a SAAS product.

My experience with the Qlik support team has been somewhat limited, but every interaction I have had with them has been very professional and I received a response quickly. Typically if there is a technical issue, our IT team will follow up. My inquiries are specific to product functionality, and Qlik has been very helpful in clarifying any questions I might have.

Incentivized

Although I have decades of software development experience, I had never created a website from scratch before, and my html and css skills are not particularly strong. Between documentation and incredible dedication from the support team they helped me overcome all of my challenges. It's amazing that they typically create sample code for most of the issues that I submitted. On rare occasions where I uncovered a defect they kept me informed as to its status, and typically resolved it in a short-term release, and/or gave me a reasonable workaround. They hopped on zoom calls with me on multiple occasions when necessary.

My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.

Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.

"Implementation" can mean a few things... so I'm not sure that this is the answer you want.... but here it goes: To me, implementation means: "Is the user interface intuitive and can I produce meaningful reports with ease?" On that score, I'd say YES. The amount of training required was minimal and the results were powerful. The desktop implementation is a simple, "blank" interface just waiting for your creativity. The pre-populated templates give you a reasonable start to any project -- and a good set of objects to "play around with" if you're just getting started. Finally, note that the "implementation" I used was baked into QuickBooks 2016 Enterprise -- called "Advanced Reporting"..... That integration makes it ultra useful and simple.

Incentivized

Feedback from the team has been very positive.

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

Incentivized

The only other vendor product that I have worked with that provides a similar experience to Qlikview is Tableau. I would recommend Tableau if your use case is to build a fixed dashboard. You can share reports for free without needing to buy additional licenses. I would recommend Qlikview if your users are looking for a more interactive experience. They can create new objects to represent the data which can't be accomplished as easily in Tableau

Incentivized

Firstly, there is a free version for small businesses and it allows you to jump start without risk. I found one of the other products a bit short in the number of out-of-the-box supported events handlers for each control and, although you can manually add them, I feel more comfortable to just have them ready. After using the free version I just felt in love with Syncfusion Essential Studio Enterprise Edition controls and decided to stay with them; they have all I need and more. The usage of Syncfusion Essential Studio Enterprise Edition controls is straightforward and intuitive. Support is world-class even for the free version; you get answers in 24 hours at most. Also, the support team is ready to remotely connect to your project in case it is needed; we have had one situation like this, and the issue was solved.

• better business decisions allow us to maximize revenue for the company
• awesome ROI

Incentivized

• You can use the free desktop version to do a lot of reporting and analysis work more quickly so the ROI is huge
• QlikView is great at finding outliers such as data entry errors
• QlikView is great at helping you quickly discover new insights about your business that can prompt you to take action that can immediately affect your cash flow.

Incentivized

• First of all, I think the best positive impact is the reduce of time development. I do not know exactly how much time, but certainly, using the framework we save a lot of effort and time.
• About negative impact, sometimes using the controls of the framewrok have a signifcant impact in the execution time and page load.
• And of course, the use of Syncfusion Essential Studio Enterprise Edition has a significant impact of the learning of javascript and JQUERY.