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."We've had a good experience with technical support in general."
"Data can be stored any way you want in the data warehouse."
"Synapse Analytics gives you information and reports in real-time."
"The useability, the user interface, is very user-friendly."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"The analytics have been very good. We've found them to be quite useful."
"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."
"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."
"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."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"The solution does not support oriented scaling in the synapse."
"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."
"There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
"The initial setup has a bit of a learning curve."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"Comes with a pretty steep learning curve."
"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."
"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 is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"Ease of connectivity could be improved."
"They should make the solution more user-friendly."
"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 installation process is complex. Oracle can make the installation process better."
"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.