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."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."
"The concept of engines is quite powerful allowing the user to work with report authoring/provisioning tools of their choice."
"The embedding feature is great."
"Its security is good. The GUI of SQL Server is also very good."
"Excel integration is one of its most valuable features."
"The ability to see tables, reviews, and custom script options is good."
"can extract data from the server and store it in a local data source for BI purposes."
"The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."
"The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities."
"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"The pricing of the product is very good."
"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."
"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 way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient. It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages."
"The performance degrades when the data is huge."
"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."
"Security is an issue."
"The tool's support needs to be improved."
"Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit."
"There should be more security updates for the product."
"Sometimes we experience issues with its stability."
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, Pentaho Business Analytics and SAP BusinessObjects Business Intelligence Platform, 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.