<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
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

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

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

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.
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

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

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

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
Ganapathy Sivakumar | 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

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.
Filippo Orlando | TrustRadius Reviewer

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

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

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

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.
Issac Paul | TrustRadius Reviewer

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
Shoaib Ansari | 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

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

SAP HANA

General

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

Add comparison