<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
21 Ratings
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Oracle Autonomous Data Warehouse

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
21 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)

It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards
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)

  • It is very cost-effective
  • Development time needed was much less in comparison to other systems
  • Played very nicely with our ETL and OLAP reporting tools
Samir Patel, PMP | 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)

  • Limited T-SQL query library
  • It is not suitable for OLTP environment
  • Doesn't support cross-database queries
Prabhu Sundararaj | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

  • Oracle ADW should definitely improve in terms of cumbersome connectivity with third-party tools like ODI Marketplace.
  • Oracle Data Sync that is used to load data into ADW does not work if we have single sign-on enabled.
  • ADW can also be priced on a subscription basis instead of universal credits. This way customers need not be hooked all the time concerned about overages but use the tool to its full capacity.
Anonymous | TrustRadius Reviewer

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) 8.0
Based on 1 answer
It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.
Prabhu Sundararaj | 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) 8.1
Based on 3 answers
I like their Support team
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)

SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data
Anonymous | TrustRadius Reviewer

Oracle Autonomous Data Warehouse

Patching with Oracle Autonomous Warehouse is a breeze. With Teradata patching is a pain. Also Oracle Autonomous Warehouse is more cheaper than Teradata warehouse. Flexibility is another major factor for anyone considering Oracle Autonomous Warehouse. Extract Transform and Load process is also lot faster with Oracle Autonomous Warehouse. I have 5 stats to Oracle Autonomous Warehouse.
Anonymous | TrustRadius Reviewer

Return on Investment

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • We have had an improvement in our overall processing time
  • Cost was much lower than most of its competitors
  • Our reporting needs have grown and housing the data here has been great
Samir Patel, PMP | 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)

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

Oracle Autonomous Data Warehouse

General

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

Add comparison