25 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
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.3 out of 100

Likelihood to Recommend

Azure Cosmos DB

Cosmos DB is fast, reliable, and highly available. We use it mostly in analytics and applications that leverage big data hosted on the Azure Datacenter. If you have a virtual private cloud in one of Azure sites, then you would definitely need Cosmos. It works well with on-premises applications and offers little to no latency.
Anonymous | TrustRadius Reviewer

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

Feature Rating Comparison

NoSQL Databases

Azure Cosmos DB
7.8
Azure Synapse Analytics (Azure SQL Data Warehouse)
Performance
Azure Cosmos DB
7.9
Azure Synapse Analytics (Azure SQL Data Warehouse)
Availability
Azure Cosmos DB
8.8
Azure Synapse Analytics (Azure SQL Data Warehouse)
Concurrency
Azure Cosmos DB
7.0
Azure Synapse Analytics (Azure SQL Data Warehouse)
Security
Azure Cosmos DB
7.3
Azure Synapse Analytics (Azure SQL Data Warehouse)
Scalability
Azure Cosmos DB
8.7
Azure Synapse Analytics (Azure SQL Data Warehouse)
Data model flexibility
Azure Cosmos DB
7.0
Azure Synapse Analytics (Azure SQL Data Warehouse)
Deployment model flexibility
Azure Cosmos DB
7.5
Azure Synapse Analytics (Azure SQL Data Warehouse)

Pros

Azure Cosmos DB

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

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

Cons

Azure Cosmos DB

  • 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.
Lars Kemmann | TrustRadius Reviewer

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

Likelihood to Renew

Azure Cosmos DB

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.
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

No score
No answers yet
No answers on this topic

Usability

Azure Cosmos DB

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.
Anonymous | TrustRadius Reviewer

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

Support Rating

Azure Cosmos DB

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.
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 7.9
Based on 3 answers
I like their Support team
Anonymous | TrustRadius Reviewer

Alternatives Considered

Azure Cosmos DB

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.
Anonymous | TrustRadius Reviewer

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

Return on Investment

Azure Cosmos DB

  • 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.
Anonymous | TrustRadius Reviewer

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

Pricing Details

Azure Cosmos DB

General

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

Azure Synapse Analytics (Azure SQL Data Warehouse)

General

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

Rating Summary

Likelihood to Recommend

Azure Cosmos DB
7.7
Azure Synapse Analytics (Azure SQL Data Warehouse)
8.3

Likelihood to Renew

Azure Cosmos DB
8.0
Azure Synapse Analytics (Azure SQL Data Warehouse)

Usability

Azure Cosmos DB
8.0
Azure Synapse Analytics (Azure SQL Data Warehouse)
8.0

Support Rating

Azure Cosmos DB
10.0
Azure Synapse Analytics (Azure SQL Data Warehouse)
7.9

Add comparison