sap-samples/hana-opensap-cloud-2020

Exercise materials for openSAP courses targeted to application developers, SAP HANA developers, Cloud Application Programming Model developers, and SAP Business Technology Platform developers.

hana-opensap-cloud-2020

The change log describes notable changes in this package.

Software Development on SAP HANA openSAP HANA7 Course Exercises Updated for SAP Business Technology Platform, SAP HANA Cloud, and Cloud Application Programming Model (January 2021) Inspired by both the HANA Native and Cloud Application Programming Model openSAP courses

• https://open.sap.com/courses/hana7
• https://open.sap.com/courses/cp7

Description

With the delivery of SAP HANA 2.0 SPS 05 and SAP HANA Cloud, we see many new features in both the underlying SAP HANA infrastructure and in the custom development aspects of SAP HANA native development. In this course, we’ll start from the assumption that students are familiar with the basics of the previous courses. This will allow us to dive deeper on key topics from real world applications. We’ll also cover new functionality added in SAP HANA 2.0 SPS 05 and SAP HANA Cloud, especially the evolution of the core programming model to focus on Cloud Application Programming Model.

Developers taking this course should be able to get up to speed quickly and begin leveraging these new features to enhance their own productivity, as well as tap into powerful new features of SAP HANA itself. Students will learn how to use Business Application Studio or Visual Studio Code to develop both HDI and XSA/CF-based applications for SAP HANA on-premise or on SAP Business Technology Platform.

We’ll also focus on real-world problems and opportunities such as:

• Cross-container and external reporting tool access to containers
• Realistic yet easier-to-maintain security setup
• The power of modern programming models
• SQL DDL-based database object creation
• New Cloud Application Programming Model concepts for service enablement and UI annotations and Fiori UI creation
• More open source components and techniques

Video series that goes along with this repo: https://youtube.com/playlist?list=PL6RpkC85SLQAHZ_V3cZsTok0T6BvI4HT1

Please come share your enhancement ideas directly via the project issues on this github repo.

Requirements

Basic programming knowledge including HTML, JavaScript, and SQL Baseline SAP HANA development knowledge from one of the previous SAP HANA courses on openSAP would be helpful The exercises in this course in this version/branch are primarily designed so that you can execute them on SAP Business Technology Platform and SAP HANA Cloud service as of July 2020. They have also been tested in SAP HANA 2.0 SPS 04 and SPS 05 with XSA on premise.

Download and Installation

SAP HANA Cloud trial startup instructions: https://developers.sap.com/tutorials/hana-cloud-deploying.html

• @sap Node.js packages have moved from https://npm.sap.com to the default registry https://registry.npmjs.org. As future versions of @sap modules are going to be published only there, please make sure to adjust your registry with:

npm config delete @sap:registry

Known Issues

None

How to obtain support

This project is provided "as-is": there is no guarantee that raised issues will be answered or addressed in future releases.

License

Copyright (c) 2024 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.

hana-opensap-cloud-2020's Issues

CDS deploy doesnt work

Processing "cfg/SFLIGHT.hdbgrants"...

Error: service ServiceName_1 not found; the service definition does not exist.

(0s 615ms)

[ERROR] [cds.deploy] - HDI deployment failed with exit code 1
at hdiDeployLib.deploy (/home/user/projects/hana-opensap-cloud-2020/node_modules/@sap/cds/bin/deploy/to-hana/hdiDeployUtil.js:92:35)
at ChildProcess. (/home/user/projects/hana-opensap-cloud-2020/db/node_modules/@sap/hdi-deploy/library.js:101:14)
at ChildProcess.emit (events.js:198:13)
at maybeClose (internal/child_process.js:982:16)
at Socket.stream.socket.on (internal/child_process.js:389:11)
at Socket.emit (events.js:198:13)
at Pipe._handle.close (net.js:607:12)

developers.sap.com tutorial help

Hi Thomas,

I followed up the tutorial from here.
https://developers.sap.com/mission.hana-cloud-cap.html

Everything is working well. I just wonder if there is an existing tutorial which is focusing on the production deployment for a similar CAP-HANA project like this.

Appreciated in advance.

Reuse Content from CAP/HDI in SAC or other external reporting

