We performed a comparison between SAP SQL Anywhere and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."We've found the solution very reliable overall. It's very fast."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"It works well in general."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"SAP SQL Anywhere is very helpful."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"I enjoy the cybersecurity and backup features."
"The solution is quick, has good compression data, and is not expensive."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"It is not as secure as it could be."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."
"We have had some stability issues with SAP SQL Anywhere, but I am not sure if it is an application or network issue. We sometimes have a large amount of data being queried and it cannot handle it."
"The interface is not easy in comparison to the SQL Server. It could be more user-friendly."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Support is an area where it could get better."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"They could improve on customer service."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
SAP SQL Anywhere is ranked 20th in Relational Databases Tools with 6 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. SAP SQL Anywhere is rated 7.6, while Vertica is rated 8.4. The top reviewer of SAP SQL Anywhere writes "Reliable and able to expand but needs to be more secure". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". SAP SQL Anywhere is most compared with SQL Server, SAP Adaptive Server Enterprise, MySQL, Oracle Database and MariaDB, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
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.