Try our new research platform with insights from 80,000+ expert users

IBM Cognos vs Microsoft SQL Server Reporting Services comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Microsoft SQL Server Report...
Ranking in Reporting
6th
Average Rating
7.8
Reviews Sentiment
8.0
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Microsoft SQL Server Reporting Services is 3.7%, down from 4.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Gnanavel-Chakkarapani - PeerSpot reviewer
Offers useful templates but needs to improve the connectivity offered
In Microsoft SQL Server Reporting Services, not much of the interface part is used. With Microsoft SQL Server Reporting Services, its users face issues with the interface after they use Excel or create Microsoft SSIS Packages. The tool's interface is an area of concern requiring improvement. There needs to be an improvement in the product's connectivity so that the tool can connect easily with other third-party databases. In the dashboard, drag and drop functionality needs to improve, especially when compared to other tools like IBM Cognos Analytics and Qlik Sense. Microsoft SQL Server Reporting Services is useful only for standard reports. In IBM Cognos Analytics, query studio can be used by users to drag the data and simply download the reports, so the user doesn't need to have any technical knowledge like developers. Microsoft SQL Server Reporting Services is to be improved to offer features like query Studio, which is provided in IBM Cognos Analytics.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution's initial setup process is easy."
"It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"The dashboarding offered by this solution is very valuable to us."
"The main difference that I like about Cognos compared to other solutions is its data splitting functionality. We have all our company data inside the Cognos environment and so we prefer to split the information Cognos itself. It's more efficient this way."
"The basic platform comes with several meta-modelling tools."
"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"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."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"We get good support from Microsoft."
"The initial setup is easy."
"It is scalable."
"Microsoft SQL Server Reporting Services (SSRS) is reliable for management dashboard and reporting purposes. It is helpful for user reporting and administrative tasks, such as monitoring progress. It is easy to use since it is lightweight and integrates well with the SQL Server database, making reporting straightforward. The visualization capabilities enhance our reporting needs with good pagination and KPI features. It integrates well with data servers and workbooks, allowing us to publish reports on mobile applications and tablets easily. Integrating other tools and platforms in our tech ecosystem is generally straightforward. However, if we need to perform something very specialized, we might have to use third-party tools rather than inbuilt options."
"The solution is known for its robust security features."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"In Microsoft SQL Server Reporting Services, the installation and configuration are easy."
 

Cons

"IBM Support can be slow at times, but they can usually deliver in a timely manner."
"It is a costly product; it is comparatively expensive."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"One thing that we really want is the ability to have data portrayed on an image. Cognos is not able to do it at the moment, and that's becoming a requirement from the business side: having an image and then plotting your dataset on top of the image as a map."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required."
"It would be nice to offer free online training on the tool for end-users."
"I would like to see is more easy building, movement in the reports, and dashboard functionality within reporting. Overall more simple elements within reports. If the elements are simple then you don't have to render a full page, but you can move separate parts in the page."
"The setup is difficult because you have to install different servers."
"I would like the solution to add the scheduling feature for reports."
"It would be really nice to have better integration between the solution and Power BI."
"It is not easy to integrate the product with other tools in the market."
"The solution's interface is old."
"In this solution, the cost should be reduced for the enterprise edition."
"The complex tuning for report performance is complicated. There is a lack of native support for source code control. We often need to use separate tools like VS Code or other software to manage version control and changes in the database. It would be beneficial if source code management were integrated directly into SSRS, thus eliminating the need to rely on external tools. While CLI-based operations are exemplary, the trend is towards GUI for a better user experience. Integrating both visualization and source code management within SSRS would simplify the process for users."
"Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality."
 

Pricing and Cost Advice

"It is my understanding that the cost is very low. It's not very expensive."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"It's more expensive than similar solutions like Tableau and Power BI."
"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"It is pretty expensive."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
"The solution is cheaper than its alternatives."
"The tool's licensing costs are expensive."
"The solution is free to use for developers."
"Value-wise, the solution's pricing is good for the price that we pay."
"The solution is expensive."
"The pricing is high."
"The price is pretty good."
"The product pricing is reasonable in terms of suitable features for business."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Educational Organization
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
14%
Government
12%
Computer Software Company
10%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
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 Enter...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older versions like IBM Cognos 10 or 8. Additionally, the Event Studio, which offered great f...
What do you like most about Microsoft SQL Server Reporting Services?
I mainly use the solution for the ease of reporting and for executive dashboards.
What is your experience regarding pricing and costs for Microsoft SQL Server Reporting Services?
Microsoft SQL Server Reporting Services should be okay if you're within the budget. We're just using open-source solutions if you're not within the budget. Sometimes, we use MySQL or something simi...
What needs improvement with Microsoft SQL Server Reporting Services?
QL Server can support the customer language in the long term, so we can use another language to build some components.
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
 

Learn More

 

Overview

 

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.
CMS Wire, The New York Times
Find out what your peers are saying about IBM Cognos vs. Microsoft SQL Server Reporting Services and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.