TrustRadius: an HG Insights company

Azure Analysis Services vs. Oracle Discoverer (discontinued)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure Analysis Services

    Score8.6 out of 10
    N/AAzure Analysis Services delivers enterprise-grade BI semantic modeling capabilities with the scale, flexibility, and management benefits of the cloud. Azure Analysis Services helps transform complex data into actionable insights. Azure Analysis Services is built on the analytics engine in Microsoft SQL Server Analysis Services.N/A

    Oracle Discoverer (discontinued)

    Score8.4 out of 10
    N/AOracle's Business Intelligence Discoverer is an ad- hoc query and analysis reporting tool oriented for end users to have easy access to relational and multi-dimensional data. The product is now end of life. The vendor has stated that Discoverer 11g release 11.1.1.7.0 is the terminal release of Discoverer.N/A
    Pricing
    Azure Analysis ServicesOracle Discoverer (discontinued)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Azure Analysis ServicesOracle Discoverer (discontinued)
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details
    More Pricing Information
    Community Pulse
    Azure Analysis ServicesOracle Discoverer (discontinued)
    Considered Both Products
    Microsoft
    No answer on this topic
    Discontinued Products
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    9 Answers
    No answers on this topic
    Delivers good value for the price
    100%
    Delivers good value for the price
    9 Answers
    No answers on this topic
    Happy with the feature set
    100%
    Happy with the feature set
    9 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    7 Answers
    No answers on this topic
    Implementation went as expected
    100%
    Implementation went as expected
    9 Answers
    No answers on this topic
    Features
    Azure Analysis ServicesOracle Discoverer (discontinued)
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    8.6
    8 Ratings
    5% above category average
    Oracle Discoverer (discontinued)
    7.9
    20 Ratings
    3% below category average
    Pixel Perfect reports8.88 Ratings8.017 Ratings
    Customizable dashboards8.77 Ratings7.717 Ratings
    Report Formatting Templates8.58 Ratings8.020 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    8.8
    8 Ratings
    9% above category average
    Oracle Discoverer (discontinued)
    7.9
    22 Ratings
    2% below category average
    Drill-down analysis8.96 Ratings7.021 Ratings
    Formatting capabilities8.77 Ratings8.022 Ratings
    Integration with R or other statistical packages8.77 Ratings7.514 Ratings
    Report sharing and collaboration9.08 Ratings9.020 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    9.0
    8 Ratings
    9% above category average
    Oracle Discoverer (discontinued)
    8.3
    22 Ratings
    1% above category average
    Publish to Web9.08 Ratings8.021 Ratings
    Publish to PDF8.97 Ratings9.020 Ratings
    Report Versioning9.37 Ratings9.018 Ratings
    Report Delivery Scheduling9.08 Ratings8.022 Ratings
    Delivery to Remote Servers8.57 Ratings7.716 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    9.0
    7 Ratings
    12% above category average
    Oracle Discoverer (discontinued)
    8.0
    16 Ratings
    0% above category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)9.46 Ratings8.416 Ratings
    Location Analytics / Geographic Visualization9.07 Ratings7.815 Ratings
    Predictive Analytics8.66 Ratings7.815 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    9.3
    8 Ratings
    9% above category average
    Oracle Discoverer (discontinued)
    9.7
    22 Ratings
    13% above category average
    Multi-User Support (named login)9.27 Ratings10.022 Ratings
    Role-Based Security Model9.38 Ratings10.020 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)9.38 Ratings9.021 Ratings
    Single Sign-On (SSO)9.47 Ratings10.017 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    8.6
    7 Ratings
    11% above category average
    Oracle Discoverer (discontinued)
    8.0
    16 Ratings
    4% above category average
    Responsive Design for Web Access8.47 Ratings7.915 Ratings
    Mobile Application9.33 Ratings7.811 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile8.35 Ratings7.811 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Azure Analysis Services and Oracle Discoverer (discontinued)
    Feature
    Azure Analysis Services
    8.8
    7 Ratings
    13% above category average
    Oracle Discoverer (discontinued)
    7.5
    9 Ratings
    3% below category average
    REST API8.96 Ratings8.08 Ratings
    Javascript API8.76 Ratings8.09 Ratings
    iFrames8.85 Ratings8.08 Ratings
    Java API8.77 Ratings7.08 Ratings
    Themeable User Interface (UI)8.34 Ratings8.07 Ratings
    Customizable Platform (Open Source)9.33 Ratings6.08 Ratings
    Best Alternatives
    Azure Analysis ServicesOracle Discoverer (discontinued)
    Small Businesses
    Cyfe
    Score4 out of 10
    Cyfe
    Score4 out of 10
    Medium-sized Companies
    Qlik Cloud Analytics (Qlik Sense)
    Score8.2 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.2 out of 10
    Enterprises
    Jaspersoft Community Edition
    Score7 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Azure Analysis ServicesOracle Discoverer (discontinued)
    Likelihood to Recommend
    9.0
    (9 ratings)
    8.0
    (22 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    8.0
    (21 ratings)
    Data Sources
    -
    (0 ratings)
    9.0
    (21 ratings)
    User Testimonials
    Azure Analysis ServicesOracle Discoverer (discontinued)
    Likelihood to Recommend
    Microsoft
    We would have many technical issues and glitches with previous similar providers but found that Azure Analysis Services can simply handle our workload and memory better. I remember we lost an account due to cloud issues not fully saving or corrupting some files. Granted, this is rare with any cloud but haven't had that issue with the same load of memory with Azure Analysis Services.
    Incentivized
    Read full review
    Discontinued Products
    Discoverer is well suited as a reporting tool where data integration doesn't play a major role. Discoverer suits very well situations where a user has to run a query every day. Discoverer reports can be scheduled and the user can just view the data instead of running the query manually. Also, Discoverer takes away the pain of managing the database credentials. Discoverer is not well suited to situations where the whole enterprise wants to view the same dashboard. Discoverer is more of a departmental BI tool. Discoverer doesn't offer many options to integrate data unless one has to create and handle integration using PL/SQL.
    Incentivized
    Read full review
    Pros
    Microsoft
    • Providing role based access or we can say privilege based on the role to the user if it is integrated with Azure active directory and hence securing the access to sensitive data.
    • We use to run different type of analytics services to get the better result which is hectic if done manually or with human efforts.
    • We also use to collect bulk of data with the help of this tool and run customized test cases for better efficiency of result and better decision making. The result are very crucial and helps in taking big decision.
    • It supports different or we can say heterogeneous database vendors like the Oracle, SQL, and hence make the task easy.
    Incentivized
    Read full review
    Discontinued Products
    • SQL friendly which allows for fast adoption for those users who know how to write in SQL. This makes integration with other programs much easier.
    • Accessing data is very fast even with larger data sets.
    • The layout is clean and organized similar to a spreadsheet which allows for easier viewing and analyzing of the data.
    Incentivized
    Read full review
    Cons
    Microsoft
    • There is very least content available on Microsoft docs and the Internet to get through with AAS.
    • i faced lots of connection issues while implementation.
    • The need for serious platform experience or expertise.
    Incentivized
    Read full review
    Discontinued Products
    • There is always room for more scalability and optimization of performance.
    • Oracle BI changes a lot from version to version. A smoother transition into a new version would be very helpful.
    • Oracle BI's reporting tool is a little hard to use at first. The UI/UX of the tool can use improvement.
    Incentivized
    Read full review
    Alternatives Considered
    Microsoft
    The platform has vast number of features and modules. The UI is sleek and once you get to use to it, you will be able to do a lot of stuff. Also support for data sources is more in Azure Analysis Services.
    Incentivized
    Read full review
    Discontinued Products
    Discoverer was already in place when I joined the company so I was not involved in the selection process. However, I have been involved in the review of Discoverer as compared to alternatives including Business Objects, OBIEE, and SSRS. On a cost benefit analysis Discoverer always came out on top. Changing to another tool never provided enough additional functionality to overcome the cost of conversion and ongoing maintenance.
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • The tool has helped us a lot for taking critical decision which has resulted in the increase of profit of organization by 18 percent.
    • Return on investment is 70 percent as we are unable to utilize the tool with full functionalities, so we are still testing some of the use cases.
    • Human effort has been reduced and task has become automated hence helped in cost management
    Incentivized
    Read full review
    Discontinued Products
    • We have used Discoverer to respond to state sales and use tax audits and saved the company more than the cost of the product. Discoverer has thus assisted in our objective of managing costs.
    • Discoverer is used to provide reports for EEOC reporting assisting our goal of complying with all government requirements.
    Incentivized
    Read full review
    ScreenShots