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."It's scalable; you can scale up and scale down."
"We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."
"They are available on the Cloud, and the platform is very intuitive."
"Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"Fills the gap between big data and classic data warehouses."
"It's user-friendly and has a good dashboard."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"The performance of the data is the most important part."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"The performance on the databases is good."
"Parallelism is the most valuable feature."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"Oracle Exadata is stable."
"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."
"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."
"Integration with other products is an area that can be improved."
"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."
"Documentation could be improved."
"The product needs a tool that allows for work from a laptop instead of a browser."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"There's room for improvement in terms of deployment, as it could be made faster and more user-friendly."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"The solution lacks a visualized console."
"Checking the Smart Scan issues is complicated."
"I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
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 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.