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

Microsoft Azure Synapse Analytics vs Oracle Big Data 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:
 

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 Big Data Appliance
Average Rating
8.0
Reviews Sentiment
7.5
Number of Reviews
5
Ranking in other categories
Data Warehouse (19th)
 

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,…
Mohammed Hamad - PeerSpot reviewer
Provides clean, centralized data
From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera. Oracle could also improve Big Data Appliance by having one technology on their stack and working on it instead of continually changing the name or technologies or features. In addition, they could have a program to enable their partners to use this technology because right now, I have to have an expert to use the AI elements.

Quotes from Members

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

Pros

"Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to."
"I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works."
"The most valuable feature is the scalability."
"For Microsoft Azure Synapse Analytics, the integration is the most valuable feature, meaning that whatever you need is fast and easy to use."
"Can capture all the transactional data throughout a company."
"Microsoft Azure Synapse Analytics offers significant visibility, which helps us understand our usage more clearly."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"This is a comprehensive solution that is easy to deploy."
 

Cons

"The solution should offer a serverless model like Snowflake."
"The cost of the solution has room for improvement."
"Could have more connectors and better integration for Hadoop."
"It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
"The support and price could improve."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"The security performance and cost are the two things that needs improvement."
"We'd, of course, always like to pay less for the service if we can."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"The product should be simplified for the average user."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
 

Pricing and Cost Advice

"The solution is very expensive because it often requires the purchase of additional storage."
"This is an expensive solution."
"Price varies by use-case. You pay for the database itself in addition to any consumed data within Serverless plus other fees if you use the Data Factory that is inside."
"Price is dependent of the use case of the customer. Customers are not likely to only use this as an individual platform/database, they are likely to bundle it with the Azure stack."
"The solution is expensive at the enterprise level."
"It requires a less expensive version because currently, not every customer is able to buy it. If it could have a smaller setup that doesn't require so many resources, it would be helpful, and we would be able to use it in more cases. We are a small country, and most of our customers are quite small businesses."
"All of the prices are available online."
"We have a licensing cost to pay."
"Oracle's prices are too high compared to others in the market."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
859,687 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
30%
Manufacturing Company
7%
Financial Services Firm
7%
Computer Software Company
6%
Financial Services Firm
29%
Computer Software Company
15%
Government
8%
Manufacturing Company
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...
Ask a question
Earn 20 points
 

Also Known As

Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
No data available
 

Overview

 

Sample Customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Caixa Bank
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Oracle Big Data Appliance and other solutions. Updated: May 2025.
859,687 professionals have used our research since 2012.