Yes this is already included in the sample model and we will definitely do a future live stream that shows it. I've also done some blogs in the past that touched on this topic as well - but we will revisit in the scope of the new HANA Cloud once I can demo it all there via the brand new trial.

Case in filenames causes cds build to fail

Originally developed on a Windows file system (not case sensitive) some of the CDS files contained mixture of upper/lower case that caused CDS BUILD to fail.

CDS 3.34.3 introduces changes to handling of CSV load files

Faster generation of hdbtabledata files from csv data. It no longer tries to check the existence of element or column names. Such checks are anyways done during SAP HANA deployment. This behavior is now symmetrical to SQLite deployment.

-- I just found out the hard way that this means that if you have extra columns in your CSV it doesn't ignore them any longer but sends them to HANA which then errors out. If anyone has CAP examples watch out for this recent change.

The file requires "db://dummy" which is not provided by any file [8212001]

on "Part 6: Cross Container", I got the following error when executing "npm start" at "user_db" folder, I removed the user_db instance, repeated over all steps, but still getting the same error. Thanks in advance!
++++++++++++++++++++++++++++++++++++++HERE IS THE ERROR+++++++++++++++++++++++++
Merging... ok (0s 6ms)
Error: The file requires "db://dummy" which is not provided by any file [8212001]
at "src/procedures/initTestUsers.hdbprocedure" (14:43-50)
Error: Could not compose a consistent make graph [8212012]
Error: Calculating dependencies... failed [8212108]
Make failed (4 errors, 0 warnings): tried to deploy 1 files, undeploy 1 files, redeploy 0 dependent files
Error: Making... failed [8211605]
Error: Starting make in the container "D2F5E68C36AF4C4B894C22E557F03013" with 1 files to deploy, 1 files to undeploy... failed [8214168]
Deployment to container D2F5E68C36AF4C4B894C22E557F03013 failed - error: HDI make failed [Deployment ID: none].
Error: HDI make failed
++++++++++++++++++++++++++++++++++++++

Adapt to UI5 development in Business Application Studio

Adapt configuration files for UI5 module based upon https://blogs.sap.com/2020/07/08/migrating-fiori-application-from-sap-web-ide-to-sap-business-application-studio/

Integrate with workflow

I'm not sure if this is still being worked on but something I would love to see (and have struggled) with is the best way to integrate a cap applications with the workflow service.
Lets say for example when a user creates a new entity in the UI I want to trigger a workflow for approval in certain cases.

I can see a couple of potential ways to do this:

1. Fire a message to the enterprise messaging service to decouple the action. then have that start a workflow. As it turns out you can't call a rest api and provide a payload from enterprise messaging so this would also require CPI to source messages from the enterprise-messaging queue and convert them to the appropriate rest call to start a workflow instance.

2. From the CAP service layer call the workflow instance api. I'm using cds.connect.to here and workflow.tx(req).post(...) but it doesn't work an there seems to be no log or error message about it

3. Call the workflow instance api directly from javascript in the fiori app. This seems more of a clunky way of doing it though.

What would be the best practice way to go here... Would be great to see some integration between CAP and workflow.

Best practice CAP - UI and Services as separate projects

Hi Tom/Rich

Love the Repo - thanks for making this available early.

I've been trying to work out the best way to break up a CAP project into a services project srv/db, and then have the UI (or multiple) as independent UI projects. What I think I want is the UI Annotations in the UI Project and not with the services - keeping the concerns separated - maybe this isn't right or not possible? . I'm just not entirely clear on how to set up the dependencies so the annotations can see the services at design time. I've seen the mono repo that the CAP examples are in and can see how that works - is this best practice or are there other ways??

I kind of see this as a natural separation between the CAP tooling and the UI5 Tooling so the UI5 team are doing "ui5 serve" etc rather than cds watch/serve etc..?
Thoughts?

Thanks guys
Al

Import updated SQLScript examples from recent Developer Center Tutorials

Update and include the newly refreshed SQLScript examples in this project as well

How do i trace a cap app where the time is sink

@albertlast
about performance how do i trace a cap app where the time is sink? is the business logic the elephant in the room or is the cds/db modell a bottleneck, how do i know what sql command got sended to the db that i could run a vizplan on this?

Multitenancy with CAP via using schema separation

