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

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

Denodo

Donodo is very well suited for large organizations with siloed datasets. Denodo thrives in these environments, since large organizations can afford the licensing costs, and are always tasked to mash up data from multiple environments throughout the organization.
Anonymous | 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

Denodo

  • Flat learning curve.
  • Does not need brilliant developers.
  • Less need for custom denodo wrappers, even if needed is not very complex.
  • Denodo stored procedures and functions helped address complex, not straightforward requirements.
  • Export/import deployment between environments was very helpful.
Karthick Subharaj Rajarathinam | TrustRadius Reviewer

Cons

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

Denodo

  • Lack of Documentation and user community: Denodo continues to have a small community of super users, therefore there is not a lot of documentation out there in the event you get stuck.
  • Cost: Data virtualization isn't cheap, so smaller organizations might shy away from this technology due to the high licensing costs.
  • Caching strategy: Some slower datasets will require caching... which argues, why not just do traditional ETL if you need to do this?
Anonymous | 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

Denodo

Denodo 8.0
Based on 1 answer
Denodo is very easy to use. It has a user-friendly drag and drop interface. I'm not a fan of the java platform it resides on.
Anonymous | TrustRadius Reviewer

Performance

Azure Synapse Analytics (Azure SQL Data Warehouse)

No score
No answers yet
No answers on this topic

Denodo

Denodo 8.0
Based on 2 answers
Denodo is a tool to rapidly mash data sources together and create meaningful datasets. It does have its downfalls though. When you create larger, more complex datasets, you will most likely need to cache your datasets, regardless of how proper your joins are set up. Since DV takes data from multiple environments, you are taxing the corporate network, so you need to be conscious of how much data you are sending through the network and truly understand how and when to join datasets due to this.
Anonymous | TrustRadius Reviewer

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

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

Denodo

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

Denodo

I did not use any other data virtualization platform. BizTalk is not the right comparison; it is an integration layer and for orchestration; do not use denodo as an orchestration layer, it is not for connecting upstreams to downstreams and orchestrate data flows, it is primarily for pulling information and presenting in a fashion that benefit the audience
Karthick Subharaj Rajarathinam | 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

Denodo

  • Improved time-to-market. We addressed new requirements in less than 2 person days.
  • Very agile. Easy to handle changing requirements. Like a new requirement, a change in requirement was not expensive either.
  • Platform issues were difficult to diagnose and debug.
Karthick Subharaj Rajarathinam | TrustRadius Reviewer

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

Denodo

General

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

Add comparison