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

Microsoft Azure Synapse Analytics vs Oracle Database Appliance comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

ROI

Sentiment score
7.0
Microsoft Azure Synapse Analytics provides cost savings and efficiency with serverless options, achieving up to 70% ROI in years.
Sentiment score
7.1
Oracle Database Appliance offers long-term value with efficient support and quality, ensuring positive ROI despite variable setup complexity.
 

Customer Service

Sentiment score
6.8
Microsoft Azure Synapse Analytics support varies, with larger clients benefiting more, while smaller clients face slower, less expert assistance.
Sentiment score
6.2
Oracle Database Appliance customer service is generally solid but faces criticism for costs, response times, and mixed hardware service experiences.
Not monitoring data results often in a big impact on customer services and customer perception.
They are slow to respond and not very knowledgeable.
 

Scalability Issues

Sentiment score
7.7
Microsoft Azure Synapse Analytics offers scalable solutions with serverless architecture, appreciated for flexibility and adaptability despite potential costs.
Sentiment score
6.6
Oracle Database Appliance offers scalable CPU and storage options but faces limitations in on-premises scalability and storage scalability.
For the scalability of Microsoft Azure Synapse Analytics, I would rate it a 10 until you remain in the Azure Cloud scalability framework.
Microsoft Azure Synapse Analytics is scalable, offering numerous opportunities for scalability.
All enterprise-grade analytics tools allow rapid scaling, making our business more competitive.
 

Stability Issues

Sentiment score
7.6
Microsoft Azure Synapse Analytics is reliable and efficient, with high user satisfaction despite occasional issues with large datasets.
Sentiment score
7.5
Oracle Database Appliance is praised for stability and performance, with minor issues resolved by support and high satisfaction ratings.
 

Room For Improvement

Microsoft Azure Synapse Analytics users seek better integration, performance, simpler interfaces, affordability, and expanded support for IoT and machine learning.
Oracle Database Appliance requires improved scalability, flexibility, integration, and pricing, along with AI features and better support.
Databricks is a very rich solution, with numerous open sources and capabilities in terms of extract, transform, load, database query, and so forth.
There is a need for better documentation, particularly for customized tasks with Microsoft Azure Synapse Analytics.
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift.
 

Setup Cost

Azure Synapse Analytics is costly yet appreciated for Microsoft integration, requiring careful cost management due to variable pricing.
Oracle Database Appliance is cost-effective for its value, but licensing and support can be expensive compared to alternatives.
When you scale the solution, the cloud doesn't work anymore in terms of cost.
Oracle is on the higher end of the pricing spectrum, along with SAP.
 

Valuable Features

Microsoft Azure Synapse Analytics provides scalable, secure data processing with seamless integration, user-friendly operations, and Power BI compatibility.
Oracle Database Appliance offers easy deployment, scalability, high performance, and seamless integration, popular for data processing and application hosting.
Microsoft Azure Synapse Analytics offers significant visibility, which helps us understand our usage more clearly.
For Microsoft Azure Synapse Analytics, the integration is the most valuable feature, meaning that whatever you need is fast and easy to use.
The most valuable feature is the ease of dashboarding and ease of reporting.
 

Categories and Ranking

Microsoft Azure Synapse Ana...
Average Rating
7.8
Reviews Sentiment
7.0
Number of Reviews
93
Ranking in other categories
Cloud Data Warehouse (5th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
Ranking in other categories
Data Warehouse (5th)
 

Featured Reviews

Renee Hoon - PeerSpot reviewer
Scalable performance tuning and optimization for finance and supply chain jobs
We run our finance and supply chain jobs using SQL BW, and we visualize our data loads on Power BI. We are using SQL Data Warehouse for data warehousing In terms of cost savings, we don't need specialization in skills as advanced as Teradata. We used to pay extensive licensing fees for Teradata,…
Ahmed-Yehia - PeerSpot reviewer
Enhanced performance and simplified operations with integrated features
All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP databases. You can only scale storage, not developer nodes. It's priced a little higher, which could be optimized for small or medium businesses.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,129 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
33%
Manufacturing Company
7%
Financial Services Firm
7%
Computer Software Company
6%
Financial Services Firm
27%
Computer Software Company
12%
Manufacturing Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Microsoft Azure Synapse Analytics?
The product is easy to use, and anybody can easily migrate to advanced DB.
What is your experience regarding pricing and costs for Microsoft Azure Synapse Analytics?
I think the price of Microsoft Azure Synapse Analytics is very expensive, but that's not only for Microsoft Azure Synapse Analytics—it's for the cloud in general. The cloud is not cost-effective. I...
What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.
What needs improvement with Oracle Database Appliance?
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift. When dealing with federated data sources, this integration can be a challenge.
 

Also Known As

Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
X5-2
 

Overview

 

Sample Customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Oracle Database Appliance and other solutions. Updated: May 2025.
859,129 professionals have used our research since 2012.