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 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."
"The embedding feature is great."
"We can easily do our own customizations."
"The pricing of the product is very good."
"Very easy to use, and it's very democratic in the enterprise."
"The tool helps us by being available always."
"We found it to be quite scalable."
"It is the latest technology and pretty powerful in terms of the high availability of the virtual server."
"The solution is easy to use."
"The solution has the capability to scale."
"Comparing with other database management systems that I tried in other companies, SQL Server is quite easy to install, configure, and maintain."
"The dashboard components could be better."
"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 only challenge here is that it's a Java-based platform. It requires very high technical skills."
"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."
"I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
"SQL Server is an expensive solution"
"They need to improve their support. It should be faster."
"The solution could be more secure."
"Database support could be improved."
"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."
Knowage is ranked 19th in Reporting with 18 reviews while SQL Server is ranked 1st in Relational Databases Tools with 245 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 "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". Knowage is most compared with Microsoft Power BI, Tableau, Pentaho Business Analytics, SAP BusinessObjects Business Intelligence Platform and TIBCO Jaspersoft, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, IBM Db2 Database and LocalDB.
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.