SAP IQ and Amazon Aurora are strong contenders in the database solutions category. SAP IQ is often preferred for its query speed and data compression, while Aurora is noted for its ease of use and management capabilities.
Features: SAP IQ is recognized for its exceptional query speed, effective data compression, and columnar storage that enhances performance and space efficiency. Amazon Aurora stands out for its easy management, scalability, and seamless AWS integration, along with its automated backup and scaling features, which offer compatibility with MySQL and PostgreSQL.
Room for Improvement: SAP IQ users suggest enhancements in disaster recovery options, marketing efforts, and a reduction in high costs to increase awareness and utilization. Amazon Aurora faces challenges with its pricing structure, limited AI capabilities, and the need for better developer tools and options outside AWS environments, which users recommend addressing to broaden adoption.
Ease of Deployment and Customer Service: SAP IQ primarily supports on-premises deployments, which fits well with established IT infrastructures, though its customer service is often criticized for insufficient expertise and delayed responses. Amazon Aurora, being cloud-centric, offers flexibility with both public and private cloud deployment options and is praised for its highly rated customer support and global coverage.
Pricing and ROI: SAP IQ is seen as cost-effective in implementation and hardware savings, with complex licensing models that need careful enterprise consideration. Users find its setup costs lower than competitors like Teradata. In contrast, Amazon Aurora adopts a cloud-based usage model with competitive pricing billed on usage rather than licenses, balancing performance with favorable operational expenditures despite its higher costs than self-managed solutions.
Using Amazon Aurora has saved us significantly in terms of manpower costs, with nearly fifty percent savings compared to an on-premises solution.
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.
It seems very difficult to get proper advanced assistance on advanced or complicated problems.
The quality of support from SAP is very good; if it's a known problem, they will have a knowledge base, so we will get immediate assistance.
This scalability is critical as it allows for runtime expansion, which is essential for businesses moving from on-premises to the cloud.
We can span the read and write load into multiple nodes, and that scalability is there.
If we wanted to add more servers into this entire setup, that would be fairly easy, so it's rather good when it comes to scalability.
It offers a stable environment, ensuring consistent performance.
It's usually something external, such as lack of disk space or problems arising from the integration to other systems.
Keeping extensions up-to-date with PostgreSQL releases would enhance Aurora's functionality.
There are technical challenges, such as the inability to provision the database using a PostgreSQL snapshot directly.
I used the backup options in Amazon Aurora for cloning databases. It's very common.
It is easy to deploy SAP IQ; the implementation and installation are easy.
When there is an issue, the error messaging we get is not always sufficient to do a fast and solid fix.
The pricing for Amazon Aurora is different from DocumentDB because DocumentDB is cheaper.
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.
It replicates data across multiple Availability Zones, ensuring high availability and geographical redundancy, which can be considered a GR instead of a DR.
Amazon Aurora offers a 99.9% SLA compared to PostgreSQL. This ensures a high level of availability for our applications.
We can get historical data quickly, and you can fetch information very quickly because every column is indexed.
The most valuable feature of SAP IQ for us is that it works very effectively with the SAP BusinessObjects which we use it with.
Product | Market Share (%) |
---|---|
Amazon Aurora | 2.8% |
SAP IQ | 1.0% |
Other | 96.2% |
Company Size | Count |
---|---|
Small Business | 5 |
Midsize Enterprise | 4 |
Large Enterprise | 13 |
Company Size | Count |
---|---|
Small Business | 7 |
Midsize Enterprise | 2 |
Large Enterprise | 15 |
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® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.
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.