Converting Existing SAP HANA Project to Cloud Application Programming Model

In this video we will demonstrate a low effort approach to convert an existing HANA project to the CAP project type. And instead of re-creating all the DB artifacts in CAP natively we will show how to create views and proxy entities to run on top of the existing database artifacts. Finally as a little bonus content at the end we will show how to implement exit handlers (often needed when coming from XSODATA), OData V2 support (also sometimes needed for backwards compatibility with XSODATA) and adding both REST and openAPI/SwaggerUI support to your CAP project.

All the source code for this video can be found here:

0:00 Introduction
1:29 Existing HANA only Project
5:29 Convert Project type to CAP
10:14 Create CAP Proxy Entities
12:15 hana-cli inspectView
14:45 Deploy to HANA Cloud
16:46 Add CAP service
19:38 Test the service
21:08 Bonus Content
22:16 Bonus Custom Bootstrap
23:00 Bonus OData V2
23:28 Bonus Pure REST endpoint
24:04 Bonus Custom Exit Handlers
26:12 Bonus Test extra features
28:25 Bonus SwaggerUI
30:34 Closing

[AK-okjh]

Wish you have any single place from where i can get all the commands you used in terminal from the video starting, i am also wondering if hana-cli command will work in SAP BAS as well?

Although it was great Learning from this video, Thanks a lot Thomas you are superman of SAP Development 😄

[vriesvd]

Great blog Thomas, helpes me a lot. I have a question. In the service-app (PROJECT_NAME-srv), the service endpoint is /odata/v4/po. Is there any way that I can change the 'po'-part to anything else, e.g. /odata/v4/content

[ds]

can i implement capm project model like calling HANA procedures as function in web ide on premise. Can i declare function functionname() return String and implement the function in the handler in web ide on premise . Also can HANA procedure be called in OData V4 and not as REST call.