Access a Classic Schema from Business Application Studio
January 7, 2021
Beginner
20 min.
Access data in a plain or replicated schema from an HDI Container in SAP Business Application Studio
You will learn
- How to create a plain schema, with a table and user to simulate a replicated schema
- How to create a user-provided service to access a database in SAP HANA as a Service
- How to grant permissions to the technical users in your HDI container to access the database
Prerequisites
- You have access to SAP HANA Cloud.
- You have created an SAP HANA Database Project as explained in this tutorial.
This tutorial is meant to be an example of cross-container access. Simple data models and loading mechanisms were chosen to simulate a schema replicated using tools such as SAP Landscape Transformation or an ABAP schema.
For more information on this process and additional syntax options, refer to the official documentation on SAP Help.
If you are looking for the steps for an on-premise SAP HANA instance with XS Advanced, such as SAP HANA, express edition, refer to this tutorial.
Step 1: Create a plain schema
Step 2: Load data
Step 3: Create a user-provided service
Step 4: Grant permissions to the technical users
Step 5: Create synonyms
Step 6: Create a view
Step 7: Troubleshooting insufficient privileges