When a SaaS solution developed, multitenancy by schema separation seems like one of the most optimal solution for us in terms of isolation and cost.

That would be great to have an example of that.

CAP Consume external service

Although there is a message producer example already, there was a request from the live stream to include consumption of an external service as well.

Pedro Correia
​It would be fun to see different SAP CAP apps interacting with each other using services or queuing messages
https://www.youtube.com/watch?v=XLPNWOTCKdM

Build Python Application Using CAP

Hi I am a data scientist and many times I have to work with building a python application with HANA Cloud Service. How can I develop a single project structure that has both python and HANA development artifacts using CAP.

[APP/PROC/WEB/0] npm ERR! missing script: start

i tried numerous times, but i keep getting this error and the app is crashing in trial account:

[APP/PROC/WEB/0] npm ERR! missing script: start

when running this command in Business Application Studio:

cf push hana-opensap-cloud-2020

[BUG] Link to Youtube Video is private

Tried to follow the link in the README section to this video but it is marked as private: https://github.com/SAP-samples/hana-opensap-cloud-2020/blame/main/README.md#L29. I assume it should be publicly available, right?

Feature Flags/Staged Rollout

@albertlast
choose random people for new stuff: it's common when i do big changes that i do on one click and every user get the new version that leads me in the issue, when one problem exists, not one user got the problem, all got the problem, so i would likely do a "ramp up" release so that first 1% of my userbase get "new stuff" and go this up step by until 100%, is there any cap feature how help me do realize this ramp up?

Different ui framework, like vue.js, react etc. on cds model

@albertlast

Since we got break out point in cap,
i would like to see how setup a different ui framework, like vue.js, react etc. on cds modell

issue with metadata for V2 model

Hi Team,

I am getting error while retrieving metadata for V2 support. My server.js file

