Try our new research platform with insights from 80,000+ expert users

QlikView vs SQL Server comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

QlikView
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
161
Ranking in other categories
Reporting (5th), Embedded BI (3rd)
SQL Server
Average Rating
8.4
Reviews Sentiment
6.8
Number of Reviews
268
Ranking in other categories
Relational Databases Tools (1st)
 

Mindshare comparison

QlikView and SQL Server aren’t in the same category and serve different purposes. QlikView is designed for Reporting and holds a mindshare of 3.3%, up 3.3% compared to last year.
SQL Server, on the other hand, focuses on Relational Databases Tools, holds 18.6% mindshare, down 23.1% since last year.
Reporting
Relational Databases Tools
 

Featured Reviews

Arjun Meda - PeerSpot reviewer
Useful for data visualization and business intelligence
Many of the features in Qlik Sense need to be available and reintroduced in QlikView. I believe many of the features have been added to QlikView after the layout containers were introduced. QlikView used to be a way more customizable tool than Qlik Sense is in the present time. Improvements are required in the hide and unhide functionality that falls under the layout container feature that has been used in my company in recent times. Hiding off the apps in the app overview tab based on the access was a really good feature that needs to be introduced back in the product since I see that, at the moment, there are multiple groups on the tool, owing to which multiple changes on the QMC part is required to handle the solution. Only the person with access to the dashboard in QlikView could have a link to the dashboard through QlikView's hub or access points. With Qlik Sense, one can see whatever is available in the stream. If a user wants to control everything in the product, then there is no need to make multiple changes in the QMC at the individual app level. The aforementioned area can be considered to improve Qlik Sense.
Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The integration with Salesforce has helped us gain access to crucial sales data in real-time."
"The search feature: ability to see the related data."
"E-T-L, The Extract, Transform, and Loading capabilities of QlikView make it a highly sophisticated self-service business intelligence tool for developers and analysts."
"It has user-friendly data visualization features, supporting our decision-making process with its business intelligence capabilities"
"Once you open it up, you see everything that you can do."
"It's incredibly fast and can handle large volumes of data without slowing down our operations."
"We can scale it if we need to."
"The scalability is there."
"SQL is stable."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"The solution offers very high performance."
"Most valuable features include: high availability, clustering, save backup and recovery."
"If you need to, you can scale the solution very easily."
"It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
"The Always On tool improves the SQL server availability."
 

Cons

"QlikView certainly lacks in its ability to share visualizations or create visualizations easily."
"This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help."
"Error handling."
"Although Qliktech's road map clearly states that QlikView has a long way to go, most of the R&D effort seems to be benefiting Qlik Sense."
"Syntax editor needs some work, it's frustrating to have valid syntax being flagged as incorrect."
"If a user wanted to see something not included in the application the new object had to be created by a power user or developer because Qlik view's scripting has somewhat of a learning curve."
"It is really old. We are moving towards converting everything into a Power BI environment. We want to have a self-service type of BI environment where different levels of users in organizations can log onto a portal and retrieve the data they need or get the necessary insights for decision-making that's important for them or their business unit. They have built a new version of QlikView called QlikSense, which probably competes with newer BI tools, such as Power BI, but they are far behind. That's why we are moving towards a newer tool that's easier to use and has more visualizations to represent the data."
"I really wish the application was easier to use in the development phase."
"It would be nice if they can reduce its price."
"There is room for improvement in terms of pricing for SQL Server."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"The documentation could be much better. It's lacking right now. If there are better help pages, for even complicated queries and stuff like that that would be quite a help for users."
"Currently, I do not face any difficulties with SQL Server as all options and documentations are available."
"On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."
"It would definitely be better if SQL Server were free."
 

Pricing and Cost Advice

"Pricing is a bit too high and I think licenses should be unlimited."
"Qlik is fairly high in terms of pricing."
"I rate the product's pricing a three out of ten."
"It's reasonably priced and falls on the more affordable side."
"It is expensive for small companies."
"The platform's pricing is considered quite expensive, particularly given the dollar-based pricing."
"The pricing is moderate, in the medium price range."
"My firm got the product at a cheap price, but in general, I believe that the product is a bit costly."
"The areas that need improvement are with regards to the commercial aspect of the solution, the licensing cost could be reduced in order to help customers to adopt it."
"SQL Server is an expensive solution."
"SQL Server is expensive if you use the advanced SQL version, but if you use the standard version, it's not expensive."
"Their options for concurrency and locking are good, as well as their prices."
"SQL Server is a cost-effective solution for a small database."
"The licenses are really expensive. Their licensing model should be more simplistic."
"The free version is cumbersome to use and maintain. But $5000 for a licence is more expense than the benefit I would get from a licensed version. A licence might be worth the price to simplify management and speed up searches."
"Licensing fees are paid on a yearly basis."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
844,944 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
7%
Healthcare Company
6%
Educational Organization
53%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about QlikView?
If you correctly use the product for your use cases, it provides value for money.
What is your experience regarding pricing and costs for QlikView?
Qlik Sense's licensing metrics are flexible. They provide packages based on needs, like named licenses, developer licenses, or shared pool licenses. There is also a core-based license option for or...
What needs improvement with QlikView?
QlikView lacks self-service capabilities, which means users depend on the IT team to make changes. Qlik Sense offers a more modern approach with self-service features, allowing users to build dashb...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

Canon, Gatorade, Amcor, Panasonic, Fila, Cambridge University Hospitals, Global Retail Bank, North Yorkshire Police department, Lanoo Group Publishers, and AonGroep Nederland.
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about Microsoft, Salesforce, Oracle and others in Reporting. Updated: March 2025.
844,944 professionals have used our research since 2012.