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."It's scalable; you can scale up and scale down."
"Technical support is okay in terms of the help they provide."
"The speed is great and the architecture is excellent."
"We've had a good experience with technical support in general."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"The most advantageous aspect of Microsoft Azure Synapse Analytics is its simplified data transformation process compared to traditional databases. This makes data cleansing and transformation more manageable and straightforward, which we appreciate. It is much easier to build as well."
"The initial setup was really easy and straightforward."
"Data can be stored any way you want in the data warehouse."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The solution integrates well with Power BI."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The analytics have been very good. We've found them to be quite useful."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"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."
"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."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"The product could be more feature-rich."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"I would like to see version control implemented into the data warehouse."
"The need to improve a little bit in terms of user-friendliness."
"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."
"If I'm looking for something good in the cloud, I would want it to have better standard connectors."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"The solution lacks visibility options."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"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."
"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."
"A lot of the tools that were previously there have now been taken away."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"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."
"Ease of connectivity could be improved."
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.