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 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."
"The product is very user friendly."
"The initial setup was really easy and straightforward."
"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 feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"The speed is great and the architecture is excellent."
"They are very reliable and cost-effective."
"-"
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The product is easy to use."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"Self-patching and runs machine-learning across its logs all the time"
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"It is a very stable tool...It is an extremely scalable tool."
"I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use."
"It's a complicated product."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"If I'm looking for something good in the cloud, I would want it to have better standard connectors."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"It could be more stable."
"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."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"The initial setup was pretty complex. It was not easy."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"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."
"Ease of connectivity could be improved."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"A lot of the tools that were previously there have now been taken away."
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.