Going beyond! Using synonyms to access data extern...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
One of the most desired features in native SAP HANA development is to achieve true isolation between applications that run (or are developed) in the same SAP HANA landscape. With SAP HANA XS Advanced Model the use of organizations, spaces and HDI containers (rather than classic" database schemas) makes this not only possible but actually very easy.
However isolation does have a price should your scenario involve accessing data that's not stored within the HDI container of your application.
Imagine that you need to access data that's already stored in a "classic" SAP HANA database schema - perhaps being managed by or having originated in some other application like S/4, ERP or BW?
Or you have data in an HDI container generated by your XS Advanced application but how can other "classic" applications access it via a traditional database schema?
Or how can you access data that's stored in the HDI container of a different XS Advanced application - perhaps that of another developer during the development phase?
These are all great questions!
The answers involve creating and granting roles along with the use of database synonyms so that tables & views can appear as if they're part of your application even if they're physically stored elsewhere in SAP HANA.
christoph.gilde already published an excellent series of blogs that cover how to do this.
At the SAP HANA Academy we love to produce hands-on video tutorials - so inspired by Christoph's great work - we've published a series of new video tutorials that show you how to answer the above questions step by step.