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."
"The solution is easy to use, has rich feature sets, and is business-oriented."
"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."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"In Poland, SQL Server is the most popular database engine, and overall, our customers like it."
"The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus."
"We have many users, between 50 and 100 using the SQL Server product."
"SQL Server is easy to manage."
"If you need to, you can scale the solution very easily."
"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 would be nice if they can reduce its price."
"If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good."
"Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication."
"I would like to have more replication scenarios."
"There are certain shortcomings in the scalability of the product, making it an area where improvements are required."
"The UX design of this system needs improvement."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
"They could improve the solution by allowing more portability between on-premise and the cloud."
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.