We performed a comparison between Knowage and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Reporting."The embedding feature is great."
"The concept of engines is quite powerful allowing the user to work with report authoring/provisioning tools of their choice."
"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."
"We can easily do our own customizations."
"For me, the initial setup is very easy as I have years of experience with the product."
"The technical support is good."
"The installation is pretty straightforward."
"One of the best features of SQL Server is the efficient retrieval of information."
"It works fine in terms of performance and stability."
"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 tool helps us by being available always."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"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."
"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"The dashboard components could be better."
"The only challenge here is that it's a Java-based platform. It requires very high technical skills."
"It could be more stable."
"There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product."
"Other than Synapse and the other version of SQL Server, they face some problems while processing the data."
"SQL Server is an expensive solution"
"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."
"I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements."
"SQL Server backups could be better."
"The solution could be better when it comes to security."
Earn 20 points
Knowage is ranked 23rd in Reporting while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Knowage is rated 7.6, while SQL Server is rated 8.4. The top reviewer of Knowage writes "Easy to customize, cross-platform capable, and very stable". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Knowage is most compared with Microsoft Power BI, Tableau and Pentaho Business Analytics, 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.