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 offers strong scalability opportunities."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure. The solution also provides you with many features apart from analytics, for example, storage which makes it better."
"Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path."
"The whole solution is interesting for us."
"The solution handles single or complex items within a second."
"Overall deployment and integration is pretty fast."
"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."
"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."
"The analytics have been very good. We've found them to be quite useful."
"It is a stable and scalable solution."
"The solution integrates well with Power BI."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is a very stable tool...It is an extremely scalable tool."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"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."
"This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market."
"Integration with other products is an area that can be improved."
"One area that could be improved is the schema management."
"The support and price could improve."
"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 product could be more feature-rich."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"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."
"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."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"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."
"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."
"I would like to see an on-premise solution in the future."
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.