My scrapbook: October 2016

Wednesday, October 26, 2016

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

Wednesday, October 19, 2016

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