What users are saying about
44 Ratings
96 Ratings
44 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
96 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Add comparison

Likelihood to Recommend

Amazon Aurora

Amazon Aurora (as is MySQL) is better suited for light to medium applications considering it still has some performance limitations from MySQL. I would not recommend it for enterprise level use without a carefully constructed backend system (code and database). My company's current backend architecture was not mapped out very well and this leads to performance problems that even Amazon Aurora has not been able to completely sort (although it has been a huge help). Another area where I am finding it beginning to lack is for use in data warehousing. The more rows added, the less performant I'm finding the data warehouse. Although to be fair, Amazon has another product (Redshift) that we are looking to migrate data warehouses into.
No photo available

SAP HANA

We had such a scenario where HANA is very well suited, as we had a customer with a very huge DB size in few TBs, which was really challenging to use with business need and availability, even if it had been compressed. HANA made it possible to compress and put it in memory to use in a more sophisticated and faster way for the customer as a result.
It's definitely not well suited for small-scale customers where there is no need for real-time super performance, and not many critical activities.
Pradeep Bele profile photo

Pros

  • Automated maintenance for upgrades is by far the most superior feature of Amazon Aurora. Never be behind on upgrades again!
  • Performance improvements for poorly structured schema due to enhancements added by Amazon.
  • Replication works flawlessly due to added security measures added into Amazon Aurora which prevents admin users from "accidentally" breaking the slave instance.
  • Amazon Aurora is hosted on Amazon's RDBMS which also includes quick and easy setup of new database instances.
No photo available
  • Real-time OLAP queries on transactional data.
  • Integrated application layer (XS/XSA).
  • RServe support
No photo available

Cons

  • I'd like to see Amazon Aurora get ahead of the curve on MySQL and introduce their own improvements to MySQL to make it a superior database so that I don't need to use SQL Server or Oracle to get performance improvements. For example, improve performance of views.
  • Amazon Aurora needs to improve the ability to restore backups as needed. Currently, the user can only restore an entire instance to a new or existing RDBMS instance. If you need to retrieve data from a single table, this can be tedious after waiting hours for an entire restore to complete. Instead, allow the user to select a database to restore. Better yet, allow the user to restore a database backup to ANOTHER database - which would allow you to restore a database on the same instance.
  • Again beat MySQL to the punch and introduce REAL server to server communication since they have disabled the "Federated Engine" which was the only way previously to do this. I'd like to be able to setup MySQL instances to talk to other MySQL instances.
No photo available
  • Maybe ability to incorporate more 3rd party platforms
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
SAP HANA7.7
Based on 3 answers
SAP HANA product meets our needs.
No photo available

Alternatives Considered

In the end, we went with Amazon Aurora due to the decent performance and cost. Cost was determined in two ways for us: 1) no additional license is required (such as using SQL Server or Oracle) and 2) the ability to cut down on needed resources to maintain the system from the maintenance perspective due to the built-in maintenance capabilities. Amazon Aurora is also based on MySQL (soon to include PostgreSQL ) which allowed my team to quickly and easily move our existing MySQL servers to a faster system.
No photo available
SAP HANA is much more intuitive and user-friendly than SQL and Python. This makes sense because it is a commercial application whereas SQL and Python are not. SpotFire has some advantages over SAP HANA in that it has a lot of built-in visualization capability, however, it cannot handle and store large amounts of data in the same way.
David Schuster profile photo

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
  • Faster Decision making
  • TCO on IT reduced by 70%
  • Increased Data Analysis
  • Brought Business closer to real time data
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