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."Data can be stored any way you want in the data warehouse."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"Technical support is okay in terms of the help they provide."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"It's user-friendly and has a good dashboard."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"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 very stable tool...It is an extremely scalable tool."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is a stable and scalable solution."
"The product is easy to use."
"A very good integration feature that restricts access to unauthorized people."
"The performance and scalability are awesome."
"The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"One area that could be improved is the schema management."
"Documentation could be improved."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"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."
"The installation process is complex. Oracle can make the installation process better."
"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."
"The initial setup was pretty complex. It was not easy."
"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 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.