Previous Episode: https://www.youtube.com/watch?v=0Em_U...
Rarely will you work only within the data model of your own application. Most applications will need to access data from other HDI containers or classic HANA Schemas. In this episode we will see the steps to access a Classic Schema. We will use SFLIGHT schema (available here: https://github.com/SAP-samples/hana-x... ) to simulate a classic ERP or S/4 schema. We will see the setup of the User Provided Service, how to create hdbgrants and finally creating synonyms to the foreign schema. We will also explorer the concept of structure privileges and how to extend those to be used by the container technical user as well.
3:58 SFLIGHT Security Setup
9:28 Create User Provided Service
13:28 Extend mta.yaml with new resource
14:51 Add User Provided Service to default-env.json
17:38 Service Replacements concept
27:40 Bringing SFLIGHT Tables into CDS
39:24 Structured Privileges