SAP HANA Express - XS Advanced Model - CLI Client

XS command-line tools that enable access to the SAP HANA XS advanced run-time environment.

The procedure described in the documentation did not work for me.

- Create a new organization (for example, called “devteam1”) for the development team.

# xs create-org devteam1


- Create a new space (for example, called “DEV”) for the development team. The space “DEV” will be assigned to the organization “devteam1”.

# xs create-space DEV -o devteam1


- Assign roles to the <USER> user for the run-time organization (“devteam1”) and space (“DEV”).

# xs set-org-role <USER> devteam1 OrgManager
# xs set-space-role <USER> devteam1 DEV SpaceDeveloper


All these organization / spaces can be created under "XS Advanced Administration and Monitoring Tools"  -> "Organization and Space Management"


References:
- http://help.sap.com/hana/SAP_HANA_Developer_Guide_for_SAP_HANA_XS_Advanced_Model_en.pdf

SAP HANA Express - XS Advanced Model - Provision the UAA service with xs-security.json

Important part below, in bold:

"
Next we need to update our tiny_uaa service with the new authorization configuration defined in the xs-security.json file. To do that you first need to download the xs-security.json file from your project in Web IDE to a folder accessible from your command line tool. Then, we will delete the service (which we provisioned in part 10 of this tutorial (Add authentication) for testing authentication) and recreate it with the new security definitions.

Run the following xs commands:

xs delete-service tiny_uaa
xs create-service xsuaa devuser tiny_uaa -c ./xs-security.json    
"

References:
- https://blogs.sap.com/2016/03/29/developing-with-xs-advanced-add-authorization/

SAP Trials - SAP NetWeaver 7.5 SP1 AS ABAP and SAP BW on SAP HANA - Annotations (2)

Creating artifacts via SQL: do not have benefit of creating the objects in the repository, no transport or versioning;

Catalog artifact:

- Creating schema: file suffix <schema_name>.hdbschema

- Creating table: file suffix <table_name>.hdbtable

<tablename>.hdbtable - A syntax used to define a design-time representation of a table

What is the main advantage of the design-time approach to data modeling? Transportability of data models between SAP HANA systems

- Creating sequences: file suffix <sequence_name>.hdbsequence

- Creating views: file suffix <view_name>.hdbview

- Creating roles: file suffix <role_name>.hdbrole

Related to file .xsprivileges

System user _SYS_REPO is the owner of the objects.

Grant authorization to user - call stored procedure: call _SYS_REPO.GRANT_ACTIVATED_ROLE('sap.hana.democontent.epm.roles::Admin','SYSTEM');

Wrong way to get authorizations:

After creating the schema, it is not visible under Systems -> Catalog; Execute the following SQL:

call _SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT(
                'select, create any, insert, delete, update, execute, alter, drop',
                'WORKSHOPA_00',
                'SYSTEM');

References:

- http://saphanatutorial.com/sap-hana-xs-create-schema-using-hdbschema-file/

SAP Trials - SAP NetWeaver 7.5 SP1 AS ABAP and SAP BW on SAP HANA - Annotations (1)

Some of the default settings when deploying the captioned system image into the AWS:

- System ID: HDB
- System number: 02
- HANA database server name: vhcalhdbdb
- HANA XS host:port - vhcalhdbdb:8002

1. In Eclipse HANA Development, the system is already added, just log-on with user SYSTEM and the master password.

2. Setup repository workspace in local PC:

Core application files:

• Application descriptor (.xsapp): marks web content root;
• Application access (.xsaccess): 
• exposes web content;
• sets user/client authentication mechanism;
• (.xsprivileges):
• authorizations, access levels;

Both files are created automatically when creating a new project.

Seems that the commit is automatically executed.


References:
- https://open.sap.com/courses/hana1-1
- https://archive.sap.com/discussions/thread/3673580

SAP Trials - SAP NetWeaver 7.5 SP1 AS ABAP and SAP BW on SAP HANA

1. Go to SAP developer portal (http://go.sap.com/developer.html) and select "Trials/Downloads". Search the desired product, in my case is "SAP NetWeaver 7.5 SP1 AS ABAP and SAP BW on SAP HANA" and click on "Trial" link.The Cloud Appliance Library (CAL) will be loaded;

2. Set-up the CAL account if necessary;
3. Sign-up for a AWS account (aws.amazon.com), i've chosen the basic plan which is free. Follow all instructions to activate the AWS account, which involves a phone call in order to input an activation code;

4. After AWS account is ready, go to Services -> Identity and Access Management (IAM) -> Users -> Create New Users -> Create User Name e.g. "sap_cal_user". The user name here does not really matter, can be any name. What really matters is the user credentials in the next step;

5. Download the "User security credentials". Keep this file in a safe place;

6. Under IAM, go to Groups -> Create New Group e.g. "sap_cal_group" and assign policy "AdministratorAccess" to the group;

7. Still under IAM -> Groups, assign the the user "sap_cal_user" to the group "sap_cal_group";
That's all needed to prepare the cloud service provider account;

8. The CAL will deploy two instances (or virtual machines):

- SAP Frontend (type m3.medium)

- Linux (type r3.2xlarge)

The instance type (r3.2xlarge) for the Linux instance, by default, is not included in the Basic AWS account and must be requested before deploying the SAP trial; For that, go to console.aws.amazon.com/ec2/ , select on the top right the region where the VM's will be deployed - US East (N. Virginia) - click on "Limits" in the left menu and search for "r3.2xlarge". In case the limit is zero (as the sample below), it's necessary to request limit increase. 

 

9. Deploy SAP trial / developer edition using CAL: go to www.sap.com/abaptrial - it will redirect to a blog post. Go to the "Get Your Free Virtual Appliance" section and select the desired version e.g. "SAP NetWeaver 7.50 SP1 AS ABAP and SAP BW on SAP HANA [Developer Edition]".

10. Log-in into CAL and follow the steps to create the instance;

Name:

Cloud Provider: Amazon Web Services

Access Key: Provided in user security credentials of "sap_cal_user" (step 5);

Secret Key: Provided in user security credentials of "sap_cal_user" (step 5);

11. Enter Instance Details:

Name: e.g. HANADEV1

Region: must be "us-east-1"

Password: <@#$%>

Click on "Create" button

12. Download the .pem file with the certificate;

13. Wait the instance to be created (around 60 minutes);

archlinux - some installed apps

Video players:

1. smplayer (have all required codecs)
2. parole

Additional install: gstreamer


Video editing: kdenlive


Disk usage overview: xdiskusage

archlinux: annoying missing icons

I had a fresh install of Archlinux running GDM with Gnome and Xfce.
After installing a couple of apps (Firefox and Chrome) the icons were missing in the menu entries.

By running the below command as root and restart, the issue is fixed.

# gtk-update-icon-cache -t -f /usr/share/icons/hicolor


References:
- https://bbs.archlinux.org/viewtopic.php?id=129988