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."I like the keynotes and their simplicity. Like other Microsoft products, Microsoft Azure Synapse Analytics is simple to understand and use."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"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."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"We find the serverless tool to be the most valuable feature ."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The product is good value for money. It is a secure solution."
"We primarily use it for OLTP, which has improved our costs."
"We use the solution for our Java applications."
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance."
"The most valuable feature is the performance."
"The product is excellent. It is simple and reliable in terms of installation and maintenance."
"If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"Microsoft Azure Synapse Analytics could improve the section in the solution where you can implement the Python Spark pipelines, it's not the same as in Databricks which would be better."
"It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill."
"Non-structured data is unavailable with this product."
"The initial setup is complex."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"The solution does not support oriented scaling in the synapse."
"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."
"The tool's setup can be easier."
"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."
"Oracle's product support is an area of concern where improvements are required."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"They could incorporate a more secure and internet-centric management system for the platform."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"The license cost could be cheaper, especially for long-term contracts."
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 39 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 Greenplum, 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.
