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.5
Number of Reviews
277
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

"We can easily do our own customizations."
"Being able to schedule necessary jobs needed for production jobs and programming run times"
"The most valuable feature of SpagoBI is that it is open source and 100% free without limits."
"It's a great product. It has a lot more features than many other BI tools. You can get the most out of machine learning, the best connectivity to Python, and it cuts across enterprise sections."
"In terms of ROI, much better than any other solution when it offer full fledged features in open source, planned to have direct contact with SpagoBI for better support."
"It improves sales and products, which motivates employees."
"Instead of just relying on emails to disperse our reports, having a central server to do this for us has helped our organization and has pushed us into a better place."
"SpagoBI makes delivering reports to our clients very easy."
"We design and implement data warehouse solutions with SQL Server 2016 Developer Edition tools, which has given us high levels of productivity, allowed us to use an agile approach to the design and implementation of data warehouse solutions for our customers, and given us a competitive advantage in our market."
"This solution has given us high levels of productivity, which has allowed us to use an Agile approach to the design and implementation of DW solutions for our customers, and this Agile approach has in turn given us a competitive advantage in our market."
"SQL Server has good performance. It is one of the best features."
"SQL is stable."
"A valuable feature of the solution is that it is comparatively simpler to manage than Oracle."
"Stability and usability, which is quite simple, are two of the solution's most valuable features."
"It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature."
"SQL Server is stable."
 

Cons

"As all software and especially the open-source ones have always something that can work better, in this case, SpagoBI is slightly difficult to implement."
"We expected the community to be bigger than what it currently is."
"There are additional features such as Data Integration, Data Visualization, MobileBI, Cloud BI, Data enrichment and massaging should be implemented in the next release."
"The dashboard components could be better. They could do a lot more."
"I encountered a lot of issues when I tried to integrate the map in order to realize Intelligent Location Dashboards."
"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 support is very meager: We had to break our heads to figure out everything"
"I faced difficulties when using the email feature and documentation was scant."
"The solution could offer better integration with other solutions - specifically Microsoft."
"We occasionally face or encounter a problem with the database table itself. Some tables and their flyers, as well as the content's data, must be truncated."
"The tool needs to improve its pricing and technical support."
"We are on a monthly subscription and the price could improve."
"Occasionally the performance, as good as it is, is a bit off."
"Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."
"This is a downside of enterprise Microsoft products."
"We need it to support Linux for better troubleshooting flexibility."
 

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."
"As compared to Oracle Database, SQL Server is less expensive. For mid-sized organizations, SQL Server is completely all right, but people say it can't support large organizations with more than 2,000 users."
"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."
"This solution is available at a much lower price point than Oracle."
"The price of SQL Server could be better in the African market. The licensing model needs to be improved, it is confusing."
"The licensing price could be better, more user-friendly."
"It is expensive in terms of licensing costs and pricing. If you want to scale SQL Server, it is very expensive. We probably have to pay extra for technical support. We also have to pay for the license of Windows on which the SQL Server resides, which is an extra cost."
"Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
"It's cheaper than Oracle."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
922,349 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 Enterprise60
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,349 professionals have used our research since 2012.