Comprehensive Software Reviews to make better IT decisions
SAP S/4HANA and HANA Licensing Series – Part II: HANA DB Hype?
HANA is SAP’s first serious entry into the database market segment. HANA is touted as being superior in performance when working with SAP applications vs. alternate database solutions, but objective benchmarks are lacking. Additionally, the adoption of S/4HANA necessitates adoption of the HANA DB as it is the only certified solution for S/4HANA ERP.
It didn’t take a lot of digging, even for a non-technical analyst in the Vendor Practice such as myself, to uncover significant performance characteristics between a columnar database and a row-oriented database. HANA is a columnar database. In short, columnar databases generally provide performance gains when used for analytics based processing tasks such as those conducted in a data warehouse environment. Whereas row-oriented databases will perform at a higher level when used for the processing of transactional data.
Since ERP systems are first and foremost transactional systems, it would be reasonable to question SAP’s claims that HANA will outperform competitor database products. In these cases, an objective set of benchmarks should set the record straight in quick order. And this is where the problem lies as there simply seems to be a dearth of third-party data comparing HANA database performance vs. the likes of Oracle’s 12c or Microsoft’s SQL Server Enterprise offerings.
SAP’s current lack of transparency into transactional system benchmarking has me looking deeper into how they do benchmark HANA. Of initial interest is that the only benchmark for HANA published by SAP is the BWAML (previously BW-EML) which are related to the BW application. Fitting that the benchmark published matches the strengths of a columnar database, especially in light of the fact that no benchmarks are published for any of the applications running on databases:
It’s easy to see that for SD – Sales and Distribution modules, benchmarks are available on all manner of databases, all except HANA.
Let’s briefly cover some other key deficiencies in SAP’s HANA database benchmarking methodology:
- Where are the benchmarks outside of BW? SAP’s ecosystem of consulting partners is legendary in size and scale; they essentially operate as an extension of SAP and frequently recommend SAP solutions to their client. This clearly allows SAP to exert significant control on the types of information, benchmark and otherwise, that may reflect poorly on SAP.
- Benchmark objectivity is non-existent when judging yourself. In SAP’s own words:
"SAP Standard Application Benchmarks help customers and partners find the appropriate hardware configuration for their IT solutions. Working in concert, SAP and our hardware partners developed SAP Standard Application Benchmarks to test the hardware and database performance of SAP applications and components."
It should be a foregone conclusion that without third-party benchmarks provided by SAP or encouraged by SAP, SAP’s results should be taken with a grain of salt.
- BWAML benchmark is based on outdated Info-Cubes. Presumably with a columnar database the need for BW Info-Cubes is eliminated. Why then would SAP run a HANA DB benchmark predicated on Info-Cubes, which are a set of devices purpose built to perform best upon a row-oriented DB? Most organizations have a lot of overhead and refinement built into their Info-Cubes and may not be ready to throw all that work aside quite yet.
Remember, SAP has a hard “no discount” policy on its HANA database product licenses, making this one expensive line item. It is no secret that SAP and all other enterprise software vendors are publishing benchmarks for the sole reason to promote and increase sales of their products.
As such, it is critical to look beneath the surface of all the glamorous and successful benchmark results to see what was not measured and ask why. The lack of independent or third-party benchmarks should be another red flag that sews legitimate doubt and compels further scrutiny by the customer. Buyer beware! IT buyers should think twice prior to taking SAP’s or its consulting partners’ word for HANA DB performance. Request the benchmarks comparing HANA with other vendor database solutions running on the same application with like parameters. If you can’t obtain this data, proceed at your own risk.
Want to Know More?
RPA projects fail more often than one would expect. The ease with which RPA tools allow workflows to get designed and implemented makes it easy to avoid building a strong foundation for the work being done.
We live in a metrics-fixated world where having more metrics is always thought to be better than having less, and Software Development Life Cycle (SDLC) metrics are no exception. But the truth is that any badly chosen or managed metric will do more harm than good to your organization. To avoid these pitfalls, take ownership for SDLC metrics away from managers and put it into the hands of those who can best manage it: your development teams.
When leasing IT equipment, the lessor (the company providing the equipment) has one main obligation. However, most leases overlook this critical aspect completely, exposing the lessee (the organization leasing the equipment) to unnecessary risk.
Robotic process automation (RPA) success is dependent on the right business processes to automate. Blueprint helps identify the right places to apply RPA with its Enterprise Automation Suite.
If you want to lease IT equipment, you have many options with regard to potential lessors (the leasing companies). In fact, some manufacturers lease equipment directly to their customers … or do they?
Human bias towards variety has pushed software-supported products and services pressure tech teams to deliver more and deliver faster. Teams have responded admirably by upping their speed but with an unintended consequence: the increasing scourge of technical debt.
SortSpoke’s novel approach to machine learning answers a longstanding problem in financial services – how to efficiently extract critical data from inbound, unstructured documents at 100% data quality.
Check your contracts and you will find that the vast majority contain a force majeure clause. This provision states the conditions by which a party does not have to perform under the contract if it experiences an event beyond the party’s control.
Appian, a prominent low-code development vendor, announced the acquisition of Novayre Solutions SL, developer of the Jidoka RPA platform. This acquisition bolsters its image as a viable vendor to empower the business with development capabilities.