IT Central Station is now PeerSpot: Here's why

Knowage vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
Knowage Logo
2,905 views|2,157 comparisons
Microsoft Logo
21,417 views|16,448 comparisons
Featured Review
Buyer's Guide
Reporting Tools
July 2022
Find out what your peers are saying about Microsoft, Tableau, IBM and others in Reporting Tools. Updated: July 2022.
621,703 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""The embedding feature is great."

More Knowage Pros →

"The technical support that Microsoft provides is great.""The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete.""SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.""The product can scale if a company needs it to.""The documentation and manuals are very good.""The performance is reliable.""It's great that the database engine is always on.""The backups are excellent."

More SQL Server Pros →

Cons
"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.""The dashboard components could be better."

More Knowage Cons →

"It could be more stable.""If you are a new user then this solution could be difficult, they could improve by making the overall usage easier.""The remote access aspect needs to be improved in terms of security.""SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI.""The interface integration could be better.""I would like to see the integration with other platforms improved in the future.""I would like to see more integration with other platforms.""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."

More SQL Server Cons →

Pricing and Cost Advice
  • "Knowage is open-source, and an enterprise edition is also available."
  • More Knowage Pricing and Cost Advice →

  • "Pricing is reasonable for small organizations, but the scaling increases the price."
  • "We didn't have any licensing costs for SQL Server."
  • "We pay approximately $12,000 USD per month for both the server and the license."
  • "The price could be cheaper."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • "The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Reporting Tools solutions are best for your needs.
    621,703 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It's an open-source product; we use the open-source edition for Knowage.
    Top Answer:The integration could be better. We've been struggling a bit with embedding it without the need to log on. The dashboard components could be better. They could do a lot more. If you compare it with… more »
    Top Answer:We primarily use the solution to embed reports. We are using it as a server to share our embedded reports.
    Top Answer:We're satisfied with the stability.
    Top Answer:Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
    Ranking
    11th
    out of 49 in Reporting Tools
    Views
    2,905
    Comparisons
    2,157
    Reviews
    4
    Average Words per Review
    693
    Rating
    7.5
    Views
    21,417
    Comparisons
    16,448
    Reviews
    168
    Average Words per Review
    444
    Rating
    8.2
    Comparisons
    Also Known As
    SpagoBI
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    Knowage (formerly SpagoBI) has a 14-years history. The actual release is the 6.3.

    Knowage offers FULL ANALYTICAL CAPABILITIES, with a special focus on big data analytics and comprehensive support to rich and multi-source data analysis. Knowage provides different modules, each one focused on a specific domain but mutually combinable (Big Data, Smart Intelligence, Enterprise Reporting, Location Intelligence, Performance Management, Predictive Analysis). Moreover, Knowage is an OPEN SOURCE solution: the source code is freely accessible, everyone is allowed to join the community and build the own business solution to ensure strategic decision-making and improved productivity.

    Knowage suite is supported by Engineering Group, the leading Italian software and services company, with about 10,000 people and more than 50 offices worldwide. Maintenance and support services (such as trainings, migration support, proof-of-concepts, etc) are provided by Engineering Group (KNOWAGE Labs) under subscription.

    SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

    Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

    Offer
    Learn more about Knowage
    Learn more about SQL Server
    Sample Customers
    FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
    Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider23%
    Government6%
    Educational Organization5%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Comms Service Provider23%
    Computer Software Company21%
    Financial Services Firm8%
    Government5%
    Company Size
    REVIEWERS
    Small Business35%
    Midsize Enterprise35%
    Large Enterprise29%
    VISITORS READING REVIEWS
    Small Business25%
    Midsize Enterprise17%
    Large Enterprise58%
    REVIEWERS
    Small Business43%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise16%
    Large Enterprise64%
    Buyer's Guide
    Reporting Tools
    July 2022
    Find out what your peers are saying about Microsoft, Tableau, IBM and others in Reporting Tools. Updated: July 2022.
    621,703 professionals have used our research since 2012.

    Knowage is ranked 11th in Reporting Tools with 4 reviews while SQL Server is ranked 1st in Relational Databases Tools with 167 reviews. Knowage is rated 7.6, while SQL Server is rated 8.2. The top reviewer of Knowage writes "Open-source with great embedding capabilities but the dashboards could be better". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". Knowage is most compared with Microsoft BI, Pentaho Business Analytics, Tableau, TIBCO Jaspersoft and RapidMiner, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, MariaDB and IBM Db2 Database.

    We monitor all Reporting Tools 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.