Try our new research platform with insights from 80,000+ expert users

Microsoft Azure Synapse Analytics vs OpenText Analytics Database (Vertica) vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.4
Users achieve ROI with Azure Synapse through cost savings, flexibility, and efficiency, often preferring it over Teradata.
Sentiment score
6.9
Users report significant ROI from OpenText Analytics Database due to enhanced analytics, performance, and data accessibility, despite its cost.
Sentiment score
6.3
Oracle Exadata offers early break-even, reduced costs, increased performance, and significant savings despite complex licensing challenges.
Some of my customers have indeed seen a return on investment with Microsoft Azure Synapse Analytics as they used it for analytics to drive decision-making, improving their processes or increasing revenue.
The investment is good, which is why people choose this hardware.
 

Customer Service

Sentiment score
6.6
Azure Synapse Analytics support is praised for responsiveness but criticized for expertise and slow response, especially for smaller clients.
Sentiment score
7.0
OpenText Analytics Database customer service is praised for knowledgeable support, though some users report slow response and escalation needs.
Sentiment score
6.5
Oracle Exadata support praised for expertise, but critiques focus on delays and process efficiency improvement needs.
They are slow to respond and not very knowledgeable.
This is an underestimation of the real impact because we use big data also to monitor the network and the customer.
I would rate the support for Microsoft Azure Synapse Analytics as an eight out of ten.
Exadata comes with a platinum gateway and comprehensive support, which often gets immediate attention with severity one cases.
This involved creating blueprints for integrating Oracle products into client systems, followed by technical presentations to Oracle teams and stakeholders.
 

Scalability Issues

Sentiment score
7.5
Microsoft Azure Synapse Analytics excels in scalability and flexibility, efficiently supporting diverse data activities despite high costs.
Sentiment score
7.1
OpenText Analytics Database (Vertica) excels at scaling large data volumes but faces challenges with schema modifications and node additions.
Sentiment score
7.5
Oracle Exadata offers efficient scalability with flexible configurations, easy expansion, and high costs; ensure compatible hardware generations.
Microsoft Azure Synapse Analytics is scalable, offering numerous opportunities for scalability.
For the scalability of Microsoft Azure Synapse Analytics, I would rate it a 10 until you remain in the Azure Cloud scalability framework.
Recovering from such scenarios becomes a bit problematic or time-consuming.
Within a site, scalability is excellent.
 

Stability Issues

Sentiment score
7.5
Microsoft Azure Synapse Analytics is stable and reliable, with minor performance concerns and high user satisfaction ratings for workload handling.
Sentiment score
7.1
OpenText Analytics Database (Vertica) is stable and robust, with minor query and network issues noted by users.
Sentiment score
7.8
Oracle Exadata is praised for reliability and stability, with improved models offering redundancy and high availability, minimizing downtime.
I find the service stable as I have not encountered many issues.
We have never integrated Microsoft Azure Synapse Analytics with Databricks, but we have mostly pulled data from on-premises systems into Azure Databricks.
Once installed, Exadata is very stable.
 

Room For Improvement

Azure Synapse Analytics could improve cost, integration, documentation, interface complexity, monitoring, data governance, connectivity, and scalability.
OpenText Analytics Database needs better workload management, documentation, SQL optimization, cloud support, machine learning, and cost efficiency.
Oracle Exadata needs cost management, simplified patching, improved support, better customization, enhanced security, and third-party integration.
There is a need for better documentation, particularly for customized tasks with Microsoft Azure Synapse Analytics.
Databricks is a very rich solution, with numerous open sources and capabilities in terms of extract, transform, load, database query, and so forth.
The reasons I don't rate Microsoft Azure Synapse Analytics higher include data integration and tech support being two main issues.
I cannot create an extended rack cluster with one node on one site and another node on a different site.
There are minor areas where improvement is needed, such as making the user interface more user-friendly and enhancing configuration and customization options.
 

Setup Cost

Microsoft Azure Synapse Analytics provides flexible pricing based on usage, offering cost benefits for companies within Microsoft's ecosystem.
OpenText Analytics Database offers flexible pricing based on storage, with competitive costs, community edition, and negotiable licensing options.
Oracle Exadata's high costs are justified by its performance and reliability, offering value through reduced operational expenses.
The cheapest tier costs about $4,000 to $4,700 a year, while the most expensive tier can reach up to $300,000 a year.
I think the price of Microsoft Azure Synapse Analytics is very expensive, but that's not only for Microsoft Azure Synapse Analytics—it's for the cloud in general.
I find the pricing of Microsoft Azure Synapse Analytics reasonable.
I would rate the price an eight on a scale from one to ten, indicating it is fairly expensive.
 

Valuable Features

Microsoft Azure Synapse Analytics provides scalability, integration, security, and real-time insights with efficient data handling and powerful analytics capabilities.
OpenText Analytics Database offers rapid data processing, scalability, ease of use, and cost efficiency with advanced analytics capabilities.
Oracle Exadata enhances performance, handles large databases efficiently, and simplifies management with advanced features and intelligent storage capabilities.
One of the most valuable features in Microsoft Azure Synapse Analytics is the ability to write your own ETL code using Azure Data Factory, which is a component within Synapse.
Microsoft Azure Synapse Analytics offers significant visibility, which helps us understand our usage more clearly.
For Microsoft Azure Synapse Analytics, the integration is the most valuable feature, meaning that whatever you need is fast and easy to use.
It also offers high backend speed between self-storage units and servers, which is beneficial for processing.
The most valuable features of Oracle Exadata are its high availability and cluster environment.
 

Featured Reviews

Joy Maitra - PeerSpot reviewer
Has supported data pipeline development but still requires better integration and support
The best feature of Microsoft Azure Synapse Analytics is the notebook functionality; it provides a very good interface, and we can easily do our experiments, POCs, and check things before migration or deployment to higher environments such as from development to SIT and then production. The deployment process is also much smoother. Driving data-driven insights in my organization depends upon the preparation of the data. If your data is not good, then insights won't be good, and Microsoft Azure Synapse Analytics helps in preparing your data, so it is very helpful. I find Microsoft Azure Synapse Analytics' native data lake support beneficial.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…
Ahmed-Yehia - PeerSpot reviewer
Exceptional database performance with high availability and good reliability
The major use of Exadata is for running databases, big databases, and also for backing them up. It provides high availability and high performance specifically for databases, and not for applications, just Oracle databases High availability and high performance are very valuable aspects of the…
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
869,089 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
12%
Financial Services Firm
8%
Computer Software Company
8%
Government
6%
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
8%
Comms Service Provider
5%
Financial Services Firm
31%
Computer Software Company
10%
Government
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise18
Large Enterprise55
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
By reviewers
Company SizeCount
Small Business47
Midsize Enterprise13
Large Enterprise86
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very str...
What do you like most about Microsoft Azure Synapse Analytics?
The product is easy to use, and anybody can easily migrate to advanced DB.
What is your experience regarding pricing and costs for Microsoft Azure Synapse Analytics?
I find the pricing of Microsoft Azure Synapse Analytics reasonable; compared to AWS Glue or Databricks, it is reasona...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compet...
What do you like most about Oracle Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The cost of Oracle Exadata is substantial, particularly in terms of maintenance costs and licensing. This pricing str...
What needs improvement with Oracle Exadata?
Patching Oracle Exadata can be challenging due to its numerous components including network, blade, CPU, storage, and...
 

Also Known As

Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
No data available
 

Overview

 

Sample Customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: October 2025.
869,089 professionals have used our research since 2012.