Skip to Content
0

Transportation best practices in Native SAP HANA

May 10, 2017 at 10:11 PM

177

avatar image
Former Member

Hi Team,

Here is my scenario.

We have native SAP HANA (SPS12) system used for mainly Analytics, no web-development at this point.

We have data coming in from different data sources either loading into HANA or through virtual tables. Following are the most frequently created objects in HANA by our team.

1) Custom Schemas

2) Virtual Tables using SDI Adapters

3) Physical Tables

4) Procedures

5) Table Functions

6) Calculation Views

7) Analytic Privileges

8) Roles

9) Users

Ideally we want to handle transportation of these objects via HANA LM using DU & Change Recording.

I know that we can handle objects 1,3,4,6,7,8 transportation by creating them as repository objects (creating objects in development perspective).

I am looking for your advises on 2,5,9 object types transportation. HDI containes in SPS12 XSA seems like an option, however system generated schema names looks awkward for Analytical System.

Regards,

Venkat

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Thomas Jung
May 15, 2017 at 12:51 PM
1

Table functions (HDBSCALARFUNCTION and HDBTABLEFUNCTION) can be repository objects and transported as well.

HDI is definitely the long term replacement however. It does handle more objects than the old repository + DUs. You can override the generated schema names and supply your own Schema name as well.

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Thomas,

Thank you very much for the reply.

Do you mind pointing me towards good material on how to override system generated schema names in XSA. I believe we can also create virtual tables as repository objects using HDI.

Any advise for 'USERS' expect creating them manually in each system?

0

>I believe we can also create virtual tables as repository objects using HDI.

Yes virtual tables are supported in HDI as well.

>Do you mind pointing me towards good material on how to override system generated schema names in XSA.

In your mta.yaml when you define the container resource, use the configuration parameter, schema, to specify the schema name

resources:  
  - name: user-container    
properties:
user-container-name: '${service-name}'
type: com.sap.xs.hdi-container
parameters:
config:
schema: OPENSAP_HANA5_USER_EXAMPLE
1

>Any advise for 'USERS' expect creating them manually in each system?

Users are not design time objects. If you don't want to manually set them up, we recommend using external identity management.

0
Former Member

Thanks for the quick reply.

0