Azure Synapse Analytics (Azure SQL Data Warehouse)
15 Ratings
SAP HANA
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
390 Ratings

Azure Synapse Analytics (Azure SQL Data Warehouse)

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

Based on 15 reviews and ratings

SAP HANA

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
390 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Based on 390 reviews and ratings

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

Read full review

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

SAP HANA

SAP HANA is best suited for applications and analytics since it provides quick and reliable data management and extraction. Although SAP HANA is extremely useful and proven by its sophisticated and fast algorithms, it does take a significant amount of time and a great depth of knowledge to implement it.

Read full review

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

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

Read full review

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

SAP HANA

  • Multi Store Tables - allowing to store data in default store and extended store as per data ageing.
  • In Production Environment it allows same host deployments (Hana host + Dynamic Tiering). No need to have separate dedicated server for each of them.
  • Incremental and differential backups - Reducing backup times and storage requirements.

Read full review

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

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

Read full review

Prabhu Sundararaj | TrustRadius Reviewer
Prabhu Sundararaj
View all 4 answers on this topic

SAP HANA

  • Support - hard to find resources online so you are often dealing with an issue for a while.
  • UI could be more intuative, takes a while to get use to or train users.
  • Using a couple of models can make it not respond effectively.
  • Doesn't support text data type.

Read full review

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

Likelihood to Renew

Azure Synapse Analytics (Azure SQL Data Warehouse)

No score
No answers yet
No answers on this topic

SAP HANA

SAP HANA 4.0
Based on 6 answers
At this moment we are not focusing on SAP, however would love to in the future. This is primarily because of our limited ability to generate more revenue to fund for SAP partnerships and products. Our initial tryst with SAP Partneredge open ecosystem didn't go as planned and we have shelved that for now. Hope we can revive in the future

Read full review

Ganapathy Sivakumar | TrustRadius Reviewer
Ganapathy Sivakumar
View all 6 answers on this topic

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.

Read full review

Prabhu Sundararaj | TrustRadius Reviewer
Prabhu Sundararaj
View all 1 answers on this topic

SAP HANA

SAP HANA 7.5
Based on 9 answers
In addition to the points described in the previous parts of the review, I believe that as I gain more experience with the product over time, I will be able to better describe my experience with this tool. Meanwhile, I can confirm that the possibilities presented to my organization by the change to SAP HANA, at the moment, have been very important to evolve the analytical and strategic field towards a new path.

Read full review

Filippo Orlando | TrustRadius Reviewer
Filippo Orlando
View all 9 answers on this topic

Support Rating

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

Read full review

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

SAP HANA

SAP HANA 8.1
Based on 248 answers
SAP HANA is stable product now. However, we would be interested an even better and clearly defined roadmap. In terms of availability of technical resources with enough expertise to handle complex business challenges, SAP needs to take up the initiative of enabling partners and larger community. Better awareness around best practice content and tighter integration between SIs and product vendor is required.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 248 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

Read full review

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

SAP HANA

[Despite] of the high operational costs involved I can vouch for the fact the new [SAP] HANA cloud solution is by far worth it as they have included a significant amount of machine learning features, introduced a new computational algorithm a more improved ui and also the general security and robust performance on offer.

Read full review

Issac Paul | TrustRadius Reviewer
Issac Paul
View all 187 answers on this topic

Scalability

Azure Synapse Analytics (Azure SQL Data Warehouse)

No score
No answers yet
No answers on this topic

SAP HANA

SAP HANA 4.5
Based on 1 answer
Limitation of training deliverable by organization

Read full review

Shoaib Ansari | TrustRadius Reviewer
Shoaib Ansari
View all 1 answers on this topic

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

Read full review

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

SAP HANA

  • The [strategies] and the time consumed on migrating to HANA was time [consuming] and costly during the initial phases of the project.
  • The time and resources utilized to set up the infra plan from requirements to production was huge.
  • But once we were getting into cadence of utilizing the open architecture of HANA we were able to utilize its features that helped us to leverage.
  • Again I would say that overall for us HANA [has] proved to be worth spending for as it helped us achieve our business's objectives.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 187 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

SAP HANA

General

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

Add comparison