[SAP HANA Academy] SAP HANA Cloud Platform & SAP Lumira (2/2) - Connecting to HCP Schema from Lumira

[Former Member]

The SAP HANA Academy’s Tom Flanagan shows how to connect a SAP HANA Cloud Platform schema to SAP Lumira in a two part tutorial video series. In the second half of the series Tom details how to connect the SAP HANA Cloud Platform view created in Part One to SAP Lumira. The connection can be established two ways. Either via connecting though SAP HANA or querying with SQL. Check out the video below.

(0:36 – 1:50) Using the Command Prompt Tool to tunnel into SAP HANA Cloud Platform

First Tom connects to the SAP HANA Cloud Platform by tunneling in using the command prompt tool. For further details on how to connect to the SAP HANA Cloud Platform via tunneling please view this video from the SAP HANA Academy's jamie.wiseman.

After opening the command prompt tool paste in the tunneling syntax listed below. Please enter your own personal free SAP HANA Cloud Platform developer trial account and instance name.

cd C:\Program Files\SAP\hcpsdk\tools

proxy  Windows:

    set HTTP_PROXY_HOST=proxy

    set HTTP_PROXY_PORT=8080

    set HTTPS_PROXY_HOST=proxy

    set HTTPS_PROXY_PORT=8080

    set HTTP_NON_PROXY_HOSTS="localhost"

neo open-db-tunnel -i [instance name] -a [account number starting with p]trial -h hanatrial.ondemand.com -u p[account number starting with p]

Once you have successfully tunneled into the SAP HANA Cloud Platform copy the information that appears and paste it into notepad. This information ranging from top with host name to bottom with schema name will be used to connect to SAP Lumira.

(1:50 – 3:30) Connecting to SAP Lumria via SAP HANA

First start SAP Lumira, click on file and choose new. Then in the New Dataset window that pops up choose Connect to SAP HANA. On the following screen enter localhost as the Server and leave the Instance/Port as 00. From your notepad copy your Dev User Name and Password and paste them into their respective boxes before clicking connect.

On the following screen you will see a view with your SAP HANA Cloud Platform name. Click on the view and leave the measures and dimensions the same before clicking the create button.

Now that the dataset has been created using your SAP HANA Cloud Platform view you can drag and drop items to create visualizations of your data in SAP Lumira. For tutorials on how to create visualizations in SAP Lumira view the final videos in tahirhussain.babar SAP Lumira series.

(3:30 – 4:35) Connection to SAP Lumira via Query with SQL

Once again click file and then new. This time choose Query with SQL. On the Select a Database screen choose Generic JDBC datasource. Now copy and paste in your User Name, Password, and JDBC URL for the notepad. For JDBC class enter comp.sap.db.jdbc.driver .

In the Query box on the next screen enter the below SQL statement using your personal schema name from the notepad beginning with NEO.

SELECT*FROMNEO[personal schema name].TABLE

Now click on the preview button to review the data before clicking on create. Now you have successfully connected your SAP HANA Cloud Platform schema to SAP Lumira via an SQL query.

View more tutorial videos about SAP HANA Cloud Platform at the SAP HANA Academy.

SAP HANA Academy - over 800 free tutorial technical videos on using SAP HANA.

Follow @saphanaacademy