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 handles single or complex items within a second."
"The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The speed is great and the architecture is excellent."
"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 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 solution integrates well with Power BI."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The performance and scalability are awesome."
"It is a stable and scalable solution."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"A very good integration feature that restricts access to unauthorized people."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"We'd like the solution to have more analytics capability."
"It could be more stable."
"The solution does not support oriented scaling in the synapse."
"The product needs a tool that allows for work from a laptop instead of a browser."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"Comes with a pretty steep learning curve."
"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."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"Ease of connectivity could be improved."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"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."
"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."
"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 solution lacks visibility options."
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.