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 whole solution is interesting for us."
"I like the keynotes and their simplicity. Like other Microsoft products, Microsoft Azure Synapse Analytics is simple to understand and use."
"Scaling this solution is easy and the uptime is okay."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"The initial setup was really easy and straightforward."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"Overall deployment and integration is pretty fast."
"The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"Oracle Exadata has very good hardware."
"The offloading of data to the SIM is a valuable feature."
"Parallelism is the most valuable feature."
"It is the best solution for OLTP and data warehousing."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"More integration is needed to improve the product for the future."
"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."
"The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"The product needs a tool that allows for work from a laptop instead of a browser."
"The initial setup is complex."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"The handling of temp space has room for improvement."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"The cost of the solution is high and can be improved."
"It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
"The solution could always be more stable and more reliable."
"It would be good if Exadata made some new features available regarding data retrieval and speed capacity functions."
"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 125 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, Oracle Autonomous Data Warehouse and Teradata, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and Amazon Redshift. 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.