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

Microsoft Azure Synapse Analytics vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Microsoft Azure Synapse Ana...
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
91
Ranking in other categories
Cloud Data Warehouse (2nd)
Oracle Exadata
Average Rating
8.6
Reviews Sentiment
6.8
Number of Reviews
126
Ranking in other categories
Data Warehouse (2nd)
 

Featured Reviews

Sunil Gidwani - PeerSpot reviewer
No competitors provide the entire solution to one place
I rate Azure Synapse Analytics eight out of 10. No competitors provide the entire solution to one place like Synapse. For example, a database just focuses moving and manipulating data, etc. But Synapse is like an all-inclusive workspace. I advise other people to go with Databricks Notebook if you need a computation engine. It has a solid SQL storage procedure. Suppose you are dealing with complex transformation logic and manipulation of run-time data flows. In that case, it's better to use Databricks than any Microsoft ADF. DataBricks looks more promising in terms of computing in memory, so we integrated Databricks in Synapse.
Guruprasad Gonjare - PeerSpot reviewer
Offers a variety of valuable features
The deployment depends on the Exadata options. There are primarily three options which include, Exadata, Exadata Cloud@Customer, and Exadata Cloud Service. Out of these, Cloud Service requires the minimum effort. The deployment takes around two to three weeks to complete. For the deployment purpose, we need information on the user base where the access is going to happen. We would also require around four to five engineers and admins for the solution’s deployment and maintenance. This estimation is based on the workflow.

Quotes from Members

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

Pros

"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"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 a benefit."
"It is a fantastic product; we are satisfied with its features and performance."
"The pricing seems to be quite fair."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"The initial setup is very simple."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"Exadata with the In-Memory option is several levels about SAP HANA."
"The most valuable feature is the time to solution."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"The tool performs well with a large database."
"The offloading of data to the SIM is a valuable feature."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"A very stable solution, which we have hardly any problems with."
 

Cons

"We'd, of course, always like to pay less for the service if we can."
"One area that could be improved is the schema management."
"Could have more connectors and better integration for Hadoop."
"Non-structured data is unavailable with this product."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"The solution could always be more stable and more reliable."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"The technical support is in need of improvement."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"The handling of temp space has room for improvement."
"The performance could be improved."
"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."
 

Pricing and Cost Advice

"I think Microsoft Azure Synapse Analytics is priced well, and I would rate the price at eight out of ten."
"Microsoft Azure Synapse Analytics is an expensive solution and there is a license needed to use it. My company has an enterprise license."
"The solution is subscription-based. You can also pay to use the product as you go."
"The solution could improve by having better costing information."
"Pay for what you use"
"The pricing is quite reasonable in comparison to other products."
"The cost of the solution depends on the type of license we choose, such as pay-as-you-go, one-year reserve, or three-year reserve."
"Our license is very expensive"
"The price of the solution has been expensive to implement."
"The solution is expensive."
"You have to pay for the storage and the database in Oracle Exadata. It cost a lot, but it is worth it. It would be a benefit if we could reduce the price for the number of CPUs and extend the memory."
"The cost of the product could be improved."
"The Initial investment price could use improvement"
"The price is very high."
"The cost of the solution is high."
"Our customers are always looking to reduce the license's cost."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
47%
Computer Software Company
7%
Financial Services Firm
6%
Manufacturing Company
5%
Financial Services Firm
29%
Computer Software Company
13%
Manufacturing Company
6%
Government
5%
 

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?
The financial aspect, including pricing and cost reduction, is not something I focus on.
What do you like most about Oracle Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The pricing of Exadata is high. It is more expensive than usual, making it suitable only for big enterprises or businesses that can afford it.
What needs improvement with Oracle Exadata?
I would like to add some features to run applications or microservices-based applications on Exadata.
 

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
 

Learn More

 

Overview

 

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.
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Oracle Exadata and other solutions. Updated: November 2024.
824,053 professionals have used our research since 2012.