1- Prerequisites
- You have an account on SAP HANA Cloud trial landscape*
* This tutorial is based on the free trial option available on the SAP HANA Cloud Platform.
- You have downloaded and installed SAP HANA Tools in accordance with Installing SAP HANA Tools for
Eclipse (latest version of the tools is preferred).
2- Connect to SAP HANA Cloud Platform from Eclipse IDE
Login to the HANA Cloud Platform Cockpit:
https://account.hanatrial.ondemand.com/
Go to HANA Instances, and then create a new database instance:
To open a secured connection from your Eclipse IDE to SAP HANA database, open the SAP HANA Development perspective and choose Add Cloud System:
Enter your account name shown in the cockpit, along with the S-User and password:
Choose the trial instance created in the first step:
Reaching this point you should now be able to see the created instance in the Administration perspective:
Important Notes:
In this step you need to note down the names of the two schemas created for you trial account:
The database schema that is prefixed with NEO_ is the development schema. You should store all database artifacts connected to application development like tables, stored procedures, and so on in this schema.
The database schema that is prefixed with DEV_ is the private schema of the developer user. You should not create database artifacts that are to be used in your cloud applications in this private schema.
Please note that the package that is going to be used later on for creating our views that are going to be used in Lumira is called <S-User>trial.
In order to make this package available it has to include at least one analytical/calculation view.
In this step we will create a dummy view using the tables from the schema EPMSAMPLEDATA.
To create the calculation view, go to SAP HANA Systems view and follow the steps:
1. In your <username>trial.test repository package, create a new Analytical view with the name TRIAL:
2. Drag and drop the SNWD_AD tables from the EPMSAMPLEDATA schema to Data Foundation.
3. Click on both CLIENT and NODE_KEY to add to output:
4. Go to Semantics, set CLIENT as an attribute and NODE_KEY as a measure. Save and Activate:
Due to user isolation requirements of SAP HANA Cloud Platform and security reasons, the default SAP HANA database user has restricted privileges and cannot use the Open Data Preview context.
To be able to see and select data from the analytical view that you have just activated, the user needs to be granted additional select privileges. You do this by executing the procedure:
CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"
You now have to exit Eclipse.
3- Connect to SAP HANA Cloud Platform from Lumira
Although it is a very straight forward procedure to connect Eclipse to your cloud instance, this step is a little bit more complicated in the case of Lumira for you to be able to establish such a connection.
Connecting Lumira to the HCP can be achieved by using the tunnel that comes as part of the HANA Client download.
Whenever the tunnel connection is open do not try connecting via Eclipse. The tunnel connection overrides the initial credentials, and hence interrupts the Eclipse connection.
Stop the tunnel connection before launching Eclipse every time.
To activate HCP Tunnel you need to:
Install the SDK:
1. Open https://tools.hana.ondemand.com/#cloud
2. From the SAP HANA Cloud Platform SDK section, download the relevant SDK archive file and save it to your local file system.
3. Extract the ZIP file.
Setup the Console Client:
1. Open the command prompt.
2. Change the current directory to the <SDK_installation_folder>\tools location, which contains the neo.bat and neo.sh files. For example:
3. In case you use a proxy server, specify the proxy settings by using environment variables. You can find sample proxy settings in the readme.txtfile in the \tools folder of your SDK location.
In case you do not need a proxy seup you can proceed to the next step, if a proxy is needed, please follow the following video for more details: https://www.youtube.com/watch?v=UHuSnBMimPA
Opening a Database Tunnel:
1. Open the command window in the <SDK>/tools folder.
2. Enter the following command to open a tunnel:
neo open-db-tunnel -i <instance-name> -h <hostname> -u <s-user> -a <account>
Instance-name: Enter the trial instance name created previously (i.e. test).
Database type: HANA, HANAXS, or MaxDB
Hostname: Enter here hanatrial.ondemand.com
S-user: Enter your used s-user.
Account: Enter your account name (i.e. <s-user>trial)
If the tunnel is opened successfully, the following details are displayed:
Hostname: localhost
Instance number: For example, 00. Required for the SAP HANA studio.
User: User for connecting to the database
Password: Password for the database login.
Schema name: For database types HANA and HANAXS
At this point you can start the actual connection to HCP through Lumira, to test the connection you can now launch Lumira, open the existing story and publish it to HCP:
In this step you can enter the system credentials provided by the tunnel openned:
Once you are connected successfully, now you can start creating the package where you will be creating the HANA views for building your new Lumira story.
Important Notes:
When you are creating a new package make sure that due to the limitation of the HCP trial account, you need to give your created schema the same name as your account: <S-User>trial
From the schema dropdown menu, you need to change your current schema to the schema prefixed with NEO_. If there are more than one schema with the same schema, please refer to the tunnel opened for getting the name of your active schema.
You are free to choose the HANA view name.
You should now get a message saying that the publish was successful, however, in order to be able to access the newly created view you need to assign the SELECT privilege on that view first.
You can now stop the HCP tunnel by pressing Enter in the opened command prompt window.
Now you can run eclipse again and run the procedure again:
CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"
4- Create New Lumira HCP-Based Document
Reopen the tunnel to HCP and record the new access details (password is updated each time you start the HCP tunnel).
Please be aware that each time you are going to be using the created document, the HCP tunnel has to be opened in advance.
Create a new Lumira document, and choose Connect to SAP HANA as a source:
Enter the current credentials given by the HCP tunnel.
You should now be able to see the created view:
- SAP Managed Tags:
1 Comment
