We performed a comparison between Microsoft Azure Synapse Analytics and Oracle Database Appliance based on real PeerSpot user reviews.
Find out in this report how the two Cloud 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."
"Data can be stored any way you want in the data warehouse."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"The solution handles single or complex items within a second."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage."
"Technical support is okay in terms of the help they provide."
"The pricing seems to be quite fair."
"The product is good value for money. It is a secure solution."
"NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"The solution is simple to use and easy to maintain."
"The solution is pretty automated, which takes out the possibility of human error."
"Oracle is a stable database."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"The product could be more feature-rich."
"There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"The solution should offer a serverless model like Snowflake."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"If we were able to use Oracle Database to create mobile apps, that would be great. I don't know multiple languages, like Java, etc. I need to learn a separate language, right now in order to do this."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"The license cost could be cheaper, especially for long-term contracts."
"The setup is a bit complex."
"Virtualization features could also be improved. A web-based GUI would be a good start."
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 Database Appliance is ranked 6th in Data Warehouse with 38 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while Oracle Database 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 Database Appliance writes "Stable solution with opportunities for performance enhancement". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, SAP BW4HANA, Amazon Redshift and Teradata, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Azure Data Factory. See our Microsoft Azure Synapse Analytics vs. Oracle Database Appliance report.
See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.
We monitor all Cloud 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.