We performed a comparison between QlikView and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Reporting."I had the option to prepare data myself instead of always having to depend on the data team."
"Its ability to build, very quickly, very complicated models."
"A well designed app brings freedom of inquiry to meetings, allowing me to answer questions in real time and this has transformed progress and outputs of our monthly group meeting."
"If you correctly use the product for your use cases, it provides value for money."
"Our Qlikview applications help us to get a good idea of our Client Base Performance and assist us in the decision making for Seasonal Specials. On the other hand QlikView helps us to get a grasp on our Suppliers and helps us to negotiate pricing with them."
"Associative model - no more cubes."
"We can scale it if we need to."
"QlikView is a scalable solution that multiple users can easily use."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"Easy to implement and user-friendly relational database management system. This product is stable and scalable."
"Most valuable features include: high availability, clustering, save backup and recovery."
"The performance of the SQL Server is very good."
"The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features."
"It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
"If backups and alerts are configured properly, I can also rely on my restoration plan."
"I use it to fine tune my procedures and functions."
"There is no automation or drag and drop functionality."
"The user interface is old."
"The solution should be mobile-responsive. It should also include drag-and-drop and slice-and-dice features."
"Though the initial setup phase is simple, when it comes to the integration with the custom systems, the configuration and the compatibility sometimes take some more time."
"Scalability really depends on the size of your data and QlikView server architecture. For the biggest data sets, it could become an issue at some point."
"More/newer visualisation components need to be added."
"The only thing I would improve about it is the fact that it refreshes all the time, and when it does that, it just deletes all the options you had, all the filters that you had selected, so you need to select them from the beginning."
"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."
"Scalability of the database could be improved if it could handle increased volumes of data."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"Linux-based editions are not yet proven to be on par with Windows deployments."
"The solution could improve by having more integration with other operating systems and other platforms."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."
"Other than Synapse and the other version of SQL Server, they face some problems while processing the data."
"The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."
QlikView is ranked 5th in Reporting with 158 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. QlikView is rated 8.2, while SQL Server is rated 8.4. The top reviewer of QlikView writes "Useful for data visualization and business intelligence". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". QlikView is most compared with Tableau, Microsoft Power BI, Amazon QuickSight, TIBCO Spotfire and IBM Cognos, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database.
We monitor all Reporting reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.