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."It is a stable product."
"The scalability is there."
"The integration with Salesforce has helped us gain access to crucial sales data in real-time."
"We can scale it if we need to."
"The most valuable feature of QlikView is the integration with other third-party tools."
"The most valuable aspect is its extensive library on Microsoft, providing a robust framework for implementation."
"If you correctly use the product for your use cases, it provides value for money."
"I had the option to prepare data myself instead of always having to depend on the data team."
"The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly."
"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."
"SQL is very easy to manage."
"The most valuable features are programmability and reliability."
"From a security perspective, we have no complaints."
"The scalability of the product is great."
"Many developers like SQL Server."
"It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"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."
"QlikView certainly lacks in its ability to share visualizations or create visualizations easily."
"Better source data connectors."
"There is a challenge on the frontend when it comes to browsing data through QlikView, as it isn't entirely compatible with other platforms we use."
"They could provide a user-friendly analysis process rather than specialized IT resource code."
"The pricing is high."
"Syntax editor needs some work, it's frustrating to have valid syntax being flagged as incorrect."
"It needs work with visualization."
"From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week."
"There should be more security updates for the product."
"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."
"Security is an area that can be improved."
"There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."
"Right now we don't get much technical support from Microsoft"
"Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities."
"There is room for improvement in performance when managing a large quality of data and a high number of active users."
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 SAP Adaptive Server Enterprise.
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.
