We performed a comparison between SAP Adaptive Server Enterprise 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."This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"It's user-friendly, especially in the logistics field."
"Provides very good integration."
"They provide easy integration with other systems."
"SAP Adaptive Server Enterprise is a good transactional database."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"The actual interface is good."
"The performance is very good and the aggregate records are fast."
"The product's initial setup phase is extremely simple."
"The most valuable feature of Vertica is the unmatchable database performance."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"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."
"User interface could be more user friendly."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"Cost-wise, SAP is still expensive compared to other available products."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"I think that the solution needs to be positioned better within the market as it appears as though the Adaptive Server is being left out of the SAP scope."
"There could be some improvements in barcode scanning and RFID access."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"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."
"It would be great if this were a managed service in AWS."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →
SAP Adaptive Server Enterprise is ranked 17th in Relational Databases Tools with 10 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. SAP Adaptive Server Enterprise is rated 8.6, while Vertica is rated 8.4. The top reviewer of SAP Adaptive Server Enterprise writes " Loaded with a lot of features but the price is a drawback ". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". SAP Adaptive Server Enterprise is most compared with SAP HANA, SQL Server, SAP SQL Anywhere, Oracle Database and IBM Db2 Database, 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.