Skip to Content
Author's profile photo Stoyan Manchev

Using HANA Modeler in SAP HANA Cloud Platform

Obsolete: The SAP HANA Cloud Platform Trial landscape now provides MDCbased tenants which can be used as productive SAP HANA instances. For further information on Trial HANA MDC development, see SAP HANA Multitenant Database Containers (MDC) scenarios now on trial landscape and SAP HANA: Development.

Assigned tags

      62 Comments
      Comments are closed.
      Author's profile photo Matthias Steiner
      Matthias Steiner

      Awesome!!!

      Author's profile photo Christian Paulus
      Christian Paulus

      Thanks Stoyan, this helped a lot to understand the current situation in regards to native HANA development on HANA Cloud. This is good stuff and I will surely try it out myself.

      Do your plans include lifecycle aspects like import/export of HANA Delivery Units to my schema/repo package?

      Author's profile photo Emil Aleksandrov
      Emil Aleksandrov

      Hi Christian,

      Yes, we are looking into SAP HANA import/export DU functionality. As this is currently functionality that requires Administrative privileges we are thinking how to wrap it and enable it for HANA Cloud users.

      Best regards,

      Emil

      Author's profile photo Rui Nogueira
      Rui Nogueira

      Thanks a lot Stoyan for sharing this! These are great news!!

      I'll be on summer vacation from next week on and will take this as an opportunity to dive into the SAP HANA Studio and see how it can talk to my SAP HANA Cloud Platform account. Together with the newly available Mac version of the SAP HANA Studio Developer Edition I'll be completely prepared 🙂

      Best,

      Rui

      Author's profile photo Former Member
      Former Member

      I tried the above tutorial. But got stuck at one place i.e. while testing the remote servlet access. I have also authorized my user i.e. - p1678012516trial with the role that I specified in web.xml of application. And when I am trying to login with this user while accessing the servlet it is not authenticating. The password that I am using is same as that of I use to login in SAP HANA Cloud Service. Repeated trial ended up in following error. Please help in getting out of this problem. I used FORM based authentication also in place of BASIC and the result was same.

      HTTP Status 403 - Access to the requested resource has been denied


      type Status report

      message Access to the requested resource has been denied

      description Access to the specified resource has been forbidden.


      SAP

      Author's profile photo Dimitar Tenev
      Dimitar Tenev

      Hi Manoj,

      "p1678012516trial" is yout account id. Do assign the role "jdbc_remote_access_admin" to your user id "p1678012516".

      Best regards,

      Dimitar

      Author's profile photo Marcos Rocha
      Marcos Rocha

      Hi Dimitar,

      I got the same error as Manoj describe and can´t assign the role to user "i2232211", but only to the user "i2232211trial".

      Do you have any other idea?

      Best,

      Marcos

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Marcos,

      actually you are assigning role "jdbc_remote_access_admin" from application "hihana" which is part of account "i2232211trial" to the user "i2232211". After that you have to login with "i2232211", not with "i2232211trial".

      Author's profile photo Former Member
      Former Member

      Thanks Stoyan,

      It worked.

      Thanks for the help.

      Author's profile photo Frank Schuler
      Frank Schuler

      Hello Stoyan,

      thank you for this excellent blog.

      We got easily to a servelt that seems to work through the browser (the Request URL: https://hihanas000XXXXXXXtrial.hanatrial.ondemand.com/dbaccess-beta-0.3.0/ and Driver URL: jdbc:remotedb:https://hihanas000XXXXXXXtrial.hanatrial.ondemand.com:443/dbaccess-beta-0.3.0/RemotingServlet are slightly different from your blog but correct according to help.sap.com).

      However SAP HANA Studio fails to connect with the message "An exception stack trace is not available."

      Would you know a way to get to the root cause of this issue?

      Very best regards and many thanks in advance

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Frank,

      I noticed that Remote Access Tool documentation is changed. I will adapt the blog accordingly.

      About error you got, it is hard to find out what is wrong from this message 🙂

      To get more information do the following:

      1. Add your Remote System to the SAP HANA Studio

      2. Got to <workspace forlder>\.metadata and see what was lastly written in .log file

      Best regards

      Stoyan

      Author's profile photo Frank Schuler
      Frank Schuler

      Thank you Stoyan.

      the .log file says

      !ENTRY com.sap.ndb.studio.navigator 4 1 2013-08-19 11:25:25.982

      !MESSAGE [hihanas0007397050trial https://hihanas000XXXXXXXtrial.hanatrial.ondemand.com:443/dbaccess-beta-0.3.0/remotingservlet 00 (S0007397050)] Error when refreshing system

      !SUBENTRY 1 com.sap.ndb.studio.navigator 4 0 2013-08-19 11:25:25.982

      !MESSAGE SAPControl request failed

      !STACK 0

      com.sap.ndb.studio.sapcontrol.SAPControlException: SAPControl request failed

      at com.sap.ndb.studio.sapcontrol.operations.SAPControlOperation.execute(SAPControlOperation.java:118)

      at com.sap.ndb.studio.sapcontrol.SAPControl.getInstanceProperties(SAPControl.java:507)

      at com.sap.ndb.studio.sapcontrol.SAPControl.collectProperties(SAPControl.java:583)

      at com.sap.ndb.studio.sapcontrol.SAPControl.open(SAPControl.java:372)

      at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:130)

      at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:82)

      at com.sap.ndb.studio.sapcontrol.SAPControlManager.needCredentials(SAPControlManager.java:55)

      at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTrySAPControl(SAPSystemObjectUpdate.java:123)

      at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:69)

      at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:72)

      at com.sap.ndb.studio.datamodel.controler.DataModelOperationJob.run(DataModelOperationJob.java:70)

      at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

      Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Bad URL: Invalid authority field: [https:

      at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(Unknown Source)

      at com.sap.ndb.studio.sapcontrol.operations.SAPControlOperation.execute(SAPControlOperation.java:94)

      ... 11 more

      !SUBENTRY 1 com.sap.ndb.studio.navigator 4 4 2013-08-19 11:25:25.982

      !MESSAGE Internal error

      !STACK 0

      Many thanks in advance again

      Frank

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Frank,

      the exception you have posted is "expected" behavior, because this is one of the Remote Access Tool limitations - SAP Control is not supported.

      Can you please check your proxy settings - http and https proxies should be configured (if you are behind proxy).

      Best regards

      Stoyan

      Author's profile photo Frank Schuler
      Frank Schuler

      Hello Stoyan,

      strangely the access works intermittedly. However there is always a red cross on the system, even when the connection works and the exception is

      com.sap.ndb.studio.jdbc.JDBCConnectionStatus: In method getAccessdata: The password must be specified.

      Do you have any idea where this might come from?

      Very best regards and many thanks in advance again

      Frank

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Frank,

      the red cross that you see on the system is some known limitation - because SAP Control is not working. But this in no way will stop you working as usual with your db schema and repository.

      As Remote Access Tool is in beta, it has some limitations - as the one you have noticed. Currently will are working on new connectivity model that will fill all the gaps you see while working with Remote Access Tool.

      Author's profile photo Former Member
      Former Member

      how to connect to db from hana studio using driver url.I have remote servlet running.

      Author's profile photo Sampathkumar Subramaniam
      Sampathkumar Subramaniam

      Hi Stoyan,

      I have the below problem in Remote Database Access tool even after proxy configuration.

      Could not open connection to 'hihanap1937023077trial https://hihanap1937023077trial.hanatrial.ondemand.com:443/dbaccess-beta-0.3.0/remotingservlet 00'

      java.util.concurrent.ExecutionException: com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Could not connect: 401 Unauthorized

      any idea how to fix this?

      Thanks a lot in advance.

      Regards,

      Sampath.

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Subramaniam,

      there are 2 things that can be wrong:

      1. You have not assigned "jdbc_remote_access_admin role to your users as described in https://help.hana.ondemand.com/help/frameset.htm?cb437d5c3eed4742b42d78328917493f.html

      2. During login your are not using your <username>, but <username>trial.

      best regards

      Stoyan

      Author's profile photo Sampathkumar Subramaniam
      Sampathkumar Subramaniam

      Thanks a lot Stoyan.

      Issue is fixed now.

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hi

      Great read.. indeed, very helpful...

      Author's profile photo Apoorv Bhargava
      Apoorv Bhargava

      Thanks Stoyan for sharing this very helpful blog.

      I am relatively new to HANA Cloud world and curious to understand the difference between this servlet approach vs XSJS approach.

      In past, I used XSJS to connect to data base and get the data from tables which seems to similar to this servlet approach.

      It would be very helpful if you share some info o this

      Author's profile photo Jordan Jordanov
      Jordan Jordanov

      Hi Apoorv,

      There are some similarities in XSJS and JAVA Servlets.

      In both cases you can connect to the DB and expose your business logic as a serivce in the web.

      The difference is in the setup - with XS you use only HANA as dev and runtime environment and you don't need additional servers. Taking in mind the locallity of the XS Engine in the HANA DB you can expect also better berformance for your HANA Native applications. From the other hand side JAVA applications are far more powerful when it comes to integration with other systems and consumption of external services due to the various libraries available for that.

      Note that XS applications will be supported in the SAP HANA Cloud soon. We are currently working on that.

      Best Regards

      Jordan

      Author's profile photo Former Member
      Former Member

      Hi Jordan,

      As a part of the support of HANA native development on the cloud, will there be support for exposing OData services from the HANA Cloud tables? If yes, there two advantages I can think of.

      1. We would save a lot of development effort if we are able to use OData services with SAP UI5.
      2. We might be able to deploy the same application on HANA One or HANA Cloud with minor (if any) changes.

      Can you please let us know if SAP planning for OData from HANA db tables on HCP?

      Regards

      Ajay

      Author's profile photo Jordan Jordanov
      Jordan Jordanov

      Hi Ajay,

      The plan is to enable HANA XS Development and to support more or less all features of HANA including OData Services.

      Deploying applications on SAP HANA Cloud will have some specifics though.

      For the beginning you will not be able to import DUs directly in HANA but will have to use HANA Development Perspective in the Studio and activate your projects from there.

      Let's wait for the official delivery. It will come with the appropriate documentation.

      Best Regards

      Jordan

      Author's profile photo Former Member
      Former Member

      Hi Jordan,

      This is good news. Can you please let know how long it might take for SAP to release this?Even an approximate indicator regarding the timeline would help.

      Regards

      Ajay

      Author's profile photo Emil Aleksandrov
      Emil Aleksandrov

      Hi Ajay,

      The first version of how you can build and run HANA XS application in SAP HANA Cloud will come within weeks on TRIAL landscape. We will update this blog as well.

      Best regards,

      Emil

      Author's profile photo Ashok Kumar M
      Ashok Kumar M

      Hi Jordon,

      Please give some information on accessing HANA XS inside cloud platform.

      Best Regards,

      Ashok.

      Author's profile photo Former Member
      Former Member

      Thank you very much for the useful information. it does really gave me indepth idea of hana modelling in cloud.

      chandra

      Author's profile photo Frank Schuler
      Frank Schuler

      Hello Stoyan,

      SAP HANA Studio does not show a _SYS_BIC schema but only a SYS and a _SYS_REPO for my SAP HANA Cloud system. Therefore I cannot find my generated column view.

      Thank you very much for your help in advance again

      Frank

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Frank,

      and you have successfully executed CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"?

      Author's profile photo Frank Schuler
      Frank Schuler

      Hello Stoyan,

      yes, this got executed successfully. Should that have created the _SYS_BIC schema?

      Best regards

      Frank

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Frank,

      after execution of this procedure you should be able to see a column view in _SYS_BIC schema and be able to select data from it.

      Can you tell me what is the package name in which you have created the calculation view?

      best regards

      Stoyan

      Author's profile photo Frank Schuler
      Frank Schuler

      Hello Stoyan,

      we started from scratch and observed the following:

      1. When trying to activate calculation view SO_CV, SAP HANA Studio reports "There are no inactive objects in your workspace to be activated"
      2. When running "ALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" the result is "Statement 'CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"' successfully executed in 430 ms 173 µs  (server processing time: 0 ms 0 µs) - Rows Affected: 0

      Are we missing something?

      Very best regards

      Frank

      Author's profile photo Former Member
      Former Member

      Hi Frank,

      I have the same problem. Did you find any solution for it?

      Thanks,

      Ruiyun

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Ruiyun,

      can you send me a private message with your account name, so I can take a look. Thanks.

      br

      Stoyan

      Author's profile photo Former Member
      Former Member

      My account name is p1940151679trial.

      Thank you, Stoyan!

      Author's profile photo Bence Toth
      Bence Toth

      Hi,

      I had the same issue with Studio v58. As I am an SAP employee I could upgrade Studio to the latest build v69.

      It has solved both problems:

      - Popup from "inactive objects" has disappeared

      - "HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" has worked, _SYS_BIC schema & views are visible.

      IMO: Upgrade to latest available build from SDN (v60)

      Author's profile photo praveen Kodi
      praveen Kodi

      Hello SAP HANA Team,

      We are using SAP HANA Instance on Cloud Share. We are using windows platform for migrating source system (SQL Server 2008) to target system SAP HANA. But, for the last 3 days we are facing connection issues on Cloud share instance. We are not able to connect Cloud Share. So, we lost our production for the last 3 days.

      How to resolve the connection issues from Cloud Share to SAP HANA?

      Looking for best optimized solution.

      Best Regards,

      Praveen Kodi

      Author's profile photo Jordan Jordanov
      Jordan Jordanov

      Hi Praveen,

      Cloud Share Platform is not directly related to the SAP HANA Cloud.

      Unfortunatelly the names are getting similar and this can easily confuse you.

      In few words: Cloud Share, together with Amazon Web Services are providing IaaS, they give you a virtual image with pre-installed HANA DB.

      SAP HANA Cloud is PaaS where you can consume some of the existing Cloud services like the Document Service. You can create and run also Java Applications, it's not just the HANA DB Instance.

      Author's profile photo Johannes Haasen
      Johannes Haasen

      Hi Stoyan,

      thanks for this great blog!

      Is there any chance to create analytic views etc. on the neo.ondemand.com landscape?

      Author's profile photo Emil Aleksandrov
      Emil Aleksandrov

      Hi Johannes,

      For internal landscape as neo.ondemand.com you can already use the new tunnel connectivity and as well option to build and run HANA XS application.

      You can check internal documentation at https://wiki.wdf.sap.corp/wiki/display/NDW/Managing+Schemas and https://wiki.wdf.sap.corp/wiki/display/NDW/Database+Tunnel

      Please send internal email for additional help for neo.ondemand.com landscape.

      Best regards,

      Emil

      Author's profile photo Prajesh K
      Prajesh K

      Hello Stoyan,

         can we use this for PROD landscape (neo.ondemand.com) with own account? I tried to include the jar file to my application and deployed it in the server. But I couldn't find even the authorization role in the account page at my application level (role was included in the web.xml).

      Author's profile photo Emil Aleksandrov
      Emil Aleksandrov

      Hi Prajesh,

      Please see my reply to Johannes.

      Thanks,

      Emil

      Author's profile photo Ashok Kumar M
      Ashok Kumar M

      Hi Stoyan,

      Since the cloud platform is on top of HANA, can I access the HANA XS engine from cloud platform?

      If yes, could you please share some information?

      Best Regards,

      Ashok.

      Author's profile photo Stoyan Manchev
      Stoyan Manchev
      Blog Post Author

      Hi Ashok,

      currently this functionality is available on our internal landscape PROD(neo.ondemand.com).

      Emil Alexandrov have put links for the documentation in his comment above.

      Stoyan

      Author's profile photo Former Member
      Former Member

      AWESOME and Very Interesting.

      Thanks For sharing with Detail Steps

      Regards,
      Giri

      Author's profile photo Satya Sreenivasan
      Satya Sreenivasan

      Hi Stoyan

      I tried the above tutorial. I'm able to activate the calculation view and see the result of the SELECT query from HANA Studio, however, I am getting a 404 "Requested resource not found" error on running the application. Am I missing something?

      TIA

      Author's profile photo Manjunath Babu Rayampalli
      Manjunath Babu Rayampalli

      what is the solution for known limitation

      • Data Preview menu is not working from the SAP HANA Modeler or the SAP HANA Development perspective

      • as i am facing that for Attribute view while doing data privew, it says either project is not shared or your not connected to the DB.

      • Connection is there, i ahve crosschecked for same.

      • Any comments on this?
      Author's profile photo Vikas Madaan
      Vikas Madaan

      Hi,

      I am having productive instance on hana.ondemand.com. I am using both the options HANA studio and DB tunnel to connect to the HANA DB on Cloud.

      It is possible to open the DB tunnel in background. We are integrating client tools with HANA DB on Cloud. Command Promt looks odd to the users and not all the users have Studio installed on their local machine. I saw new open-db-tunnel has background option but it is not working for me. Please help.

      Thanks!

      Vikas

      Author's profile photo Former Member
      Former Member

      Great Source for beginners

      Author's profile photo Former Member
      Former Member

      Hi,

      This is Sunitha. How to get Tcodes of SAP CRM tables to work with SAP HANA calculation views.

      Author's profile photo Former Member
      Former Member

      hello,

      This is karunasree..can you please tell me the tcode to get all the sap tables

      Author's profile photo Former Member
      Former Member

      Hi

      What will be the MY_PACKAGE name in the code?
      I am little bit confused here. I gave the package name like:

      "p1940477959trial.hana066"

      Am I correct?

      Author's profile photo Jordan Jordanov
      Jordan Jordanov

      Hi Navneet,

      Indeed, it's confusing.

      You can always execute the query below to get the metadata relevant for your own dev user.

      SELECT * FROM "HCP"."HCP_DEV_METADATA"

      Package name is also returned.


      Best Regards

      Jordan

      Author's profile photo NISHANTH K
      NISHANTH K

      thank you helped a lot. very detail article.

      Author's profile photo Madhu Sudan Reddy B
      Madhu Sudan Reddy B

      Hi,

      I have account in hanatrail ondemnad - p1941559136trial. I created a HANA instance and want use the same in my local eclipse. So when try to do the same I am prompted with Account Id, User Name and Password. I am entering p1941559136trial as Account ID.

      What should be the user ID and PWD?  I used the credentials used to login to hana ontrial but does not work. Can you please help with this?

      Regards,

      Madhu

      Author's profile photo Gowrisankar M
      Gowrisankar M

      Your details should be like below,

      Account:p1941559136trial

      username:p1941559136

      password:scn password

      Author's profile photo Dionisio Ambrona
      Dionisio Ambrona

      Hi,

      I've managed to create my first calculation view in my SAP HANA Cloud instance following this blog, so many thanks for this: it allowed me to see the data modeling tools for HANA in Eclipse at last!

      However, now I have a problem just at the end of step 4, as the view seems OK but it retrieves no data, even when source tables do contain data that matches the join criteria. I have activated it and run OK the call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" procedure, but even so there is no data found.

      Also sentence:

      SELECT * FROM "_SYS_BIC"."s0007765223trial.mysaphanatrialinstance.hihana/SO_CV"

      finds no data.

      Any idea on what could be wrong?

      Thank you!

      Author's profile photo Gowrisankar M
      Gowrisankar M

      can you attach screenshot of your cal view and some more details to check

      Author's profile photo Dionisio Ambrona
      Dionisio Ambrona

      Hi Gowrisankar,

      thanks a lot for your help. Please find below the screenshots with the view details.

      Thank you!

      1.

      01_View_columns.jpg

      2.

      02_View_properties.jpg

      3.

      03_View_join.jpg

      4.

      04_View_no_data_found.jpg

      5.

      05_SNWD_BPA_data.jpg

      6.

      06_SNWD_SO_data.jpg

      Author's profile photo Dionisio Ambrona
      Dionisio Ambrona

      Hi,

      for step 5 I also have problems. The servlet run returns:

      Failed executing SQL: SELECT TOP 10 COMPANY_NAME, GROSS_AMOUNT, NET_AMOUNT FROM "_SYS_BIC"."s0007765223trial.hihana.web/SO_CV" ORDER BY GROSS_AMOUNT DESC

      Error message: Borrow prepareStatement from pool failed

      This I tried with different values for MY_PACKAGE, all of them failing:

      "s0007765223trial.s0007765223trial.hihana.web"

      "s0007765223trial.mysaphanatrialinstance.hihana"

      "s0007765223trial.hihana.web"

      Is it because the previous error of no data found in the view? Or maybe the MY_PACKAGE value is wrong? How can we know what is the right value for MY_PACKAGE?

      Thank you!

      Author's profile photo Dionisio Ambrona
      Dionisio Ambrona

      Hi,

      as that was not working, I created a new calculation view and subtituted it in the select in the servlet code. However, the response is again an error. On check the server log, I see the exception is "Could not find table/view in schema", but as screenshot shows the view is in that schema.

      I found this blog outside SCN that suggests a capital letter table name issue, but seems not the case. I will continue to investigate that thread in that blog for further options to solve this.

      http://stackoverflow.com/questions/29974507/sap-hana-invalid-table-name

      2016.01.07_View.not_found.jpg

      Comments are closed.