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 solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"The useability, the user interface, is very user-friendly."
"The setup is pretty simple."
"The whole solution is interesting for us."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"We can have the dedicated SQL up and running within 15 minutes."
"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."
"They are available on the Cloud, and the platform is very intuitive."
"Self-patching and runs machine-learning across its logs all the time"
"A very good integration feature that restricts access to unauthorized people."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"It is a stable and scalable solution."
"The analytics have been very good. We've found them to be quite useful."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"The security performance and cost are the two things that needs improvement."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"More integration is needed to improve the product for the future."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"Could have more connectors and better integration for Hadoop."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"A lot of the tools that were previously there have now been taken away."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"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 solution lacks visibility options."
"The installation process is complex. Oracle can make the installation process better."
"Ease of connectivity could be improved."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"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."
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 Snowflake, Oracle Exadata, 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.