Access external schema from SAP Business Application Studio

Abstract

This document aims at accessing external schema from a HDI container using user provided service of cloud foundry in Business Application Studio in SAP BTP. Developers, who are having basic HANA cloud database development knowledge can easily perform the task. An HDI container is a service layer of the SAP HANA Database that manages dependencies, executes as a transaction, and consists of schemata and a set of users that together allow an isolated deployment of database artifacts. SAP HANA HDI container consists of a design-time container and a corresponding run-time container. Database schema abstracted by HDI container and should only be accessed via container. HDI containers ensure isolation, and within an SAP HANA database you can define an arbitrary number of HDI containers. The same objects can be deployed multiple times into different HDI containers in the same SAP HANA database. HDI containers are isolated from each other by means of schema-level access privileges. Cross-container access at the database level is prevented by default but can be enabled by explicitly granting the necessary privileges, for example, using synonyms.