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

Microsoft SQL Server Reporting Services vs Oracle OBIEE comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 4, 2025

Review summaries and opinions

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

Categories and Ranking

Microsoft SQL Server Report...
Ranking in Reporting
6th
Average Rating
7.6
Reviews Sentiment
7.2
Number of Reviews
20
Ranking in other categories
No ranking in other categories
Oracle OBIEE
Ranking in Reporting
3rd
Average Rating
7.8
Reviews Sentiment
6.4
Number of Reviews
157
Ranking in other categories
BI (Business Intelligence) Tools (4th)
 

Mindshare comparison

As of March 2025, in the Reporting category, the mindshare of Microsoft SQL Server Reporting Services is 3.3%, down from 4.8% compared to the previous year. The mindshare of Oracle OBIEE is 4.8%, down from 6.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

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.
VishnuReddy - PeerSpot reviewer
Handles large datasets and easy to interact with and handle but performance could be better
Oracle's technical support usually recommends to upgrade when you contact them for support. They don't focus on fixing the issue at hand or providing guidance on how to do it. If you are in a lower environment, like one version down, they will blindly suggest upgrading. Additional patches are given for other Oracle products like WebLogic, databases, and apps. They fix issues and create patches based on client needs. But from an OBIEE point of view, they mostly provide bundle patches of around 5 to 6 GB that need to be applied and tested end-to-end. It's not an easy way to get small patches, and if issues arise after applying the patches, you have to contact Oracle again.

Quotes from Members

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

Pros

"It is a stable solution."
"With SQL Server Reporting Services, I can create reports and printable reports, known as paginated reports."
"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."
"The solution is known for its robust security features."
"We get good support from Microsoft."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"The most valuable feature of Oracle OBIEE is the security of the solution."
"There are a lot of functions in the product, including a drill-down functionality and level-based hierarchies that are very attractive."
"The solution is user-friendly."
"It is easy to create a report quickly. It does not take much time to create an ad hoc report."
"I have not personally used any such products related to this service, however based on the popular opinion, Microsoft Power BI is more popular. We have never switched from this software due to infrastructure and license related costs. However, my team acknowledges that the Power BI is much more enhanced and includes features that are easier to use, including its drag and drop features. I am not sure, if OBIEE has these features, due to lack of updated versions."
"For me, it makes the difference is in terms of our users being able to take advantage of a product which allows you to get access to data, reports, make decisions quickly, and have better insights regarding operations."
"The main features of this solution are that it is easy to use, intuitive, and user-friendly. When I retrieve the data from the database it is in a very raw form, then when I use the Oracle Report Builder it has advanced intelligence features to allow me to view and make changes to the data easily."
"I like the cloud deployment feature. There are about 20 new features, and they are available on mobile and more. I haven't used any of them, but these features are highly attractive."
 

Cons

"In this solution, the cost should be reduced for the enterprise edition."
"The setup is difficult because you have to install different servers."
"I would like the solution to add the scheduling feature for reports."
"They could improve the scalability and stability of SQL Server Reporting Services."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"There are occasions during maintenance runs when the Check Point monitoring system reports a lot of blocked sessions."
"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."
"It would be really nice to have better integration between the solution and Power BI."
"One significant improvement is the need for simplification. The set up could be more intuitive. An enterprise setup with HA and DR are pretty complex and to get a robust solution one has to play around with Real Application Cluster data sources and FAN notifications as well as WebLogic clustering and external load balancers. SSO also is not that simple to set up especially if you want all your Oracle systems to use the same SSO solution, i.e., no cheating with direct LDAP connectivity."
"While it is a user-friendly, data-driven tool, the data modeling should be easier to use."
"Setup and migration are very complex. Technically, Oracle accessory is extremely complex. These days, the industry demands a kind of Excel analysis, which is very easy to install, set up, and it's very developer-friendly as well as end-user friendly. OBIEE lacks all those features."
"We needed some technical expertise during setup."
"For a beginner, this is a product that is difficult to learn. You cannot learn it quickly."
"If the data is large, the dashboard takes a really long time. So, based on the database, if you have around a million cost contacts, the load time is very low, and the dashboard fails."
"Particularly on the Cloud, a lot of functionality has yet to be ported."
"The complexity of this product means that you need to have a technical team to develop the reports, although this is also true for products like Microsoft BI and Zoho."
 

Pricing and Cost Advice

"The price is pretty good."
"The solution is free to use for developers."
"The product pricing is reasonable in terms of suitable features for business."
"The tool's licensing costs are expensive."
"Value-wise, the solution's pricing is good for the price that we pay."
"The pricing is high."
"The solution is cheaper than its alternatives."
"The solution is expensive."
"Power BI is less expensive than Oracle OBIEE. A benefit to Power BI is having the option to work with concurrent licensing."
"I would rate it a 4 out of 5 in terms of pricing."
"The cost of this solution is a little bit high compared with other products like Zoho, so reducing it would make OBIEE more competitive."
"It's expensive."
"It is reasonable, but it depends on how you're going to use it. There are no costs in addition to the standard licensing fees."
"Its licensing is yearly."
"The pricing we negotiated with Oracle. But, I do not have details."
"There are no additional costs, but there might be some charges for the Java feature."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
841,004 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
Financial Services Firm
14%
Government
12%
Computer Software Company
8%
Manufacturing Company
6%
Financial Services Firm
18%
Government
13%
Computer Software Company
10%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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 needs improvement with Microsoft SQL Server Reporting Services?
They could improve the scalability and stability of SQL Server Reporting Services. I haven't used it recently, so I can't provide detailed suggestions on improvements.
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
Which Oracle product is better - OBIEE or Analytics Cloud?
Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to assist customers. These are two attributes that make this system quite valuable. OB...
What do you like most about Oracle OBIEE?
The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand.
 

Also Known As

SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
 

Overview

 

Sample Customers

CMS Wire, The New York Times
Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. Oracle OBIEE and other solutions. Updated: January 2025.
841,004 professionals have used our research since 2012.