Microsoft SQL Server Reporting Services vs Oracle OBIEE comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
4,624 views|3,276 comparisons
86% willing to recommend
Oracle Logo
8,365 views|4,236 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft SQL Server Reporting Services and Oracle OBIEE based on real PeerSpot user reviews.

Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Microsoft SQL Server Reporting Services vs. Oracle OBIEE Report (Updated: March 2024).
772,679 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution is known for its robust security features.""I mainly use the solution for the ease of reporting and for executive dashboards.""I like Microsoft SQL Server Reporting Services' automated reporting feature.""It is a stable solution.""We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities.""In Microsoft SQL Server Reporting Services, the installation and configuration are easy.""The tool's valuable features are its drill-down feature, graphs, and charts.""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."

More Microsoft SQL Server Reporting Services Pros →

"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.""The solution is easy to use and very flexible.""It provides excellent stability.""The solution offers a wide range of software tools to meet various needs, such as those concerning reports, developer solutions like APEX and the integration of data.""I like the scheduling feature. It has an inbuilt scheduler which is very good, and it allows us to create agents, and those agents can be scheduled. It's quite flexible in that respect and goes into our IT infrastructure. The outputs are sent encrypted to various endpoints. Some are internal, and some are our clients, and it's encrypted at a high level. I do find Oracle OBIEE flexible. If there is stuff that's not in your model or schema, it's very flexible to create SQL scripts and create the data you want. It's quite nice to create a dashboard in OBIEE, and that's pretty straightforward in the way you drag and drop everything. You can create sections, and you can add elements to your page. That bit of the interface is relatively straightforward.""The most valuable feature of Oracle OBIEE is its ease of use.""In terms of features, everything is good. It is also stable and scalable.""The most valuable feature is the openness of the solution. It helps us integrate some of our clients."

More Oracle OBIEE Pros →

Cons
"It is not easy to integrate the product with other tools in the market.""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.""Technical support is in minor need of improvement so that they can solve problems in a more timely manner.""Sometimes, we need to make sure that the configuration stays consistent across the reporting instances. They all connect to the same database. So, it shares that same backend, but the reporting services itself can also be configured. On the application level, for reporting level. And it is, based on my own experience, it is a manual effort to make sure that the reporting servers are configured the same across the environment.""It would be really nice to have better integration between the solution and Power BI.""Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality.""The product could be improved by reducing the time it takes to build and deploy reports."

More Microsoft SQL Server Reporting Services Cons →

"It is complex for designing RPD, and it can be simpler. Their support can also be improved in terms of response time.""There are times we have slowness when processing the reports with Oracle OBIEE. Improving the performance would be beneficial.""It would be better if it had a wide range of visualization options. For example, Microsoft Power BI has an extensive range of visualization options, but it's not available in OBIEE. There are also some conflicts because it's complicated, but the cloud application is easier. They added some features for ETL with the on-premises application, but we need a different or a separate application for ETL in the cloud. In the next release, I would like to have more AI features.""Even though we have a feature to enable the physical query to be seen in the log, in case of any issues, it is challenging to debug and see or identify where is the issue. For example, we designed the OBIEE repository and deployed it into the server, and we are now accessing and creating a report. For some reason, if the report is not working as expected, it is very difficult to identify the issue. We have a feature to see the physical query that is being generated in the central OBIEE server. I feel that this feature should have been available at the repository level so that while designing the repository, we can select the presentation columns and the query it is going to create. This will avoid the additional task of deploying a feature into the server and then testing the report. It will also make the implementation process friendly if, while designing the repository, we can see: How is a feature working? Are any of the presentation columns selected? How is the query being generated? Which query is being generated? Are any joints used? What kind of joints are used? Having this kind of information will make Oracle OBIEE more powerful and developer-friendly.""Warehouse and business intelligence are two different things, but OBIEE also has some warehouse features in it. I would like to see some of those capabilities improved.""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.""n the beginning it had it's stability issues, but it became stable.""Oracle OBIEE could improve the visualizations, such as diagrams, charts, and graphical user interface. Other tools on the market have better graphical visualizations this Oracle OBIEE."

More Oracle OBIEE Cons →

