We performed a comparison between Microsoft Azure Synapse Analytics and Oracle Big Data Appliance based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"-"
"This is a comprehensive solution that is easy to deploy."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"I would like to see them provide the ingestion of images."
"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."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"Integration with other vendors has limitations and could be improved."
"Documentation could be improved."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"Microsoft Azure Synapse Analytics's overall integration within the Azure ecosystem could improve. The native Microsoft solution versus another solution, such as Databricks, there are areas where there could be some improvements."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"The product should be simplified for the average user."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
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 Big Data Appliance is ranked 12th in Data Warehouse with 5 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while Oracle Big Data Appliance is rated 8.0. 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 Big Data Appliance writes "Fast, and you don't need technical expertise to use it and produce results". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, SAP BW4HANA, Amazon Redshift and Teradata, whereas Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop and Teradata.
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.