Azure Cosmos DB
36 Ratings
Azure Synapse Analytics (Azure SQL Data Warehouse)
36 Ratings

Azure Cosmos DB

36 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 36 reviews and ratings

Azure Synapse Analytics (Azure SQL Data Warehouse)

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

Based on 36 reviews and ratings

Feature Set Ratings

    NoSQL Databases

    8.6

    Azure Cosmos DB

    86%

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    Azure Cosmos DB ranks higher in 7/7 features
    Azure Cosmos DB ranks higher in 7/7 features

    Performance

    8.2
    82%
    6 Ratings
    N/A
    0 Ratings

    Availability

    9.5
    95%
    6 Ratings
    N/A
    0 Ratings

    Concurrency

    8.1
    81%
    6 Ratings
    N/A
    0 Ratings

    Security

    9.4
    94%
    6 Ratings
    N/A
    0 Ratings

    Scalability

    8.6
    86%
    6 Ratings
    N/A
    0 Ratings

    Data model flexibility

    8.1
    81%
    6 Ratings
    N/A
    0 Ratings

    Deployment model flexibility

    8.5
    85%
    6 Ratings
    N/A
    0 Ratings

    Attribute Ratings

    • Azure Synapse Analytics (Azure SQL Data Warehouse) is rated higher in 3 areas: Likelihood to Recommend, Usability, Support Rating

    Likelihood to Recommend

    8.3

    Azure Cosmos DB

    83%
    6 Ratings
    8.8

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    88%
    8 Ratings

    Likelihood to Renew

    7.7

    Azure Cosmos DB

    77%
    4 Ratings

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    N/A
    0 Ratings

    Usability

    8.6

    Azure Cosmos DB

    86%
    2 Ratings
    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings

    Support Rating

    9.4

    Azure Cosmos DB

    94%
    2 Ratings
    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings

    Contract Terms and Pricing Model

    Azure Cosmos DB

    N/A
    0 Ratings
    10.0

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    100%
    1 Rating

    Likelihood to Recommend

    Azure Cosmos DB

    NoSQL platforms are very useful when it comes to security, speed, accuracy, high accessibility with high read and write power. Everything is managed under the cloud and we have the various capabilities of Azure and support for Microsoft products with us. Flexibility in price and variety of features, as well as real-time results, are some of the popular [features] of this platform.

    Read full review

    Niloofar Keshvari Nia | TrustRadius Reviewer
    Niloofar Keshvari Nia
    View all 6 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Pros

    Azure Cosmos DB

    • Turn-key geo-redundancy with multi-master writes is unprecedented and unparalleled in the industry!
    • Guaranteed low latency makes Cosmos DB an excellent fit for most of our performance-intensive situations.
    • The tunable consistency model simplifies so many challenges in distributed systems engineering that otherwise require advanced knowledge of computer science topics. I continue to be impressed at how Cosmos DB has abstracted away so much complexity.

    Read full review

    Lars Kemmann | TrustRadius Reviewer
    Lars Kemmann
    View all 6 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Cons

    Azure Cosmos DB

    • Expensive, so be careful of the use case.
    • We had a thought time migrating from traditional DBs to Cosmos. Azure should provide a seamless platform for the migration of data from on-premises to cloud.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 6 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Pricing Details

    Azure Cosmos DB

    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)

    General

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

    Starting Price

    —

    Likelihood to Renew

    Azure Cosmos DB

    Azure Cosmos DB 7.7
    Based on 4 answers
    It's efficient, easy to scale, and works. We do have to do a bit of administration, but less now than when we started with this a couple of years ago. Microsoft continues to improve its self-management capability.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 4 answers on this topic

    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.6
    Based on 2 answers
    It has very good compatibility and adaptability with other APIs and developers can safely create new apps because it is compatible with various tools and can be easily managed and run under the cloud, and in terms of security, it is one of the best of its kind, which is very powerful and excellent.

    Read full review

    Niloofar Keshvari Nia | TrustRadius Reviewer
    Niloofar Keshvari Nia
    View all 2 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    Support Rating

    Azure Cosmos DB

    Azure Cosmos DB 9.4
    Based on 2 answers
    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

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    Alternatives Considered

    Azure Cosmos DB

    Azure Cosmos DB has the benefit of having multi-master key tenancy compared to Redis and Mongo. Reads are just as fast, if not faster than Mongo. However, the distribution of writes (i.e. ACID transactions) isn't as high as Google Cloud Spanner or CouchDB. Azure Cosmos DB writes slower than Cassandra, but with Cosmos, we do not have to worry about replication or tools like Zookeeper to handle it. Azure Cosmos DB has it built-in.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 6 answers on this topic

    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.

    Read full review

    Samir Patel, PMP | TrustRadius Reviewer
    Samir Patel, PMP
    View all 8 answers on this topic

    Contract Terms and Pricing Model

    Azure Cosmos DB

    No score
    No answers yet
    No answers on this topic

    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.

    Read full review

    Vladimír Mužný | TrustRadius Reviewer
    Vladimír Mužný
    View all 1 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 6 answers on this topic

    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

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Add comparison