We changed our name from IT Central Station: Here's why

IBM Cognos vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
IBM Cognos Logo
13,303 views|10,343 comparisons
SQL Server Logo
19,554 views|14,983 comparisons
Featured Review
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Business Intelligence (BI) Tools. Updated: January 2022.
564,143 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
"Security administration tools are powerful and flexible.""IBM Cognos improves the effectiveness of the sales team.""The most valuable features of IBM Cognos are governance and enterprise reporting.""The initial setup is quite straightforward.""I have worked on the features like dashboards and stories, and I do like them a lot.""The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report.""This solution allows you to input a wide range of file formats.""A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."

More IBM Cognos Pros →

"I haven't really experienced any issues that required the assistance of technical support.""It is easy to use and easy to perform a backup.""It's a flexible solution.""I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.""The features that we have found the most valuable are reliability, availability perspective, and current scalability.""We have found the solution to be scalable.""The solution is very common. It's easy to use.""For me, the initial setup is very easy as I have years of experience with the product."

More SQL Server Pros →

Cons
"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring.""The solution seems to slow down the servers.""The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help.""The performance is a bottleneck and something that can be improved.""The high cost of a license makes it hard to scale up on a budget.""They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product.""The AI-based features could be further enhanced by the solution.""Tableau and Power BI are faster than Cognos."

More IBM Cognos Cons →

"For small-scale businesses, Microsoft could improve by removing some limits in SQL Express.""The free version of SQL Server is time-limited before updating to the paid version.""Technical support could be faster.""I would like to see the database become fully automated.""The integration could be better. They are not open-source, so the integration with other platforms is not that easy.""They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers.""Performance could be improved.""I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."

More SQL Server Cons →

Pricing and Cost Advice
  • "Pricing should be improved."
  • "The pricing of this product is meant for medium to large-scale enterprises."
  • "It is my understanding that the cost is very low. It's not very expensive."
  • "Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
  • "It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
  • "It's more expensive than similar solutions like Tableau and Power BI."
  • "There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
  • "IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
  • More IBM Cognos Pricing and Cost Advice →

  • "SQL Server is a cost-effective solution for a small database."
  • "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."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Business Intelligence (BI) Tools solutions are best for your needs.
    564,143 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos… more »
    Top Answer: 
    The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report.
    Top Answer: 
    As we get new requirements, we need to see if they fit into Cognos. As of right now, it fits our needs, however, that can change. We've had issues in the past that the solution is still working to… more »
    Top Answer: 
    I have found SQL Server easy to use.
    Top Answer: 
    SQL Server could improve by having better usability or user guidance.
    Ranking
    Views
    13,303
    Comparisons
    10,343
    Reviews
    9
    Average Words per Review
    517
    Rating
    8.2
    1st
    Views
    19,554
    Comparisons
    14,983
    Reviews
    135
    Average Words per Review
    462
    Rating
    8.2
    Comparisons
    Also Known As
    Cognos, Cognos Analytics, IBM Cognos Analytics
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    Cognos Software is IBM's Business Intelligence and Performance Management solution, offering BI, strategy management, financial performance, and data analytics applications. Cognos caters to all levels in an organization with products designed for individuals, workgroups, departments, mid-size companies, and big enterprises.

    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 IBM Cognos
    Learn more about SQL Server
    Sample Customers
    More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
    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
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company10%
    Healthcare Company9%
    University7%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider15%
    Financial Services Firm11%
    Government6%
    REVIEWERS
    Financial Services Firm18%
    Computer Software Company13%
    Manufacturing Company11%
    Comms Service Provider5%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider22%
    Financial Services Firm7%
    Government5%
    Company Size
    REVIEWERS
    Small Business26%
    Midsize Enterprise17%
    Large Enterprise57%
    REVIEWERS
    Small Business43%
    Midsize Enterprise21%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Business Intelligence (BI) Tools. Updated: January 2022.
    564,143 professionals have used our research since 2012.

    IBM Cognos is ranked 8th in Business Intelligence (BI) Tools with 13 reviews while SQL Server is ranked 1st in Relational Databases with 143 reviews. IBM Cognos is rated 8.0, while SQL Server is rated 8.2. The top reviewer of IBM Cognos writes "Excellent correlation analysis, highly scalable, but more features needed". On the other hand, the top reviewer of SQL Server writes "Veteran solution with critical log shipping feature". IBM Cognos is most compared with Tableau, Microsoft BI, Qlik Sense, Microsoft SQL Server Reporting Services and Oracle Hyperion, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and SAP SQL Anywhere.

    We monitor all Business Intelligence (BI) 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.