We performed a comparison between SAP Adaptive Server Enterprise and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"Provides very good integration."
"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."
"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."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"I have found the solution to be scalable."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"Allows us to take volumes and process them at a very high speed."
"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 most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"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."
"User interface could be more user friendly."
"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."
"They could improve the integration and some of the features in the cloud version."
"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."
"We faced some challenges when trying to use the temporary tables feature."
"Support is an area where it could get better."
"I have found that coding support could be simplified."
"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."
"The integration of this solution with ODI could be improved."
"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."
SAP Adaptive Server Enterprise is ranked 16th in Relational Databases Tools with 3 reviews while Vertica is ranked 4th in Data Warehouse with 11 reviews. SAP Adaptive Server Enterprise is rated 8.0, while Vertica is rated 8.8. The top reviewer of SAP Adaptive Server Enterprise writes "Provides integration and ease of access to reporting; UI could be more user friendly". On the other hand, the top reviewer of Vertica writes "Enhanced capabilities, good customer service, large data scalability and stable". SAP Adaptive Server Enterprise is most compared with SQL Server, SAP HANA, IBM Db2 Database, Oracle Database and SAP SQL Anywhere, whereas Vertica is most compared with Snowflake, Teradata, Amazon Redshift, SQL Server 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.
