How HANA Creates Lock in with Core Data Services in HANA

What This Article Covers

  • What is a Core Data Service?
  • How HANA Pushes Down CDS
  • The Lock In to HANA


In this article, we will review the push down of the Core Data Services into HANA. This is presented as a universal positive by SAP, but is it?

What is a Core Data Service?

A core data service is an enhancement to SQL that is a new data modeling infrastructure. This means the data models are defined and consumed in the database rather than the application.

How HANA Pushes Down CDS

However, there are those with considerable database expertise that suggest that HANA driven CDS enabled functionality pushed down to HANA will likely not end well in the longer term. In fact, this is not at all now. Oracle Retail used PL-SQL functionality to push down code into the database from the application. Similar to HANA the logic was for performance reasons.

SAP IS Retail largely sustained more clear separation of duties between the SAP application, NetWeaver and RDBMS tiers, which also enabled AnyDB choices. The issue with the Retek/Oracle approach which tightly linked together the application code as that any client facing customizations, and the application/database versions, made **future upgrades very complex and costly**.

Essentially vs SAP they became effectively “re-implementations” vs supporting technology upgrades that were possible with SAP NetWeaver and SAP IS Retail. And then comes the issue of lock-in.

The Lock In to HANA

One of these database experts stated the following about HANA’s CDS.

I’m personally nervous where the whole HANA driven application to database functional push down will take clients in the long term, for sure they become firmly locked into HANA and any aligned commercial terms.


Core Data Services is a mechanism of lock-in presented as a positive functionality for SAP customers. SAP calls them Core Data Services because they are trying to maintain the illusion that they are doing something very different and innovative from other database vendors. Normally this functionality is called as a stored procedure. Stored procedures are how Oracle increases the difficulty for companies in moving away from the Oracle database and how it reduces the portability between applications and databases.


[Core Data Services CDS in SAP S/4 HANA | SAP Blogs](

HANA & S/4HANA Question Box

  • Have Questions About S/4HANA & HANA?

    It is difficult for most companies to make improvements in S/4HANA and HANA without outside advice. And it is close to impossible to get honest S/4HANA and HANA advice from large consulting companies. We offer remote unbiased multi-dimension S/4HANA and HANA support.

    Just fill out the form below and we'll be in touch.

Brightwork Disclosure

Financial Bias Disclosure

This article and no other article on the Brightwork website is paid for by a software vendor, including Oracle and SAP. Brightwork does offer competitive intelligence work to vendors as part of its business, but no published research or articles are written with any financial consideration. As part of Brightwork’s commitment to publishing independent, unbiased research, the company’s business model is driven by consulting services; no paid media placements are accepted.

The Risk Estimation Book


Software RiskRethinking Enterprise Software Risk: Controlling the Main Risk Factors on IT Projects

Better Managing Software Risk

The software implementation is risky business and success is not a certainty. But you can reduce risk with the strategies in this book. Undertaking software selection and implementation without approximating the project’s risk is a poor way to make decisions about either projects or software. But that’s the way many companies do business, even though 50 percent of IT implementations are deemed failures.

Finding What Works and What Doesn’t

In this book, you will review the strategies commonly used by most companies for mitigating software project risk–and learn why these plans don’t work–and then acquire practical and realistic strategies that will help you to maximize success on your software implementation.


Chapter 1: Introduction
Chapter 2: Enterprise Software Risk Management
Chapter 3: The Basics of Enterprise Software Risk Management
Chapter 4: Understanding the Enterprise Software Market
Chapter 5: Software Sell-ability versus Implementability
Chapter 6: Selecting the Right IT Consultant
Chapter 7: How to Use the Reports of Analysts Like Gartner
Chapter 8: How to Interpret Vendor-Provided Information to Reduce Project Risk
Chapter 9: Evaluating Implementation Preparedness
Chapter 10: Using TCO for Decision Making
Chapter 11: The Software Decisions’ Risk Component Model