We just raised a $30M Series A: Read our story
Cancel
You must select at least 2 products to compare!
IBM Cognos Logo
14,050 views|10,803 comparisons
SQL Server Logo
20,256 views|15,603 comparisons
Top Review
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Business Intelligence (BI) Tools. Updated: September 2021.
542,267 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
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use.""The initial setup is quite straightforward.""IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions.""IBM Cognos improves the effectiveness of the sales team.""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.""In terms of stability, I think that Cognos is more stable than Tableau and Power Bi because of its framework manager concept that allows us to import metadata and store it in the framework manager.""The comprehensiveness or broadness of the software functions or business intelligence functions that it provides is valuable. It is also quite easy to use and user-friendly."

More IBM Cognos Pros »

"The availability is the most valuable feature. It has high availability. It also has good performance.""SQL is very easy to manage.""It helps with moving the design of the database into reality.""The feature that I have found most valuable is that it is easy to code.""Very good security features.""The features that we have found the most valuable are reliability, availability perspective, and current scalability.""The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful.""SQL Server is a stable product."

More SQL Server Pros »

Cons
"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.""The performance is a bottleneck and something that can be improved.""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.""It would be nice to offer free online training on the tool for end-users.""Tableau and Power BI are faster than Cognos.""I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."

More IBM Cognos Cons »

"In terms of improvement, it could use more integration with other products.""Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization.""The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.""In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages.""Query optimitzer could be simplified.""The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience.""CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server.""The number of concurrent users is too limited and other databases are better than SQL in this regard."

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."

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.
542,267 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: The ease of administration, in general, is the solution's most valuable aspect.
Top Answer: The licensing cost varies widely, depending upon what methodology you employ. It could be very cheap, for example, it could be less than $2,000. Alternatively, it can go up to well over $100,000.
Top Answer: Its ability to handle certain kinds of large data could be improved. Its high availability, segmentation, and disaster recovery features can be improved upon also. There are not really any significant… more »
Ranking
Views
14,050
Comparisons
10,803
Reviews
8
Average Words per Review
484
Rating
8.4
1st
Views
20,256
Comparisons
15,603
Reviews
115
Average Words per Review
447
Rating
8.3
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 Company26%
Comms Service Provider14%
Financial Services Firm11%
Government6%
REVIEWERS
Financial Services Firm19%
Computer Software Company11%
Manufacturing Company9%
Comms Service Provider5%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider22%
Financial Services Firm8%
Insurance Company5%
Company Size
REVIEWERS
Small Business27%
Midsize Enterprise17%
Large Enterprise56%
REVIEWERS
Small Business44%
Midsize Enterprise20%
Large Enterprise36%
VISITORS READING REVIEWS
Small Business19%
Midsize Enterprise9%
Large Enterprise72%
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Business Intelligence (BI) Tools. Updated: September 2021.
542,267 professionals have used our research since 2012.

IBM Cognos is ranked 8th in Business Intelligence (BI) Tools with 9 reviews while SQL Server is ranked 1st in Relational Databases with 119 reviews. IBM Cognos is rated 8.4, while SQL Server is rated 8.2. The top reviewer of IBM Cognos writes "View all the numbers through one single platform to make business decisions, but pay for the privilege". On the other hand, the top reviewer of SQL Server writes "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". IBM Cognos is most compared with Tableau, Microsoft BI, Qlik Sense, Microsoft SQL Server Reporting Services and QlikView, whereas SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, LocalDB and QlikView.

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.