SAP HANA and Amazon Aurora compete in the enterprise database management systems category. Based on the data, SAP HANA has an edge in business process automation, making it more attractive for large enterprises, while Amazon Aurora excels in scalability and seamless integration with AWS services.
Features: SAP HANA offers robust integration with third-party tools, in-memory computing for fast data processing, and a stable, feature-rich environment suitable for large enterprises. Amazon Aurora provides scalable, high-performance features with SQL standardization and auto-scaling, seamless AWS services integration, and superior replication capabilities.
Room for Improvement: SAP HANA could improve in pricing flexibility, integration capabilities, and support for unstructured data. It faces challenges with cost and complexity of deployment. Amazon Aurora users suggest better pricing strategies, enhanced developer focus, and improvements in cryptography and migration processes.
Ease of Deployment and Customer Service: SAP HANA offers deployment models such as On-premises, Hybrid, and Private Cloud, although deployment can be complex, with inconsistent support. Amazon Aurora, primarily in the Public Cloud, is recognized for straightforward deployments and reliable support, emphasizing its cloud deployment efficiency.
Pricing and ROI: SAP HANA is costly, with high licensing fees, acknowledged mostly by large enterprises for its value, but prohibitive for smaller companies. The ROI is driven by efficient processing and comprehensive business solutions. Amazon Aurora offers cost-effective cloud pricing with a pay-as-you-go model and has room for price reduction, making it a cost-efficient option balancing performance and pricing.
Using Amazon Aurora has saved us significantly in terms of manpower costs, with nearly fifty percent savings compared to an on-premises solution.
We do not feel we're getting value for the investment due to the additional resources needed for integration and maintenance.
I have seen a return on investment with SAP HANA as it typically delivers measurable ROI, especially in finance and month-end close processes.
SAP HANA is a cost-saving solution that helps save money and serves as a time-saving solution that helps save time.
Technical support from Amazon is rated very highly.
The initial support could improve by having engineers familiarize themselves with the issue content to provide more specialized assistance from the start.
The community support is better than the official SAP support.
While issues are resolved eventually, the first level of support is not as good as we would like.
When we raise a ticket for AWS or Azure issues, we find their support is very proactive, while SAP's support is quite passive.
This scalability is critical as it allows for runtime expansion, which is essential for businesses moving from on-premises to the cloud.
SAP HANA handles large data volumes efficiently, allowing for adding more modules or users without performance issues.
Our operations have grown from a hundred data operations a day to as many in a couple of seconds.
It depends on what needs to change in the structure, as some entities cannot be changed and require a new implementation, while others can be modified.
It offers a stable environment, ensuring consistent performance.
We recently faced customer data loss during the cluster handover or failover fallback.
We have not had any problems in the last seven to eight years.
Regarding stability, they are using legacy systems and have implemented SAP HANA.
There are technical challenges, such as the inability to provision the database using a PostgreSQL snapshot directly.
Keeping extensions up-to-date with PostgreSQL releases would enhance Aurora's functionality.
I used the backup options in Amazon Aurora for cloning databases. It's very common.
The main issue is the ecosystem, which lacks the widespread support that SQL enjoys.
The setup process and deployment process for SAP HANA is complex.
Licensing costs with SAP HANA are very high.
The pricing is reasonable and not overly expensive.
Amazon Aurora is not very expensive as other solutions with similar features from other vendors come at almost the same cost.
The pricing for Amazon Aurora is different from DocumentDB because DocumentDB is cheaper.
It's a recurring subscription model, which is expensive compared to legacy systems with just a maintenance fee.
SAP is not a cheap company, and its licenses are expensive.
I would rate the price for SAP HANA as high.
Amazon Aurora offers a 99.9% SLA compared to PostgreSQL. This ensures a high level of availability for our applications.
It replicates data across multiple Availability Zones, ensuring high availability and geographical redundancy, which can be considered a GR instead of a DR.
This architecture allows for faster data processing and real-time analytics that were not possible with traditional databases.
The concept enhances speed, allowing the database to serve and move data quickly.
One of our dashboards using Excelsius was previously developed on normal BW on Oracle data, which took 10 minutes to open. After developing the same calculation views using those tables and replacing them with calculation views in Excelsius, the dashboard opened in seconds.
| Product | Market Share (%) |
|---|---|
| SAP HANA | 7.5% |
| Amazon Aurora | 3.0% |
| Other | 89.5% |
| Company Size | Count |
|---|---|
| Small Business | 5 |
| Midsize Enterprise | 4 |
| Large Enterprise | 13 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 62 |
Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.
Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.
Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance. It delivers high performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).
Visit the Amazon RDS Management Console to create your first Aurora database instance and start migrating your MySQL and PostgreSQL databases.
SAP HANA, also known as SAP High-performance Analytics Appliance, is a multi-model database that stores data in its memory, allowing users to avoid disk storage. The product combines its robust database with services for creating applications. SAP HANA is faster than other database management systems (DBMS) because it stores data in column-based tables in main memory and brings online analytical processing (OLAP) and online transaction processing (OLTP) together.
The column-oriented in-memory database design allows users to run high-speed transactions alongside advanced analytics, all in a single system. This provides companies with the ability to process very large amounts of data with low latency and query data in an instant. By combining multiple data management capabilities, the solution simplifies IT, helps businesses with innovations, and facilitates digital transformation.
The solution is structured into five groups of capabilities, categorized as:
There are three more SAP products that work alongside SAP HANA and complete the experience for users together. SAP S/4HANA Cloud is a ready-to-run cloud enterprise resource planning (ERP). SAP BW/4HANA is a packaged data warehouse, based on SAP HANA, which allows users to consolidate data across the enterprise to get a consistent view of their data. Finally, SAP Cloud is a single database as a service (DBaaS) foundation for modern applications and analytics across all enterprise data. All three products can combine with SAP HANA to deliver to users an optimized experience regarding their data.
SAP HANA Features
Each architectural group of capabilities of SAP HANA has various features that users can benefit from. These include:
SAP HANA Benefits
SAP HANA provides many benefits for its users. These include:
Reviews from Real Users
According to a database consultant at a pharma/biotech company, SAP HANA is a very robust solution with good data access.
Bruno V., owner at LAVORO AUTOM INF E COM LTDA, likes SAP HANA because the product offers advanced features, helps reduce hours, and makes it easy to find what you need.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