Pricing and Cost Advice
  • "The price is pretty good."
  • "The solution is expensive."
  • "The solution is cheaper than its alternatives."
  • "The solution is free to use for developers."
  • "The tool's licensing costs are expensive."
  • "Value-wise, the solution's pricing is good for the price that we pay."
  • "The product pricing is reasonable in terms of suitable features for business."
  • More Microsoft SQL Server Reporting Services Pricing and Cost Advice →

  • "It is high."
  • "It's expensive."
  • "I think to spread this across an enterprise will be a significant investment."
  • "Be prepared to spend a lot of time and money."
  • "The pricing we negotiated with Oracle. But, I do not have details."
  • "Oracle products are extremely expensive."
  • "This was not an expensive product for us, although the price varies depending on conditions for each company."
  • "The cost of this solution is a little bit high compared with other products like Zoho, so reducing it would make OBIEE more competitive."
  • More Oracle OBIEE Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Reporting solutions are best for your needs.
    772,679 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:I mainly use the solution for the ease of reporting and for executive dashboards.
    Top Answer:According to me, the solution's pricing is very expensive, but I don't know how much Oracle or other competitors would cost. Since I am unfamiliar with other pricing schemes, the solution's pricing… more »
    Top Answer:I'm starting to use Power BI this year, and it would be really nice to have better integration between the solution and Power BI.
    Top Answer: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… more »
    Top Answer: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. OBIEE… more »
    Top Answer: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.
    Ranking
    7th
    out of 49 in Reporting
    Views
    4,624
    Comparisons
    3,276
    Reviews
    12
    Average Words per Review
    353
    Rating
    7.9
    3rd
    out of 49 in Reporting
    Views
    8,365
    Comparisons
    4,236
    Reviews
    24
    Average Words per Review
    481
    Rating
    8.0
    Comparisons
    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
    Learn More
    Overview

    At Microsoft, our mission is to empower every person and every organization on the planet to achieve more. Our mission is grounded in both the world in which we live and the future we strive to create. Today, we live in a mobile-first, cloud-first world, and the transformation we are driving across our businesses is designed to enable Microsoft and our customers to thrive in this world.

    We do business in 170 countries and are made up of 114,000 passionate employees dedicated to fulfilling our mission of helping you and your organization achieve more.

    Oracle OBIEE (Oracle Business Information Enterprise Edition) is a business intelligence (BI) tool developed by Oracle. OBIEE will gather, store and analyze an organization's network data and compile the information to create reports, dashboard graphs, and performance analysis. OBIEE’s unique platform allows clients to discover new awareness and improve the speed of completing important business decisions by providing robust visual tools and intuitive realization coupled with the latest unmatched enterprise analytics available. OBIEE helps IT enterprise organizations to experience an intelligent view of all enterprise data from across all sources and empowers trusted users with increased levels of reliable, dependable access, interaction, and the ability to utilize the data to increase the overall effectiveness and productivity of the organization.

    OBIEE provides unique immediate mobile access, intuitive dashboards, robust reporting, real-time alerts, metadata search, procedure management, direct access to Big Data resources, enlightened in-memory computing, and seamless systems management processes. These features seamlessly combine to make Oracle OBIEE a complete, top-of-the-line broad solution that is cost-effective, minimizes TCO, and provides a competitive, quick ROI for the entire organization.

    Oracle OBIEE Top Features 

    • Complete comprehension: Oracle OBIEE offers a full range of BI strategies, including intuitive smart dashboards, dynamic alerts and detection, efficient workflows, enterprise reporting, MS Office integration, real-time predictive analysis, and more. OBIEE also includes many next-generation options, including mission critical scalability and performance, diverse data access and integration, and a modern, robust, service-oriented architecture.
    • Hot-pluggable: OBIEE will take advantage of existing IT relationships, both Oracle and non-Oracle databases, solutions, and applications. Organizations that partner with OBIEE have access to an entire library of analytic tools that are immediately deployable and provide an improved TCO and a super-fast ROI. Additionally, in an outstanding collaboration with Hyperion, OBIEE incorporates BI tools that integrate well with the current suite to supply the grandest selection of BI tools available on the market today.
    • Extensive: OBIEE is very user-friendly and extremely intuitive, and the 100% Web UI brings robust and dynamic BI from diverse sources to any audience, distributing awareness when and where users require it to manage activities, decisions, and processes. 

    Reviews from Real Users

    Sandeep V., Process System Engineer at a comms service provider, tells us, “This solution is very easy for people who are building ad-hoc things. It's an enterprise solution so it can be deployed for a lot of users. There are some great new features that come with the 12c like data visualization, desktop BI Publisher, automation, and interactive dashboards. The product has good features. “ 

    A user who is a CEO at a consultancy relates, “The most valuable feature is the visualization. The data warehousing, data storage, and data wrangling are all features that are in there, and it's one of the better products out there. A good thing is that for large datasets, it's very stable, especially when you have an Oracle database.”

    A user who is a Principal Business Intelligence Architect at a computer software company suggests, "It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market."



    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.
    Top Industries
    REVIEWERS
    Computer Software Company25%
    Financial Services Firm17%
    Retailer8%
    Healthcare Company8%
    VISITORS READING REVIEWS
    Financial Services Firm15%
    Government10%
    Computer Software Company10%
    Healthcare Company7%
    REVIEWERS
    Financial Services Firm12%
    Computer Software Company12%
    Manufacturing Company10%
    Government7%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Government12%
    Computer Software Company12%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business26%
    Midsize Enterprise11%
    Large Enterprise63%
    VISITORS READING REVIEWS
    Small Business23%
    Midsize Enterprise14%
    Large Enterprise63%
    REVIEWERS
    Small Business22%
    Midsize Enterprise20%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise13%
    Large Enterprise71%
    Buyer's Guide
    Microsoft SQL Servering Services vs. Oracle OBIEE
    March 2024
    Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. Oracle OBIEE and other solutions. Updated: March 2024.
    772,679 professionals have used our research since 2012.

    Microsoft SQL Server Reporting Services is ranked 7th in Reporting with 16 reviews while Oracle OBIEE is ranked 3rd in Reporting with 154 reviews. Microsoft SQL Server Reporting Services is rated 7.8, while Oracle OBIEE is rated 7.8. The top reviewer of Microsoft SQL Server Reporting Services writes "Offers useful templates but needs to improve the connectivity offered". On the other hand, the top reviewer of Oracle OBIEE writes "A solution that is easily accessible, scalable and requires a straightforward initial setup process to get started". Microsoft SQL Server Reporting Services is most compared with Microsoft Power BI, TIBCO Jaspersoft, Tableau, SAP Crystal Reports and IBM Cognos, whereas Oracle OBIEE is most compared with Microsoft Power BI, IBM Cognos, SAP BusinessObjects Business Intelligence Platform, Tableau and MicroStrategy. See our Microsoft SQL Server Reporting Services vs. Oracle OBIEE report.

    See our list of best Reporting vendors.

    We monitor all Reporting 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.