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."We have found that it is easy to develop and to do the analytics in the modules of data."
"Technical support is okay in terms of the help they provide."
"They are very reliable and cost-effective."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"Synapse Analytics gives you information and reports in real-time."
"One central workspace to manage everything for your data warehouse including visualization."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"The product is good value for money. It is a secure solution."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"The solution is simple to use and easy to maintain."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"We primarily use it for OLTP, which has improved our costs."
"The product is very light."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"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."
"While the solution is flexible, sometimes this works against the user."
"It could be more stable."
"The need to improve a little bit in terms of user-friendliness."
"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."
"The solution does not support oriented scaling in the synapse."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"The solution's initial setup is not easy."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"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."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"The setup is a bit complex."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"Even though the solution can handle a lot of data, it's just too expensive currently."
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 Database Appliance is ranked 6th in Data Warehouse with 40 reviews. Microsoft Azure Synapse Analytics is rated 7.8, 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 "Simplifies database management tasks and provides high availability and disaster recovery". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Data Services, Dremio and Actian Ingres. 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.