const cds = require('@sap/cds') const Sdk = require('@dynatrace/oneagent-sdk') const DynaT = Sdk.createInstance() const proxy = require('@sap/cds-odata-v2-adapter-proxy') console.log(DynaT.getCurrentState()) console.log(CDS Custom Boostrap from /srv/server.js`)
global.__base = __dirname + "/"
process.on('uncaughtException', function (err) {
console.error(err.name + ': ' + err.message, err.stack.replace(/.*\n/, '\n')) // eslint-disable-line
})

const TextBundle = require("@sap/textbundle").TextBundle
// global.__bundle = new TextBundle("../_i18n/i18n", require("./utils/locale").getLocale())

cds.on('bootstrap', app => app.use(proxy()));
cds.on('served', () => {
// add more middleware after all cds servies
})

// delegate to default server.js:
module.exports = async (o) => {
o.port = process.env.PORT || 4001
//API route (Disabled by default)
// o.baseDir = process.cwd()
o.baseDir = global.__base;
o.routes = []

const express = require('express')
let app = express()
app.express = express
// app.baseDir = process.cwd()
app.baseDir = o.baseDir;
o.app = app    
const path = require('path')
const fileExists = require('fs').existsSync
let expressFile = path.join(app.baseDir, 'server/express.js')
if (fileExists(expressFile)) {
    await require(expressFile)(app)
}

//V2 fallback
cds.serve('POService')
    .from(global.__base + "/gen/csn.json")
    .to("fiori")
    .at('/POService').in(app)
    .catch((err) => {
        app.logger.error(err);
    })

cds.serve('MasterDataService')
    .from(global.__base + "/gen/csn.json")
    .to("fiori")
    .at('/MasterDataService').in(app)
    .catch((err) => {
        app.logger.error(err);
    })

o.app.httpServer = await cds.server(o)

const glob = require('glob')
//Load routes
// let baseDir = process.cwd()
let routesDir = path.join(global.__base, 'routes/**/*.js')
let files = glob.sync(routesDir)
this.routerFiles = files;
if (files.length !== 0) {
    for (let file of files) {
        await require(file)(app, app.httpServer)
    }
}


return o.app.httpServer

}

// const cds = require("@sap/cds");
// const proxy = require("@sap/cds-odata-v2-adapter-proxy");

// cds.on("bootstrap", app => app.use(proxy()));

// module.exports = cds.server;`

Full-stack application without HDI containers

Suggestion from YouTube Comment from user naga prakash

Could you please make a video on ull-stack application without HDI containers. Especially on authentication/authorization on SAP HANA DB with SCP login credentials

HANA Geospatial data types in CAP

From livestream https://www.youtube.com/watch?v=XLPNWOTCKdM
Henrik Damhøj Andersen
​Any plans for including SAP HANA native geospatial content?

CAPM-based multiteant business applications with the HDI-Container separation approach.

SaaS / Multitenant Business Application / DB schema separation approach with CAPM.

Benchmark/loadtest

@Alberlast
how to benchmark/loadtest my app, i mean ther exists many solution where i can create/measure such the thing, but what would you/sap recommend, witch stages should be targeting? full load test at the odata endpoint and the we are done or what stages could/should i test?

Collection of enhancement

Well i'm not sure if i should open for every idea an own issue or one,
so i decide to open one with all my ideas and could open a new when a idea is good/need more details.

• Since we got break out point in cap,
  i would like to see how setup a different ui framework, like vue.js, react etc. on cds modell

• Javascript is very good since i can used on frontend, backend and his async nature,
  but it's not typesafe like java, so the best mix of both would be typescript in my eyes,
  could you add example here how to integrate a typescript nodejs part

• my "home zone" of database is in pg env, there exists an own datatyp for ip address,
  this allow me to save ipv4 and ipv6 in one field, so i can log stuff search for ip address ranges etc.
  maybe you could add to the db model how you recommand this kind of data and how to interact with this

• in my work i see some kind of need to realize a "complex hybrid" scenario where some kind of my app work on premise on hana, and some is running in scp, here would be nice to get a guidence or thoughts how the app could be slice,
  exp. should the on premise env provide some db services and middleware logic should be complet in scp or should be both side got some middleware logic and the approuter (on premise or scp (could we had both at the same time?) do use both middleware)

• the "transport" logic from dev to higher tier(like test or productiv) env get always a question mark over my head, how to handle with existing data,
  sometime i could reset the data some other i don't want to drop my member table every time when push a new version of my app db more likely that i wanted to define a conversion in this case, this in mind with a cds approach
  or how to handle changes on the template roles

• how to benchmark/loadtest my app, i mean ther exists many solution where i can create/measure such the thing, but what would you/sap recommend, witch stages should be targeting? full load test at the odata endpoint and the we are done or what stages could/should i test?

• about performance how do i trace a cap app where the time is sink? is the business logic the elephant in the room or is the cds/db modell a bottleneck, how do i know what sql command got sended to the db that i could run a vizplan on this?

• choose random people for new stuff: it's common when i do big changes that i do on one click and every user get the new version that leads me in the issue, when one problem exists, not one user got the problem, all got the problem, so i would likely do a "ramp up" release so that first 1% of my userbase get "new stuff" and go this up step by until 100%, is there any cap feature how help me do realize this ramp up?

• i guess the question came up already in the stream, but how do i integrate my app data into sac?

Feel free to close the issue when nothing hit you interess.

Create sample which is using (or used by) Job Schedule Service.

Job Schedule Service is available both on XSA and CF. Would be nice to have a simple example.

Currency files (hdbview etc.) are missing after cds build

Like commented on youtube, the currency files (hdbview etc.) are note created after doing a cds build.
Link to my repo: https://github.com/schoesa/hana-opensap-cloud

Any ideas whats wrong in my code? Appreciate your help.

The "transport" logic from dev to higher tier(like test or productiv) env get always a question mark over my head, how to handle with existing data,

@albertlast

The "transport" logic from dev to higher tier(like test or productiv) env get always a question mark over my head, how to handle with existing data,
sometime i could reset the data some other i don't want to drop my member table every time when push a new version of my app db more likely that i wanted to define a conversion in this case, this in mind with a cds approach
or how to handle changes on the template roles

how to integrate a typescript nodejs part

@albertlast
Javascript is very good since i can used on frontend, backend and his async nature,
but it's not typesafe like java, so the best mix of both would be typescript in my eyes,
could you add example here how to integrate a typescript nodejs part

Consumption of S4/HANA in CAP/HANA Cloud

Following on from the call for suggestions in Thomas's "Help Shape A New SAP HANA CAP Sample" video.

We have been building a project internally based on CAP and Fiori which involves consumption of data from S4/HANA. Currently we are using Smart Data Integration (SDI) to achieve this, however I have noticed a number of limitations to this approach. For example, using the SDI HanaAdapter driver does not appear to support exposing ABAP CDS views through to HANA Cloud.

Another issue we ran into was the inability to call ABAP functionality over RFC, as it appears the node-rfc package does not currently support Cloud Foundry (See SAP/node-rfc#145)

It would be good to get some direction from SAP on what the best practice for implementing solutions that involve consumption of data and logic from S4/HANA systems (and S4/HANA Cloud too?) as it seems a lot of the current documentation and example solutions focus more on standalone solutions, where as we see a lot of value in being able to provide solutions that can work alongside existing S4/HANA systems.

Being able to augment and enrich the S4/HANA experience and allowing customers to "dip their toes" into the Cloud Foundry landscape, offers a tremendous value add without requiring the same level of commitment to the environment as a fully standalone solution would (Especially with with the option of pay as you go billing for the BTP services).

In my work i see some kind of need to realize a "complex hybrid" scenario where some kind of my app work on premise on hana, and some is running in scp

@albertlast

in my work i see some kind of need to realize a "complex hybrid" scenario where some kind of my app work on premise on hana, and some is running in scp, here would be nice to get a guidence or thoughts how the app could be slice,
exp. should the on premise env provide some db services and middleware logic should be complet in scp or should be both side got some middleware logic and the approuter (on premise or scp (could we had both at the same time?) do use both middleware)

VError: No service matches uaa / How to cds run / build / watch / serve / cf push -f srv/gen

Hello,

thank you for your very nice repository. I did follow the exercises of the openSAP hana7 course and did actually build the github repository hana-xsa-opensap-hana7 on my HANA express.
As I found it most useful I am now trying to clone and build the hana-opensap-cloud-2020 repo into my SAP BTP trial account with a HANA cloud trial database.

Up until now I have done everything stated in the install-all-prerequsites.md file, meaning I have successfully installed SFLIGHT, executed all SQL commands and created the CUPS_FLIGHT user with roles, and also executed all CF commands for creating the HDI containers, UPS for SFLIGHT schema, HTTP UPS and UAA.

I also reproduced some instructions from https://blogs.sap.com/2021/01/21/building-hana-opensap-cloud-2020-part-2-project-setup-and-first-db-build/ which seemed to be helpful.

My database is now successfully deployed to the HANA cloud and the user provided services seem to work. I can deploy the DB module using the small rocket icon in the BAS and also jump from the BAS into the respective HDI containers. From the database perspective everythin seems to be in order.

As I read in your reply #18 (comment) where you are stating that the most easy way to test a module would be to do

cds run or cds watch

I have also tried

npm start

Unfortunately nothing works as I always get an error which can be most easily reproduced by executing npm start

There seems to be something regarding the UAA.

Here is the error:

user: hana-opensap-cloud-2020 $ npm start
npm WARN lifecycle The node binary used for scripts is /extbin/bin/node but npm is using /opt/nodejs/node-v14.16.0-linux-x64/bin/node itself. Use the --scripts-prepend-node-path option to include the path for the node binary npm was executed with.

[email protected] start /home/user/projects/hana-opensap-cloud-2020
cds run

2
/home/user/projects/hana-opensap-cloud-2020/srv/
CDS Custom Boostrap from /srv/server.js
#2.0#2021 06 10 16:21:45:916#+00:00#WARNING#/LoggingLibrary################PLAIN##Dynamic log level switching not available#
[ERROR] VError: No service matches uaa
at Object.getServices (/home/user/projects/hana-opensap-cloud-2020/node_modules/@sap/xsenv/lib/xsservices.js:50:15)
at module.exports (/home/user/projects/hana-opensap-cloud-2020/srv/server/expressSecurity.js:31:57)
at module.exports (/home/user/projects/hana-opensap-cloud-2020/srv/server/express.js:14:33)
at module.exports (/home/user/projects/hana-opensap-cloud-2020/srv/server.js:45:35)
at serve (/home/user/projects/hana-opensap-cloud-2020/node_modules/@sap/cds/bin/serve.js:174:24)
at Object.cds_run (/home/user/projects/hana-opensap-cloud-2020/node_modules/@sap/cds/bin/run.js:23:12)
at Object.exec (/home/user/projects/hana-opensap-cloud-2020/node_modules/@sap/cds/bin/cds.js:19:17)
at Object. (/home/user/projects/hana-opensap-cloud-2020/node_modules/@sap/cds/bin/cds.js:97:26)
at Module._compile (internal/modules/cjs/loader.js:1063:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] start: cds run
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /home/user/.npm/_logs/2021-06-10T16_21_46_115Z-debug.log

Here is the debug.log:

0 info it worked if it ends with ok
1 verbose cli [
1 verbose cli '/opt/nodejs/node-v14.16.0-linux-x64/bin/node',
1 verbose cli '/usr/local/bin/npm',
1 verbose cli 'start'
1 verbose cli ]
2 info using [email protected]
3 info using [email protected]
4 verbose run-script [ 'prestart', 'start', 'poststart' ]
5 info lifecycle [email protected]prestart: [email protected]
6 info lifecycle [email protected]start: [email protected]
7 warn lifecycle The node binary used for scripts is /extbin/bin/node but npm is using /opt/nodejs/node-v14.16.0-linux-x64/bin/node itself. Use the --scripts-prepend-node-path option to include the path for the node binary npm was executed with.
8 verbose lifecycle [email protected]start: unsafe-perm in lifecycle true
9 verbose lifecycle [email protected]start: PATH: /opt/nodejs/node-v14.16.0-linux-x64/lib/node_modules/npm/node_modules/npm-lifecycle/node-gyp-bin:/home/user/projects/hana-opensap-cloud-2020/node_modules/.bin:/home/user/.node_modules_global/bin:/extbin/bin:/extbin/npm/docker/bin:/extbin/npm/globals/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/curl/bin
10 verbose lifecycle [email protected]start: CWD: /home/user/projects/hana-opensap-cloud-2020
11 silly lifecycle [email protected]start: Args: [ '-c', 'cds run' ]
12 silly lifecycle [email protected]start: Returned: code: 1 signal: null
13 info lifecycle [email protected]start: Failed to exec start script
14 verbose stack Error: [email protected] start: cds run
14 verbose stack Exit status 1
14 verbose stack at EventEmitter. (/opt/nodejs/node-v14.16.0-linux-x64/lib/node_modules/npm/node_modules/npm-lifecycle/index.js:332:16)
14 verbose stack at EventEmitter.emit (events.js:315:20)
14 verbose stack at ChildProcess. (/opt/nodejs/node-v14.16.0-linux-x64/lib/node_modules/npm/node_modules/npm-lifecycle/lib/spawn.js:55:14)
14 verbose stack at ChildProcess.emit (events.js:315:20)
14 verbose stack at maybeClose (internal/child_process.js:1048:16)
14 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
15 verbose pkgid [email protected]
16 verbose cwd /home/user/projects/hana-opensap-cloud-2020
17 verbose Linux 5.4.0-5-cloud-amd64
18 verbose argv "/opt/nodejs/node-v14.16.0-linux-x64/bin/node" "/usr/local/bin/npm" "start"
19 verbose node v14.16.0
20 verbose npm v6.14.11
21 error code ELIFECYCLE
22 error errno 1
23 error [email protected] start: cds run
23 error Exit status 1
24 error Failed at the [email protected] start script.
24 error This is probably not a problem with npm. There is likely additional logging output above.
25 verbose exit [ 1, true ]

These are my service instances (I don't think the error is due to the red update failed label as the error persisted before the last update failed):

I have already experimented a lot with the name of the uaa-service in the mta.yaml in order to have it match the instance name in my BTP trial account. But I could not figure it out.
Would you be so kind to give me a hint where to look at?

my "home zone" of database is in pg env, there exists an own datatyp for ip address

@albertlast
my "home zone" of database is in pg env, there exists an own datatyp for ip address,
this allow me to save ipv4 and ipv6 in one field, so i can log stuff search for ip address ranges etc.
maybe you could add to the db model how you recommand this kind of data and how to interact with this

[rl-vulnerability_alerts-1] Violation against OSS Rules of Play

The OSPO bot created this issue by mistake - It did not have enough priviledge to check the vulnerability alerts, So I am closing this issue now. Sorry for any inconvenience.

loads/common directory structure doesn't work with cds-dk 2.0.7 for csv files

I talk about this yt video https://www.youtube.com/watch?v=EJrKRQyULsw (got no account to comment directly below...)

I try to copy your structur for csv files, db/loads/common,
but notice that my table keep empty.
in next stept i checked the cds build output:

[cds] - determining build tasks for project [/home/user/projects/cap].
   {
     "build": {
       "target": ".",
       "tasks": [
         {"for":"hana", "src":"db", "options":{"model":["db","srv"]}},
         {"for":"node-cf", "src":"srv", "options":{"model":["db","srv"]}}
       ]
     }
   }

[cds] - building project [/home/user/projects/cap], clean [true]
[cds] - cds [4.1.5], compiler [1.35.0], home [/home/user/.node_modules_global/lib/node_modules/@sap/cds-dk/node_modules/@sap/cds]


[cds] - done > wrote output to:
  db/src/gen/.hdiconfig
  db/src/gen/.hdinamespace
  db/src/gen/Base.hdbtable
  db/src/gen/iso_countries_regions.hdbview
  db/src/gen/iso_us_states.hdbview
  db/src/gen/iso_us_states_and_territories.hdbview
  db/src/gen/localized.iso_countries_regions.hdbview
  db/src/gen/localized.sap.common.Countries.hdbview
  db/src/gen/localized.sap.common.Currencies.hdbview
  db/src/gen/localized.sap.common_countries.Regions.hdbview
  db/src/gen/sap.common.Countries.hdbtable
  db/src/gen/sap.common.Countries_texts.hdbtable
  db/src/gen/sap.common.Currencies.hdbtable
  db/src/gen/sap.common.Currencies_texts.hdbtable
  db/src/gen/sap.common_countries.Regions.hdbtable
  srv/gen/_i18n/i18n.json
  srv/gen/csn.json


[cds] - build completed in: 612.308ms

no csv files mention,
than i move one csv file to the loads directory, no change.
renamed loads to csv with the result:

[cds] - determining build tasks for project [/home/user/projects/cap].
   {
     "build": {
       "target": ".",
       "tasks": [
         {"for":"hana", "src":"db", "options":{"model":["db","srv"]}},
         {"for":"node-cf", "src":"srv", "options":{"model":["db","srv"]}}
       ]
     }
   }

[cds] - building project [/home/user/projects/cap], clean [true]
[cds] - cds [4.1.5], compiler [1.35.0], home [/home/user/.node_modules_global/lib/node_modules/@sap/cds-dk/node_modules/@sap/cds]


[cds] - done > wrote output to:
  db/src/gen/.hdiconfig
  db/src/gen/.hdinamespace
  db/src/gen/Base.hdbtable
  db/src/gen/csv/sap.common-Currencies.csv
  db/src/gen/csv/sap.common-Currencies.hdbtabledata
  db/src/gen/iso_countries_regions.hdbview
  db/src/gen/iso_us_states.hdbview
  db/src/gen/iso_us_states_and_territories.hdbview
  db/src/gen/localized.iso_countries_regions.hdbview
  db/src/gen/localized.sap.common.Countries.hdbview
  db/src/gen/localized.sap.common.Currencies.hdbview
  db/src/gen/localized.sap.common_countries.Regions.hdbview
  db/src/gen/sap.common.Countries.hdbtable
  db/src/gen/sap.common.Countries_texts.hdbtable
  db/src/gen/sap.common.Currencies.hdbtable
  db/src/gen/sap.common.Currencies_texts.hdbtable
  db/src/gen/sap.common_countries.Regions.hdbtable
  srv/gen/_i18n/i18n.json
  srv/gen/csn.json


[cds] - build completed in: 591.683ms

so the "root" csv file got picked up, but the others ones how are in db/csv/common not,
in the manuel https://cap.cloud.sap/docs/ i didn't found any hints in the change log if this behavior got changed and
see no config parameter to enforce this behavior.

or the source of the issue is me, for this case i attached my project file:
cap.zip

​Calling an external API from Azure

From the livesteam
Robert Eijpe
​Calling an external API from Azure
https://www.youtube.com/watch?v=XLPNWOTCKdM