32 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100
28 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Attribute Ratings

  • Azure Synapse Analytics (Azure SQL Data Warehouse) is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

8.8

Azure Synapse Analytics (Azure SQL Data Warehouse)

88%
8 Ratings
8.6

Oracle Autonomous Data Warehouse

86%
21 Ratings

Likelihood to Renew

Azure Synapse Analytics (Azure SQL Data Warehouse)

N/A
0 Ratings
8.0

Oracle Autonomous Data Warehouse

80%
1 Rating

Usability

9.5

Azure Synapse Analytics (Azure SQL Data Warehouse)

95%
2 Ratings

Oracle Autonomous Data Warehouse

N/A
0 Ratings

Support Rating

9.5

Azure Synapse Analytics (Azure SQL Data Warehouse)

95%
2 Ratings

Oracle Autonomous Data Warehouse

N/A
0 Ratings

Implementation Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

N/A
0 Ratings
9.0

Oracle Autonomous Data Warehouse

90%
1 Rating

Contract Terms and Pricing Model

10.0

Azure Synapse Analytics (Azure SQL Data Warehouse)

100%
1 Rating

Oracle Autonomous Data Warehouse

N/A
0 Ratings

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)

In terms of a well-suited scenario - the Azure Synapse can be used to capture data from multiple sources (especially from onPrem sources apart from Dataverse) and update the transformed data based on the given conditions (eg: refresh data based on the specified date/time ranges). Also, the transformed data can simply be transferred to Azure Data Lake for further processing by utilizing other analytics tools such as PowerBI.
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.
Anonymous | TrustRadius Reviewer

Pros

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
  • Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
  • Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

  • Very easy and fast to load data into the Oracle Autonomous Data Warehouse
  • Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
  • Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
  • It is always patched and always available and you can add storage dynamically as you need it.
Erik Dvergsnes | TrustRadius Reviewer

Cons

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
  • Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
  • Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

  • Level of integration or compatibility to connect it to different applications can be improved
  • The support service is slow
  • The issue is with the record number limitation of not being able to bring back more than one million records or not being able to export larger datasets to Excel
Anonymous | TrustRadius Reviewer

Pricing Details

Azure Synapse Analytics (Azure SQL Data Warehouse)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Starting Price

Oracle Autonomous Data Warehouse

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Starting Price

Likelihood to Renew

Azure Synapse Analytics (Azure SQL Data Warehouse)

No score
No answers yet
No answers on this topic

Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse 8.0
Based on 1 answer
Because
  • It is really simple to provision and configure.
  • Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
  • Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.
Lisandro Fernigrini | TrustRadius Reviewer

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
Based on 2 answers
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

No score
No answers yet
No answers on this topic

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
Based on 2 answers
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

No score
No answers yet
No answers on this topic

Implementation Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

No score
No answers yet
No answers on this topic

Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse 9.0
Based on 1 answer
Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.
Lisandro Fernigrini | TrustRadius Reviewer

Alternatives Considered

Azure Synapse Analytics (Azure SQL Data Warehouse)

We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.
Samir Patel, PMP | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it
Prashast Vaish | TrustRadius Reviewer

Contract Terms and Pricing Model

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 10.0
Based on 1 answer
Basically, the billing is predictable, and this all about it.
Vladimír Mužný | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

No score
No answers yet
No answers on this topic

Return on Investment

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Azure Synapse has predominately reduced the time being used for processing data being extracted from multiple sources
  • Ability to integrate multiple data sources and create a single dataset that could be used for further analytics to find KPIs
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

  • With OBIEE we had a limitation on the license, with OAC and Oracle Autonomous Data Warehouse, since it is pay-per-use services, it significantly reduced the cost.
  • the resource requirement was also on smaller side, as the maintenance activity primarily was done by the Oracle Autonomous Data Warehouse itself.
Anonymous | TrustRadius Reviewer

Screenshots

Azure Synapse Analytics (Azure SQL Data Warehouse)

Add comparison