What users are saying about

Amazon Aurora

42 Ratings

SAP HANA

92 Ratings

Amazon Aurora

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

SAP HANA

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

Add comparison

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

SAP HANA

It's best suited for SAP ERP clients and not so much for non-SAP ERP. There is quite a bit of a learning curve on the data modeling side in HANA. Traditional data modeling concepts should be rethought. If the model is not done right it can easily nullify all the performance benefit you are expecting from the product.
No photo available

Pros

  • Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
  • Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
  • Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
Vasco Mendes profile photo
  • Optimized profitability
  • Operational Reporting
  • Real Time Inventory Management
  • Sales Analsysis
  • Profitability
No photo available

Cons

  • The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
  • Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
  • Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
Vasco Mendes profile photo
  • I have heard, HANA is costly - both hardware & software license.
  • Hard to find skilled resources. (This might not be valid in near future)
  • Database has specific hardware requirement. So just running installation doesn't work. (not a big Cons)
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
SAP HANA7.7
Based on 3 answers
We will renew indefinitely until the product's end of life.
No photo available

Alternatives Considered

Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.As it relies on MySQL there is no extra formation for a team that is already used to a MySQL solution.
Vasco Mendes profile photo
Client uses SAP as their ERP solution. HANA being a product from SAP & their need for processing huge data with best performance was key factor. Also last few year's success stories & good reviews of HANA database was also driving factor in their selection. Client sees big data capabilities of HANA for Real-time advance analytics
No photo available

Return on Investment

  • The main positive for my team is the time that has been freed up from the tasks of managing updates and fixing replication issues.
  • A negative for myself as a database administrator is removal of features that were available in Mysql. Examples include 1) the use of the storage engines other than InnoDB (such as the Federated Storage Engine), 2) certain administrative privileges such as ability to export to csv file and easy ability to kill processes. I seem to also forget they removed the built-in kill ability and you must use their own provided kill functionality.
No photo available
  • Client sees mostly positive impact for retrieving & processing their historical data within their supply chain business.
  • Positive impact on their reporting needs. They use to run overnight batch jobs to fetch data & calculate reports, which happens in minutes with use of SAP HANA database.
  • Best performance on real-time APIs with many calls in parallel.
No photo available

Pricing Details

Amazon Aurora

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

Amazon Aurora More Information

SAP HANA

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

SAP HANA More Information