SAP HANA Basics For Developers: Part 5.1 Database Content

This series is based upon SAP HANA on premise and SAP HANA, express edition - HANA 2.0 with XSA and SAP Web IDE for SAP HANA. Originally recorded in January 2019.

New to HANA in 1.0 SPS 11 was the HANA Deployment Infrastructure or HDI. The goal of HDI is to manage database artifacts from design time objects but in a way that allows multiple copies/versions of the same core objects to be used on the same HANA database at the same time.

HDI introduces the concept of the container as an abstraction of the Schema. The container in turn dynamically generates the schema, a container-specific Database User who owns all objects, and a password for that database user. XS Advanced based services then only need access to the container and never need to know the actual Schema, technical user, or password. All of that information is stored within the container definition.

[sstockemer]

Thomas! Big thanks for this series! I'm really digging the in depth info. :)
And on a side note, for nearly 10 years I have seen your username on SCN...and all this time, I thought you were German (I'm an expat, living in Germany for about 13 years). So thanks, not only for this video series, but also for all of your support for the entire dev community over the last decade+.
And another side note, will it become impossible (or is it already...) to set up a local WEBIde connection to a SAP cloud appliance library solution?
I've been working on setting up our sandbox and it seems that a service (specifically /sap/hba/) is missing in the SICF.
It kinda feels like this was a strategic move, on the part of SAP, to prevent us from having 'nice things'. My wish is to be able to develop, without "browser inception". At the moment, I'm working in the Live Access systems, but opening a Chrome instance- inside of a local Chrome instance is really killing me. Plus, I want to be able to develop after my 60 hours have been consumed.