Coming October 25: PeerSpot Awards will be announced! Learn more

SAP Adaptive Server Enterprise vs Vertica comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

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.

To learn more, read our detailed SAP Adaptive Server Enterprise vs. Vertica report (Updated: September 2022).
634,550 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More SAP Adaptive Server Enterprise Pros →

"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."

More Vertica Pros →

Cons
"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."

More SAP Adaptive Server Enterprise Cons →

"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."

More Vertica Cons →

Pricing and Cost Advice
Information Not Available
  • "It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
  • "The pricing for this solution is very reasonable compared to other vendors."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    634,550 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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… more »
    Top Answer:The setup cost is a bit expensive, but the pricing and licensing are just right.
    Top Answer: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… more »
    Top Answer: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.
    Top Answer:The pricing for this solution is very reasonable compared to other vendors.
    Top Answer:We faced some challenges when trying to use the temporary tables feature. First, we installed Vertica on the AWS cloud and tried to read the data from Bitbucket to Vertica. We were able to read the… more »
    Ranking
    Views
    1,927
    Comparisons
    1,035
    Reviews
    3
    Average Words per Review
    370
    Rating
    8.0
    4th
    out of 30 in Data Warehouse
    Views
    9,030
    Comparisons
    7,035
    Reviews
    10
    Average Words per Review
    496
    Rating
    8.8
    Comparisons
    Also Known As
    SAP ASE
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    Learn More
    Overview

    With SAP Adaptive Server Enterprise (SAP ASE), you can handle massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. Drive value with a faster, more efficient transactional system that is designed to meet the demands of the digital economy.

    Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

    To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

    Offer
    Learn more about SAP Adaptive Server Enterprise
    Learn more about Vertica
    Sample Customers
    City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), Takisada-Osaka Co. Ltd., Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider12%
    Financial Services Firm12%
    Manufacturing Company7%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Comms Service Provider15%
    Financial Services Firm13%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business29%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise73%
    REVIEWERS
    Small Business32%
    Midsize Enterprise26%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise14%
    Large Enterprise70%
    Buyer's Guide
    Relational Databases Tools
    September 2022
    Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: September 2022.
    634,550 professionals have used our research since 2012.

    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.