We performed a comparison between Microsoft Azure Synapse Analytics and Oracle Autonomous Data Warehouse 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 pricing seems to be quite fair."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"The product works well with other Azure products."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"They are very reliable and cost-effective."
"It is a highly stable solution and it's easy to use."
"The best thing about it is that it has integration at multiple places. It can talk to more than 90 types of data sources, which is one good thing about it."
"Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The product is easy to use."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"It is a stable and scalable solution."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"Self-patching and runs machine-learning across its logs all the time"
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"A very good integration feature that restricts access to unauthorized people."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"Could have more connectors and better integration for Hadoop."
"The cost of the solution has room for improvement."
"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."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"Non-structured data is unavailable with this product."
"We'd, of course, always like to pay less for the service if we can."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"The initial setup was pretty complex. It was not easy."
"The solution lacks visibility options."
"Ease of connectivity could be improved."
"A lot of the tools that were previously there have now been taken away."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"They should make the solution more user-friendly."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Oracle Autonomous Data Warehouse is rated 8.6. 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 Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Teradata and Amazon Redshift, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, BigQuery, Amazon Redshift and Teradata. See our Microsoft Azure Synapse Analytics vs. Oracle Autonomous Data Warehouse report.
See our list of best Cloud 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.