SAP HANA Cloud and CAP to Build Full-Stack Applications Using VSCode
HTML-код
- Опубликовано: 2 авг 2024
- In this session we will develop a multi-target application using SAP Cloud Application Programming Model and SAP HANA Cloud. We will start from scratch and create a service layer and SAP Fiori UI that also includes SAP HANA native artifacts, such as calculation views. We will perform nearly all steps in VSCode but also see tips on how to use Git to move your project easily between VSCode and the SAP Business Application Studio.
This content is based upon the SAP Developer Tutorial Mission:
developers.sap.com/mission.ha...
And the CodeJam: github.com/SAP-samples/cap-ha...
The content is updated to highlight improvements made possible by CAP 6.0. In particular we will use the cds bind functionality to support hybrid testing. This means running and debugging the application locally but securely connecting to remove HANA and UAA instances running on SAP BTP.
Reference Information
- The prerequisite steps to install the environment locally is documented here: github.com/SAP-samples/cap-ha...
- All the VSCode Extensions I have installed and will be using today are documented here: github.com/SAP-samples/cap-ha...
- The tool that is adding the colored breadcrumb in the terminal (Oh-My-Posh): ohmyposh.dev/
- And an excellent introduction to Oh-My-Posh: www.hanselman.com/blog/my-ult...
- DJ's script to added status updates int he terminal as well: github.com/qmacro/dotfiles/bl...
- GitHub Desktop Client: desktop.github.com/
- SAP Cloud Application Programming Model Compositions: cap.cloud.sap/docs/guides/dom...
- SAP Cloud Application Programming Model Hybrid Testing: cap.cloud.sap/docs/advanced/h...
- Boosting tutorial UX with dev containers part 1 - challenge and base solution blogs.sap.com/2022/01/27/boos...
- WDI5 github.com/ui5-community/wdi5
- VSCode Development for SAP Cloud Application Programming Model Using Remote - WSL blogs.sap.com/2020/11/10/vsco...
- This project's DevContainer Docker example: github.com/SAP-samples/cap-ha...
- Automated Testing in CAP: cap.cloud.sap/docs/node.js/cd...
- More details about the app router user-api: www.npmjs.com/package/@sap/ap...
- CDS bind example that works in Powershell (suggested by Cemre Dogan): cds bind --exec -- {npm start --prefix approuter}
- Consuming Services in CAP: cap.cloud.sap/docs/guides/usi...
- Example from @SAPTechEdChannel Developer Keynote 2020 with service consumption via REST: github.com/SAP-archive/teched...
- Why developers should care about credential-types for xsuaa? blogs.sap.com/2022/07/05/why-...
- Application Security Descriptor Configuration Syntax help.sap.com/docs/BTP/65de297...
=============================================================================
CHAPTER TITLES
0:00 Intro
0:52 Dev Environment Setup
3:15 Verify HANA Cloud is Running
5:24 Create CAP Project
8:51 Explore the generated artifacts
11:32 Sync to Git
13:56 Create Database Artifacts Using Core Data Services (CDS) for SAP HANA Cloud
16:12 Deploy to HANA Cloud
20:48 Check the Database Explorer
24:04 Run Service Layer
25:20 Create a User Interface with CAP
27:20 Create a Fiori freestyle web interface
30:56 Add User Authentication
39:57 Create and grant roles
44:08 Test with Security
46:36 Create Calculation View
50:44 Create calculation view proxy entity
57:41 Create Stored Procedure
59:56 Implement Exit for Stored Procedure
1:02:10 Closing 
Наука
very in depth and in understandable language by TJ sir. Its very nice tutorial to begin with CAPM full stack development.
I can't seem to get generator-fiori to install on VS code any ideas why?
Hello Team, I have a query. When I deploy all the setup to SAP BTP, the Odata is not returning any output. I dont have any app router added to my project.
Can achieve same using managed approuter
I have followed this tutorial and deployed the application on cloud foundry environment. The UI is not visible when I click on Application Routes in the standalone app router application. Any help would be appreciated.
Please consider posting a question in the SAP Community Q&A. More details about what you have built and how it is structured would be needed.
Thanks for preparing this video. its really helpful.
The issue is, i have followed the full process without any issue but after executing the command "hana-cli dbx" browser open but I can not see the container which i have created using hana-cli.
I clicked on + button to ad but there is no container.
Could you please help?
Also i am getting Certification Expired error when executing "hana-cli createModule"
Thank you.
Perhaps it would be best if you enter an issue at the github repo github.com/SAP-samples/hana-developer-cli-tool-example
It's much easier to exchange information there.
For the Database Explorer, that is perfectly normal that you must add the container to the Database Explorer after opening it. It the plus button and search for your HDI container instance using the Cloud Foundry Org and Space where you created it.
Table details is not appearing in hana cloud HDI containers. Please help me for that.
Can you be more specific about what isn't appearing or at what stage. By table details do you mean you can't see the tables at all in the HDI container? Are they not filled with data? Are you looking at them in the Database Explorer? [Thomas Jung]
You have the same problem as what exactly? Original commentor never returned to describe the problem. You say you can use hana-cli dbx. Does that open Database Explorer? But then you have problems adding your HDI container to the explorer? Please describe what problem you are having.
what is HANA server you write in vscode
You can connect to any kind of HANA server from VSCode as long at the network allows the SQL port access. In this video I'm connecting to SAP HANA Cloud on SAP BTP.
@@sapdevs it always shows error like cant resolve host name
With HANA Cloud or an on premise HANA?
@@sapdevs HANA Cloud
please check this
I have followed the Add User Authentication to Your Application part and my response on the windows is: "Bad gateway"...Someone can help me?
If I use user-api/attributes it returns the correct data and scope...
Can you give a little more details around the Bad Gateway? What URL are you trying to access? You say the user-api URL works - so it seems your App Router is correctly setup and is connected to the XSUAA instance. Is it just having problems forwarding the request to the CAP service? Would need to know a little bit more about what you are seeing. [Thomas Jung]
@@sapdevs Its happening to me as well when I am running an application with 5000 port its giving a Bad Gateway error: in log 0#ERROR#/Handler#####1bcaa813-9de0-452e-b583-b8958f5ec417####GEgmxrqvQ8nYyAV9CviwKg6UjwLtjoGq######l8dulqes#PLAIN##GET request to / completed with status 502 error while forwarding request to localhost:4004/: connect ECONNREFUSED 127.0.0.1:4004 correlation_id = 1bcaa813-9de0-452e-b583-b8958f5ec417 stack: VError: error while forwarding request to localhost:4004/: connect ECONNREFUSED 127.0.0.1:4004
Do we need to run the cds watch --profile hybrid in another command prompt?
@@amarubhe2381 Yes that command needs to be ran from the command prompt.
Join us in this GitHub issue where we are trying to troubleshoot that error. github.com/sap-tutorials/Issues/issues/707
I've been unable to recreate the error - even when cloning the exact project from the original user reporting this. It runs fine in my account. Curious are you using BTP trial or free tier? [Thomas Jung]