We just raised a $30M Series A: Read our story

Compare Microsoft Azure Synapse Analytics vs. Oracle Exadata

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: November 2021.
552,305 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The stability is pretty good.""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.""The useability, the user interface, is very user-friendly.""The pricing seems to be quite fair.""We've had a good experience with technical support in general.""The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.""The solution's scalability is very, very good. It's one of the most important aspects for us.""The whole solution is interesting for us."

More Microsoft Azure Synapse Analytics Pros »

"On-premises Exadata is just as stable as the cloud version. It's a very stable platform.""Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it.""Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement.""The storage capacity and the performance of Oracle Exadata are good. When comparing the performance to other technologies it is very good. I am satisfied with the management of the solution.""The business intelligence is very good.""The data replication is very good.""Our machine is used for our internal development of Oracle-based solutions, PoC benchmarking, and training/familiarization.""We can use virtualization on Exadata."

More Oracle Exadata Pros »

Cons
"More integration is needed to improve the product for the future.""It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft.""The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.""In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks.""I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.""I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.""I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good.""The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration."

More Microsoft Azure Synapse Analytics Cons »

"We would like an option of a hardware-only support solution, but Oracle currently does not provide this.""The improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration.""It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle.""The solution could always be more stable and more reliable.""There is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions.""We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components.""Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up.""The setup is a little bit complex. We would like to see the installation part get easier."

More Oracle Exadata Cons »

Pricing and Cost Advice
"The price of the package not expensive and depends on how much it is used.""We are on a monthly payment plan for the use of Microsoft Azure Synapse Analytics.""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.""There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be.""It goes by the usage, and there are some limits. Synapse goes by particular pricing, and it is expensive. Both Azure Synapse Analytics and Snowflake are pretty expensive. They don't have standard pricing. They deal with each customer differently.""It's very difficult to price unless you know exactly how the customer is using it.""The solution is subscription-based. You can also pay to use the product as you go.""We normally pay between $300 and $500 per month, which is quite expensive for how much we actually use it, performance- and usage-wise. They have a cheap version and an expensive version, and our usage usually falls in the middle ground, which makes it not as cost-effective as it could be."

More Microsoft Azure Synapse Analytics Pricing and Cost Advice »

"It is an expensive product and you pay more for certain performance enhancements.""Oracle is always costly but it's fine.""The price of the solution has been expensive to implement.""All things considered, the price of this product is fairly high, as is always the case with Oracle.""Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution.""The majority of our customers are in government or big enterprises, and the projects that we sell come out to several million USD. With this amount of money on the table, it's always better to have an experienced team of consultants, who know Exadata very well, handle the implementation.""The cost of the product could be improved.""I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential."

More Oracle Exadata Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
552,305 professionals have used our research since 2012.
Questions from the Community
Top Answer: 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… more »
Top Answer: Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
Top Answer: The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is… more »
Top Answer: The performance on the databases is good.
Top Answer: When you talk about the pricing, the pricing is on the higher side. That said, if you're looking for good performance, then you definitely need to pay the price. Therefore, the price is reasonable.
Top Answer: The setup is a little bit complex. We would like to see the installation part get easier. Also, this installation is only for the OEM. They need partners. Some liberty should be given to the customer… more »
Ranking
2nd
Views
25,859
Comparisons
19,178
Reviews
36
Average Words per Review
550
Rating
7.9
2nd
out of 30 in Data Warehouse
Views
15,798
Comparisons
11,481
Reviews
18
Average Words per Review
710
Rating
8.8
Comparisons
Also Known As
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Learn More
Overview

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

Oracle Exadata Database Machine is a modern framework, engineered to run databases and to scale out database servers.

The main benefit of Exadata is speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors and data warehouses, while solving poor performances of old database architecture.

The Oracle Exadata Database Machine features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information. It is ideal for companies looking to build up their infrastructure from scratch.

For more information on Oracle Exadata Database Machine, visit Oracle.com

Offer
Learn more about Microsoft Azure Synapse Analytics
Learn more about Oracle Exadata
Sample Customers
Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
Top Industries
REVIEWERS
Comms Service Provider18%
Computer Software Company18%
Manufacturing Company12%
Insurance Company12%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider18%
Financial Services Firm6%
Energy/Utilities Company6%
REVIEWERS
Financial Services Firm28%
Comms Service Provider15%
Insurance Company13%
Retailer9%
VISITORS READING REVIEWS
Computer Software Company37%
Comms Service Provider14%
Financial Services Firm12%
Government4%
Company Size
REVIEWERS
Small Business32%
Midsize Enterprise23%
Large Enterprise45%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise11%
Large Enterprise74%
REVIEWERS
Small Business27%
Midsize Enterprise12%
Large Enterprise61%
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: November 2021.
552,305 professionals have used our research since 2012.

Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 22 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while Oracle Exadata is rated 8.8. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of Oracle Exadata writes "High performing and reliable work environment". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA, Apache Hadoop and AWS Lake Formation, whereas Oracle Exadata is most compared with Teradata, Oracle Database Appliance, Snowflake, IBM Netezza Performance Server and Oracle Big Data Appliance.

We monitor all Cloud Data Warehouse 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.