No more typing reviews! Try our Samantha, our new voice AI agent.

Knowage vs SQL Server comparison

Why PeerSpot?
 

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

Knowage
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
18
Ranking in other categories
BI (Business Intelligence) Tools (32nd), Reporting (22nd)
SQL Server
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
278
Ranking in other categories
Relational Databases Tools (1st), Database Management Systems (DBMS) (2nd)
 

Mindshare comparison

Knowage and SQL Server aren’t in the same category and serve different purposes. Knowage is designed for Reporting and holds a mindshare of 2.0%, up 1.0% compared to last year.
SQL Server, on the other hand, focuses on Relational Databases Tools, holds 10.2% mindshare, down 14.2% since last year.
Reporting Mindshare Distribution
ProductMindshare (%)
Knowage2.0%
Tableau Enterprise13.3%
Microsoft Power BI12.4%
Other72.3%
Reporting
Relational Databases Tools Mindshare Distribution
ProductMindshare (%)
SQL Server10.2%
Oracle Database10.3%
IBM Db2 Database6.5%
Other73.0%
Relational Databases Tools
 

Featured Reviews

AM
General Manager Information Technology & Enterprise Applications Manager at OXFORD HOLDING
Easy to customize, cross-platform capable, and very stable
The only challenge here is that it's a Java-based platform. It requires very high technical skills. When we come to the integration with the single sign-on facilities, that part is very challenging. In Power BI and other tools, it's very easy to integrate with active directory and single sign-on, and identity management is very easy in other business intelligence tools. However, when it comes to Knowage, it's a bit heavy, it's time-consuming sometimes, it's not very fast, and definitely not as fast as other business intelligence tools in terms of getting graphical reports. The solution could be cheaper.
Shakti Gupta - PeerSpot reviewer
SQL server database administrator at a tech vendor with 10,001+ employees
Hybrid data platform has strengthened performance, security, and incident response for production
SQL Server is very mature, but I see areas for improvement, especially in performance tuning, troubleshooting, and automation. Although tools such as Query Store and dynamic management views are powerful, some troubleshooting tasks still require senior SQL Server database administrator expertise. It would be valuable to have more intelligent, built-in recommendations for root cause analysis, indexing, blocking, and query optimization. I would also like to see simplified and consistent management across on-premises SQL Server and Azure SQL services, as managing hybrid environments sometimes requires different tools and approaches. Finally, improved patching, updates, monitoring, and cost and license transparency could make SQL Server easier to manage at the enterprise scale. One area I would improve in SQL Server is its documentation and troubleshooting guidance. SQL Server documentation is comprehensive, but for complex production issues, I would like to see more real-world troubleshooting examples, especially for scenarios such as Always On synchronization issues, blocking and deadlocks, performance degradation, and upgrade features.

Quotes from Members

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

Pros

"The most valuable features to us are application implementation, development, and analysis."
"I would use SpagoBI if a company wants to use a free tool that has enough features."
"Being able to schedule necessary jobs needed for production jobs and programming run times"
"Customer Service: Excellent."
"We can easily do our own customizations."
"I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage."
"It improves sales and products, which motivates employees."
"The most valuable feature of SpagoBI is that it is open source and 100% free without limits."
"It's much more friendly in comparison with Oracle."
"SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation."
"The solution can be deployed in a few minutes."
"SQL Server has a dynamic resource allocation feature that allows disk and memory usage to scale to meet changing database demands, providing better performance and simplifying software management."
"It is easy to use and very stable."
"I love the developer version because you can develop and do anything with it, learn, break, and push it to its limits with great community support and without limitations, making it a good thing for learners and developers."
"Agent service is a good feature of SQL Server, where you can schedule certain tasks."
"After reviewing a client's Microsoft SQL environment, I have been able to set up specific alerts and jobs in SQL Server Management Studio (SSMS) to definitely show them where they are experiencing network latency, disk latency, memory pressure, etc., and I have done this type of performance review for over 20 clients in the last 5 years."
 

Cons

"The only challenge here is that it's a Java-based platform. It requires very high technical skills."
"It would be better if more resources were available to help us learn how to use it. I wanted to use Knowage for a more extended period, but learning materials around the product were not really available and were not really straightforward. I've also seen inconsistencies between versions. For example, under the tools, especially in the cockpit, the way you create reports is now different. You will also find some configurations within a particular state, like a line chart, which differs from version to version. I think consistency is an essential feature in a product, especially for business intelligence products."
"The demands of some jobs would slow Spago and lock the site, preventing any other job from processing."
"Yes, using Mobile and Desktop Editions, we would sometimes need to restart the service."
"I encountered a lot of issues when I tried to integrate the map in order to realize Intelligent Location Dashboards."
"We expected the community to be bigger than what it currently is."
"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"We had stability issues."
"The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better."
"The only item which I can list is application failure during Integration Services debugging, when restarting a process flow. In a number of instances the solutions fails. I have not given this much thought and simply stop and start the debugging service rather than restarting."
"In the next releases, I would only like more enhanced backups and more restore points."
"It's like pulling teeth, especially if you have had experience using a tool, like Oracle, that is just not that painful."
"If there is flapping of Always-On database node, SQL Server will break the replication to the child nodes, and it requires manual intervention to restart replication."
"When we run into problems, it's usually during installation, and finding answers to the problem has been a nightmare because the documentation is terrible."
"The user interface to the web frontend of MDS could be more intuitive and the Analysis Services platform has not evolved much in recent times, these are the two things that come to mind."
"I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee."
 

Pricing and Cost Advice

"Knowage is open-source, and an enterprise edition is also available."
"It allows the implementation of an effective reporting system using internal skills at a limited upfront cost."
"The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
"Some of our clients purchase the license and others do not, they use Express SQL Server."
"On a scale of one to ten, when one is cheap and ten is an expensive solution, I rate the product price as seven. The product is expensive."
"The price of the solution could be cheaper."
"Pricing is a bit on the higher side."
"To scale the solution there are additional costs."
"SQL Server offers three versions. You can get a free trial for 30 days."
"Their options for concurrency and locking are good, as well as their prices."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
922,528 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Construction Company
19%
Comms Service Provider
10%
Manufacturing Company
10%
Outsourcing Company
10%
Financial Services Firm
34%
Outsourcing Company
10%
Manufacturing Company
7%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise6
Large Enterprise6
By reviewers
Company SizeCount
Small Business119
Midsize Enterprise61
Large Enterprise123
 

Questions from the Community

Ask a question
Earn 20 points
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

SpagoBI
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
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, Plotly and others in Reporting. Updated: October 2026.
922,528 professionals have used our research since 2012.