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 integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit."
"They are very reliable and cost-effective."
"It is a highly stable solution and it's easy to use."
"Very interactive and provides flexibility."
"Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The tool is a specific and effective system. I am impressed with its usability."
"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."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"Oracle has good technical support."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"Oracle Database Appliance provides high stability."
"The product needs a tool that allows for work from a laptop instead of a browser."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"More integration is needed to improve the product for the future."
"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."
"It's a complicated product."
"The support and price could improve."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
"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."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"I would like it if the scalability could be increased without having to change versions."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"They could incorporate a more secure and internet-centric management system for the platform."
"Oracle's product support is an area of concern where improvements are required."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
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.