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

Likelihood to Recommend

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

IBM Db2 Warehouse

DB2 is better suited for OLTP workloadsIt can get better for OLAP workloadsScaling is flexible, HA and DR options are also good.Admin will have controls to stop and start warehouse and spark clusters. Replication is another critical element.Stored Procedure is located in IDAX, some of the useful procs are Decision tree, K-mean clustering, linear regression, Naive Bayes, random sampling, regression tree. SQL's are supported, SQL statements are executed in the database manager
Sathish Palanivel(He/Him) | TrustRadius Reviewer

Pros

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

IBM Db2 Warehouse

  • ACID compliant
  • Good for transaction like work load
  • Suitable for continuous small amount of loads
Sathish Palanivel(He/Him) | TrustRadius Reviewer

Cons

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • The cost structure is difficult to understand
  • The job scheduling capabilities aren't easy to use
  • The logging metrics aren't easy to see
Scott Kennedy | TrustRadius Reviewer

IBM Db2 Warehouse

  • handling more volume use changes
  • concurrent users
Sathish Palanivel(He/Him) | TrustRadius Reviewer

Usability

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

IBM Db2 Warehouse

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) 7.4
Based on 3 answers
I am happy, the Azure team has strong customer support. They have an effective customer forum and weekly summits to encourage and establish their features and they support us in deep dives into the tool to utilize many benefits from it. They have 24/7 support and whenever we have issue they promptly resolve the tickets.
Prabhu Sundararaj | TrustRadius Reviewer

IBM Db2 Warehouse

No score
No answers yet
No answers on this topic

Alternatives Considered

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

IBM Db2 Warehouse

Db2 Warehouse provided more flexibility than another tool in the market for a hybrid solution. The ability to integrate with Oracle also was one of the useful features for our business case.
Sathish Palanivel(He/Him) | TrustRadius Reviewer

Return on Investment

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

IBM Db2 Warehouse

No answers on this topic

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

IBM Db2 Warehouse

General

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

Add comparison