Online Tutorial – SAP HANA Native Development via Web IDE
Based on the already announced Quick Start PDF tutorial and SCN Blog by Bertram Ganz I share here the corresponding Web IDE online tutorial (use Firefox or Chrome web browser)
SAP HANA Web IDE online Tutorial
Prerequisite:
You have development access to a SAP HANA SPS 07 Database Revision 73 system
For the tutorial you need your SAP HANA Database User/Password and HANA XS Web Server URL.
Note: If you don’t have access to a SAP HANA SPS 07 Database Revision 73 system then you can get a Free HANA Trial System on SAP HANA Cloud Platform as described in my other SCN Blog
Execute Tutorial:
Open with Firefox or Chrome web browser: https://thewebide.hana.ondemand.com/tutorials/onpremise/ and follow the instructions there.
How does the tutorial work?
1. Enter a few setting in the online tutorial (e.g. your SAP HANA Database User)
2. With these settings start the tutorial
3. Execute step by step the short instructions with the pre-configured code snippets according to your settings.
4. Develop step by step the HANA XS PersonsList application on your SAP HANA System by means of SAP HANA Web IDE
Questions and Feedback?
I really appreciate your questions or feedback.
Please add your comments below.
Great job Jens,
as I have access to this earlier can share that the "Step by Step" approach that you implement is easy and straight forward.
Do you have any clue when Web IDE will reach developers with trial accounts?
Best,
Dobri
Hi Dobromir,
Thanks for your comments.
The Web IDE tool on HANA Trial instances of SAP HANA Cloud Platform will hopefully come "very soon".
I've almost finished the corresponding online tutorial for these trial instances as well and I intend to also publish it on SCN as soon as the Web IDE will be available on Trial HANA Cloud Platform.
Best regards,
Jens
Hi Jens,
Is it possible to render a login screen , prior to using web ide to access repositories on HANA.
Thanks
Anil
Hi Anil,
we clarified offline that it is possible to use your HANA System (here rev 73) base URL (http://<server-host>:<server:port>) and when pointing this to the Web IDE Editor http://<server-host><serverport>/sap/hana/xs/ide/editor/ you get the intended Log-on screen.
Basically that answered your question.
Best regards,
Jens
Hi Dobri,
As I wrote in my additional note in the above blog:
The Web IDE tool is available now for Free HANA Trial instances on SAP HANA Cloud Platform and a corresponding Web IDE online tutorial has been published here:
https://thewebide.hana.ondemand.com/tutorials/hcptrial
(Launch URL in Firefox or Chrome only)
Best regards,
Jens
Great job Jens!
Hi Jens,
Very nice tutorial....easy to follow. i was trying the on-premise version...
and got stuck at one place.. when i try to activate my hdbdd file... it says ->
The CDS metadata schema is inconsistent. Please contact your system administror.
Hi Ranju,
Check whether the schema name you used in your file is created or not. .?
Regards
Krishna Tangudu
Hi Krishna, thanks for replying... the schema is created successfully,saved n activated.
not sure if this is something to do with privileges?
Regards,
Ranju
Hi Ranju,
You found an answer?
Hello Krishna, yes that was an issue with the system which i was using for my development... it did not have the latest build from CDS development...
thanks for checking 🙂
Regards
Ranju
Hi,
I am getting an error while executing the below SQL query at step 13.
call HCP.HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS() Am
Statement: 'call HCP.HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS()'.Error calling procedure: insufficient privilege: [258] "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS": line 45 col 14 (at pos 2187): [258] (range 3) insufficient privilege exception: insufficient privilege: Not authorized
Am I missing anything?
privileges. Look at the message... insufficient privilege exception: insufficient privilege: Not authorized
step 21 in the tutorial cause error when run server f8:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<service xml:base="https://s8hanaxs.hanatrial.ondemand.com:443/s0000241042trial/dev/perslist/services/pers.xsodata/" xmlns="http://www.w3.org/2007/app" xmlns:app="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom"><workspace><atom:title>Default</atom:title><collection href="Persons"><atom:title>Persons</atom:title></collection></workspace></service>
please help.
Nick
Hi Nick Scherer,
sorry for my late response.
Your output looks exactly what I expect when you launch the OData service!
Add /Persons?$format=xml at the end of the launched URL (as mentioned in step 21 substep 5) and then you should get the available person entities as OData output.
Hope that helps.
Best regards,
Jens