Azure Cosmos DB vs Azure Synapse Analytics (Azure SQL Data Warehouse) | TrustRadius

What users are saying about

Score 8.2 out of 10

Based on 25 reviews and ratings

Score 8.3 out of 10

Based on 15 reviews and ratings

Feature Rating Comparison

Azure Cosmos DB

Azure Synapse Analytics (Azure SQL Data Warehouse)

Performance

Availability

Concurrency

Security

Scalability

Data model flexibility

Deployment model flexibility

Pros

Injects unstructured data at a very high speed.
No real need for administrative work, it indexes everything on it's own.

Read full review

Verified User

Employee in Information Technology

Financial Services Company, 1001-5000 employees

View all 5 answers on this topic

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

Read full review

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 4 answers on this topic

Cons

Cosmos DB can be very expensive if you're using it for scenarios that are better completed in regular old Azure Table Storage or Blob Storage, specifically if you put some thought into your partitioning schemes. No product is a good substitute for thoughtful system design.
It would be helpful if I had some more insight into how many resources (DTUs) an individual query uses.
The auto-indexing is great, but a little mysterious -- not usually an issue but it does require some intentional thought.

Read full review

Solutions Architect

Netrix, LLCInformation Technology and Services, 201-500 employees

View all 5 answers on this topic

Limited T-SQL query library
It is not suitable for OLTP environment
Doesn't support cross-database queries

Read full review

Prabhu Sundararaj

Associate - Project

CognizantInformation Technology & Services, 10,001+ employees

View all 4 answers on this topic

Likelihood to Renew

Azure Cosmos DB 8.0

Based on 4 answers

The total cost of ownership is much higher than anticipated. The documentation for their API calls is still not complete. TCO did go up as a result as well. Having users learning another JQL-like language also added more complexity to it. Support of ANSI-SQL would be ideal. But the cost of managing it is much less compared to Redis, Mongo, or Cassandra.

Read full review

Verified User

Engineer in Engineering

Biotechnology Company, 11-50 employees

View all 4 answers on this topic

No score

No answers yet

No answers on this topic

Usability

Azure Cosmos DB 8.0

Based on 1 answer

Like I said, Cosmos is the way to go. From all of the services that Azure has, Cosmos is very robust in terms of usability. It's ever-evolving and integrates with other applications seamlessly. The interface is pretty easy to understand. I implemented various solutions for my company and Cosmos was one of them.

Read full review

Verified User

Project Manager in Information Technology

Pharmaceuticals Company, 10,001+ employees

View all 1 answers on this topic

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.

Read full review

Prabhu Sundararaj

Associate - Project

CognizantInformation Technology & Services, 10,001+ employees

View all 1 answers on this topic

Support Rating

Azure Cosmos DB 10.0

Based on 1 answer

Microsoft is the best when it comes to after-sales support. They have a well-structured training and knowledge base portal that anyone can use. They are usually quick to respond to cases and are on point for on-call support. I have no complaints from a support standpoint. Pretty happy with the support.

Read full review

Verified User

Project Manager in Information Technology

Pharmaceuticals Company, 10,001+ employees

View all 1 answers on this topic

Azure Synapse Analytics (Azure SQL Data Warehouse) 7.9

Based on 3 answers

I like their Support team

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 3 answers on this topic

Alternatives Considered

Azure Cosmos DB is a fully managed NoSQL database & globally distributed NoSQL database service. Its very fast and predictable performance, high availability, elastic scaling, global distribution, and ease of development DB platform compare to MongoDB.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 1001-5000 employees

View all 5 answers on this topic

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

Read full review

Verified User

Contributor in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 4 answers on this topic

Return on Investment

Azure Cosmos DB may be expensive on its own, but it was cheaper than increasing the size/power of our VMs running SQL Server instances enough to keep up with the volume and velocity of the unstructured data.
We got the JSON data out of our SQL Servers and they quit tipping over.

Read full review

Verified User

Employee in Information Technology

Financial Services Company, 1001-5000 employees

View all 5 answers on this topic

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

Read full review

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 4 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Rating Summary

Azure Cosmos DB

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Cosmos DB

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Cosmos DB

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Cosmos DB

Azure Synapse Analytics (Azure SQL Data Warehouse)

Add comparison