We performed a comparison between Microsoft Azure Synapse Analytics and Oracle Exadata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"We can have the dedicated SQL up and running within 15 minutes."
"Synapse Analytics gives you information and reports in real-time."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"Fills the gap between big data and classic data warehouses."
"The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"The performance on the databases is good."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"They just have a lot of products, and they work well together."
"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."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"Complete management occurs from one single address instead of different servers."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"The most valuable feature is storage offloading."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"The performance and data consistency need to be improved."
"I would like to see version control implemented into the data warehouse."
"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."
"The filing can be improved."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."
"The solution lacks a visualized console."
"The cost of the solution is high and can be improved."
"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 integration with third-party applications regarding access management security could be better."
"Exadata would be improved with single dashboard visibility."
"We used the support from Oracle Exadata to complete the implementation."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Oracle Exadata is rated 8.4. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". On the other hand, the top reviewer of Oracle Exadata writes "Offers a variety of valuable features". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake and Oracle Autonomous Data Warehouse, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse and Snowflake. See our Microsoft Azure Synapse Analytics vs. Oracle Exadata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.