Error connecting to HCP Database from Lumira Desktop

[Former Member]

Hi

I have a Lumira desktop trial version and trying to connect to HCP Trial Account Database from the same.

I tried to open the Database Tunnel and used the option of acquiring data set using connection to HANA one. Parameters used were are the local host, user and the dynamic password when the tunnel is opened , as shown in some of the weblogs.

Lumira fails to connect, stating, Unable to connect to localhost.

Am I missing something here?

Thanks,

Amol

[former_member183750 · Accepted solution]

Hi Amol

Here is a copy paste from a wiki we're working on (hopefully to be published soon). Please see if any of the steps help yuo out:

Configuring SAP Lumira to Publish to SAP Lumira Server running on HCP

NOTE: There steps were provided by Development and have never been confirmed due to lack of test system or successful Customer.
Publishing from SAP Lumira (desktop) to SAP Lumira Server may not work when SAP Lumira Server is running in the SAP HANA Cloud platform. 
This issue results from the underlying JDBC connection for the SAP HANA database being hidden by the SAP HANA Cloud platform deployment.
To work around this issue, set up a database tunnel to the SAP HANA Cloud Platform to allow direct access to SAP HANA,  then configure the SAP Lumira (desktop) to use the tunnel when connecting to SAP Lumira Server.

To set up a database tunnel:

Use the documentation at https://help.hana.ondemand.com -> HANA Cloud Platform. The general steps are:
1. Get the SAP HANA Cloud Platform SDK from https://tools.hana.ondemand.com/#cloud
2. Configure the proxy as described in “Setting up the console client”  on   https://help.hana.ondemand.com/help/frameset.htm?7613dee4711e1014839a8273b0e91070.html  
3. Retrieve the available schemas using the list-schemas command as described in https://help.hana.ondemand.com/help/frameset.htm?548e187740914d36820c38e4de346845.html
4. Open the tunnel using the open-db-tunnel command as described in  https://help.hana.ondemand.com/help/frameset.htm?9e3f90f2ead74229ac5c8848ed5bf292.html
Now a tunnel is created and  you can configure SAP Lumira (desktop) to use it to contact SAP HANA directly.

First edit the SAPLumira.ini file:

1. On the SAP Lumira (desktop) machine, open the file SAPLumira.ini, for example C:\Program Files\SAP Lumira\Desktop\SAPLumira.ini
2. Add the following line to the end of the file:
-Durl.hostmap=<http_url>|<jdbchost>:<instance number>
http_url =  URL to access the SAP Lumira Server that is hosted in the SAP HANA Cloud Platform
jdbchost = name of the machine that is hosting the tunnel
instance number = HANA instance. Note that you must use the full instance number, for example “00” rather than just “0”.
For example,
-Durl.hostmap=https://HCPHost.com/sap/bi/launchpad|myhost:00
NOTE: http_url in the SAPLumira.ini file must match the SAP Lumira Server URL entered in ‘Network Preferences’.
3. Save and close SAPLumira.ini

Then configure SAP Lumira (desktop) to use the tunnel:

1. Open SAP Lumira (desktop)  and select File -> Preferences.
2. Select “Network”.
3. In SAP Lumira Server URL, enter the URL for accessing SAP Lumira Server on the SAP HANA Cloud platform. For example https://HCPHost.com/sap/bi/launchpad
4. Select “Done”.
SAP Lumira (desktop) users can now publish to SAP Lumira hosted in SAP HANA Cloud Services

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place 

[Former Member · Accepted solution]

Hi Ludek,

What I am trying to do is, connecting SAP Lumira Desktop version to the Trial account on HANA cloud platform and a particular schema inside the account DB.

My understanding was, i have to first open a Data base tunnel using the below command,

neo open-db-tunnel -a <<ACCOUNT_NAME>> -h <<HCP HOST e.g. hanatrial.ondemand.com>> -u <<user ID or email>> -i <<SCHEMA_NAME>>

and then in Lumira, use the option of "Connect to a SAP HANA One" dataset and on that screen use the parameters for connection that are shown on the open tunnel command screen when the tunnel is opened.

This is not working for me. this procedure is described in the below blog.

Thanks,

Amol