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

Microsoft SQL Server Reporting Services vs TIBCO Jaspersoft comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
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
TIBCO Jaspersoft
Ranking in Reporting
8th
Average Rating
7.4
Reviews Sentiment
6.7
Number of Reviews
28
Ranking in other categories
Embedded BI (6th)
 

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. The mindshare of TIBCO Jaspersoft is 2.8%, up from 2.6% 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.
Chan Sambopol - PeerSpot reviewer
Easy to use with a nice design and good connectivity
TIBCO Jaspersoft has two versions. Version one is the enterprise version, The other one is the community version, and which allows us to use it for free. In the free version, we have to support ourselves. For the enterprise version, you have technical support if you need it. I wish that we had more support while in the portal, at least for the community version, or if we could talk to someone regarding issues, like how to configure or fine-tune would be helpful. We'd like to have help on how to solve some problems when we use the product and have some error or limitation. They need to, at the very least, improve the community. The Enterprise Edition has support, and we can force some tickets through the portal and then have an engineer support us in some cases. However, in terms of the subscription price, it's a bit high. Therefore, we'd like to see the community version offer a little bit more support and better documentation and we'd like the enterprise edition to have better pricing.

Quotes from Members

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

Pros

"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."
"Self-service is possible through the use of dashboards, which are also very intuitive. Stories can be used to pin snapshots, tell the story for meetings, etc."
"IBM Cognos improves the effectiveness of the sales team."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"The dashboarding offered by this solution is very valuable to us."
"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."
"The solution's features are all just wrapped up in one nice easy package. I don't need a lot of toolsets to get everything I need done."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"The initial setup is easy."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"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 stability of SSRS has been reliable, with minimal issues encountered during our usage."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"I'm very satisfied with the customer service. And usually, whenever we have any issue or details, we get to the person for the support. I'm really satisfied with the service. Within a few minutes or within a few hours, the support person will be available."
"The feature that I like most is the drag and drop capability."
"The growth time is the most valuable feature of TIBCO Jaspersoft."
"With the online view, it's easier to create Ad Hoc reports. It has inbuilt reports so we can easily get data from the system and customize the fields."
"Stability-wise, I rate the solution a ten out of ten...The deployment process of TIBCO Jaspersoft is easy."
"The solution is standalone with the flexibility to use visualize.js to embed within the application."
"It's easy to use and maintain."
"We find the access restrictions on different user groups valuable."
"We can set any property dynamically."
 

Cons

"This product could use improvement in terms of usability for those with less technical know how."
"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 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."
"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"The high cost of a license makes it hard to scale up on a budget."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"The charts and graphics are weak."
"The technical support team’s response time is slow and needs to be improved."
"I would like the solution to add the scheduling feature for reports."
"Technical support is in minor need of improvement so that they can solve problems in a more timely manner."
"The setup is difficult because you have to install different servers."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"Microsoft SQL Server Reporting Services needs to improve performance."
"We encounter some barriers while trying to build a report."
"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."
"There might be some compatibility issues with the dashboard if we're using the latest version and some clients are using the older version. Some features might not be supported."
"The stability of TIBCO Jaspersoft needs improvement."
"The upgrades are not easy."
"We'd like to see the community version offer a little bit more support and better documentation and we'd like the enterprise edition to have better pricing."
"The reporting templates have room for improvement."
"TIBCO Jaspersoft would benefit from enabling you to run multiple reports in one file and incorporating more options related to multiple reports."
"A better focus should be put on self-service reporting."
"Customization is an area with certain shortcomings in the solution that needs improvement."
 

Pricing and Cost Advice

"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."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"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 is my understanding that the cost is very low. It's not very expensive."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"The solution is affordable."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"It's more expensive than similar solutions like Tableau and Power BI."
"Value-wise, the solution's pricing is good for the price that we pay."
"The tool's licensing costs are expensive."
"The product pricing is reasonable in terms of suitable features for business."
"The solution is cheaper than its alternatives."
"The price is pretty good."
"The solution is expensive."
"The pricing is high."
"The solution is free to use for developers."
"The pricing is cost effective because it is based on servers rather than users."
"The solution is a little bit expensive."
"Since I checked last time, only one annual license costs about $25,000."
"I find the price to be reliable and not overly costly."
"I would rate the pricing as four out of five because it's expensive."
"I give the cost of the solution a five out of ten."
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_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

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%
Financial Services Firm
20%
Computer Software Company
18%
Government
8%
Manufacturing Company
8%
 

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 ...
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 version...
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 solu...
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.
Seeking lightweight open source BI software
The best and open source (No cost involved) solution for all BI requirements is Jaspersoft Open Studio. Refer to raje...
What is your experience regarding pricing and costs for TIBCO Jaspersoft?
The solution is a little bit expensive. I rate the pricing a five out of ten.
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
No data available
 

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
Mosaic, Vander University, Telesoft, Entrust, Ericsson, BT, Groupon, John Hopkins, Puma
Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. TIBCO Jaspersoft and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.