HANA Multitenant Database Containers (MDC)

  • Syed Hussim
  • 20 July 2017
  • 1123
The new releases of HANA DB including HANA Express support Multitenant Database Containers (MDC). The concept of Multitenant Database Containers can be confusing for those coming from a background where a database server can host many databases such as MySQL. Why? Because you naturally expect a database server to be capable of hosting more than one database irrespective of database vendor. The idea that a database server could only host one database would raise an eyebrow for many developers.

Prior to Multitenant Database Containers, HANA DB, only supported a Single Database Container. That is, one HANA system, one database. To achieve multi tenancy, virtualization technology such as WM ware was required. With the release of SPS09, SAP introduced Multitenant Database Containers that allow multiple databases to reside in a single HANA system. Tenant databases in the same system, share the same resources (memory and CPU), however each tenant database is isolated with its own users, catalog, repositories, data files and services. It is now possible to run both SAP Business Suite and SAP Business Warehouse in the same HANA system using multiple tenants.

Tenant databases can also be spread across multiple nodes and can be allocated system resources independent of each other. All tenant databases are managed by the SystemDB.
HANA DB Articles

Recent Articles

  • A JavaScript Implementation Of The Logo Programming Language - Part 1

    In this four part article, I explain how to develop the iconic Logo programming language in JavaScript. In this part, we discuss how to take a source input and convert it into a series of tokens.

  • Generating Web API Keys

    If you're building a REST API, chances are you're going to need to generate secure random API keys. In this article, I explain how to use the Node.js crypto module to generate random secure API keys.

  • Port Scanner

    A simple port scanner to scan a range of ports.

  • Stock Transfer Part 1

    The SAP B1 Service Layer provides an API to move stock between warehouses. This article explains the construction of the JSON payload data that is posted to the StockTransfers API.

  • Sorting Algorithms

    An introduction to sorting algorithms.

  • If Table Exists Function

    In this article, I explain how to create a function to determine if a table exists in SAP HANA.

  • Connect To HANA DB Using NodeJs

    This article explains how to connect to a SAP HANA system using the Node HANA client library.