What users are saying about
35 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
Based on 35 reviews and ratings
186 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>Score 9.1 out of 100
Based on 186 reviews and ratings
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.7
Oracle Exadata
87%
20 Ratings
Usability
9.5
Azure Synapse Analytics (Azure SQL Data Warehouse)
95%
2 Ratings
Oracle Exadata
N/A
0 Ratings
Support Rating
9.5
Azure Synapse Analytics (Azure SQL Data Warehouse)
95%
2 Ratings
Oracle Exadata
N/A
0 Ratings
Contract Terms and Pricing Model
10.0
Azure Synapse Analytics (Azure SQL Data Warehouse)
100%
1 Rating
Oracle Exadata
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.

Verified User
Professional in Information Technology
Government Administration Company, 501-1000 employeesOracle Exadata
- First, get the database on Oracle. If you are in an Oracle stack, it would be much better to use the Oracle products. If you are driving a Ferrari, you wouldn’t put a Mercedes engine in it. If you are writing a query, you cannot rely on other brands. Since I'm an architect, when I look for a product, I look for performance.
- The installation is easy because it comes out-of-the-box and you just start using it.
- Previous to Oracle Exadata, we were using a normal Oracle RAC service. We were just waiting for this product to come out.
- I'm currently writing a data warehouse on Exadata. Before this solution, we were aiming for this to be completed by 8 a.m., when our ETLs would finish. With the help of Exadata's special features, this was reduced to 3 a.m. This solution allows us to bring more data within the same time period. It provides us with more subject areas that provide more reports to our users. Our ETL times reduced to 65%, then to 50%.
Data WareHouse Architect
Ekol LogisticsTelecommunications, 10,001+ employees
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.

Verified User
Contributor in Information Technology
Information Technology and Services Company, 10,001+ employeesOracle Exadata
- Customize-able for specific functionality optimized for combination of online transaction or analytical processing.
- Ability to serve mix workloads with resource management feature enables prioritizing allocation for certain workload.
- Scale-able on-premise with compatibility for cloud deployment offers flexible solution for organization considering to transition from on-premise solution.

Verified User
Professional in Information Technology
Telecommunications Company, 1001-5000 employeesCons
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.

Verified User
Consultant in Information Technology
Information Technology & Services Company, 51-200 employeesOracle Exadata
- Patching can often become quite involved and convoluted. It should be more transparent and straightforward.
- Storage metrics can be difficult and time consuming to obtain.
- Basic administrative functions can be hard to repair when discovered.
- Vendor support can take a while to obtain. Generally several attempts are necessary to reach the right area of vendor expertise.
DBA
Duquesne Light CompanyUtilities, 1001-5000 employees
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
—Azure Synapse Analytics (Azure SQL Data Warehouse) Editions & Modules
—
Additional Pricing Details
—Oracle Exadata
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Starting Price
$2.9,032 Per Unit
Oracle Exadata Editions & Modules
Edition
Quarter Rack | $14.51621 |
---|---|
Database Server | $2.90321 |
- Per Unit
Additional Pricing Details
—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.

Verified User
Consultant in Professional Services
Computer Software Company, 201-500 employeesOracle Exadata
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.

Verified User
Consultant in Professional Services
Computer Software Company, 201-500 employeesOracle Exadata
No score
No answers yet
No answers on this topic
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.
SQL Development Team Lead
Allianz Asset ManagementInvestment Management, 1001-5000 employees
Oracle Exadata
Oracle Exadata Database Machine had the best performance overall hands down. It clearly beat the competition and we were seeing 1000X improvement on SAP HANA. Oracle Exadata Database Machine beat that without us refactoring our code. To achieve that in HANA, we had to refactor the code somewhat. Now this was for our limited POC of 5 use cases. Given the large number of stored procedures we had in Sybase, we need to capture more production metrics but we are seeing incredible performance.
Vice President, Chief Architect, Development Manager and Software Engineer
WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees
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.
Owner, Developer
DROPMAN s.r.o.Computer Software, 1-10 employees
Oracle Exadata
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

Verified User
Professional in Information Technology
Government Administration Company, 501-1000 employeesOracle Exadata
- Single support from a single vendor with both machine and database from Oracle, which is costing us less.
- With Exadata, we need less technical manpower and less technical support. A business transaction with the integrated and centralized database helps us focus on other business needs.
- We don't need to buy additional licenses and Hardware for the next 3 to 5 years.
Sr. Product Manager/Consultant for Software Technologies and Infrastructure
Jeraisy Computer & Comm. ServicesComputer & Network Security, 5001-10,000 employees