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."
"The embedding feature is great."
"We can easily do our own customizations."
"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."
"One of the things I most like about SQL Server is the log shipping piece. This is a great feature."
"SQL Server scales well."
"Managing database is very good."
"I have contacted technical support, and overall my experience with technical support was okay."
"It helps with moving the design of the database into reality."
"The solution seems to be pretty flexible."
"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."
"SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot."
"The dashboard components could be better."
"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"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."
"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."
"SQL Server could be more robust than one of its competitors."
"The tool's support needs to be improved."
"The performance is not always the best."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"SQL Server could be improved with cheaper licensing because it's very expensive."
"The tool needs to improve its pricing and technical support."
"The solution's stability can be improved."
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.