Sample application showcasing different services serving the same set of data entities from a sqlite database. The services match different use cases visualized in corresponding Fiori apps.

The easiest way to get started with devlopment of this project is inside a Docker Devcontainer. See this blog post for details.
If you don't have Docker installed you can of course develop within you local OS. But in that case you have to install all your tools and vs extensions on your own.

• get Node.js v16 or higher
• get sqlite (Windows only; pre-installed on Mac/Linux)
• As SAP has deprecated their own NPM registry please remove the setting in your npm config with the following command

npm config rm @sap:registry

Copy & paste this to your command line:

git clone https://github.com/gregorwolf/bookshop-demo.git
cd bookshop-demo
npm install
npm run setup

If you want to try also the external service calls, then you need to create a default-env.json file in the project root folder and add the following content:

{
  "destinations": [
    {
      "name": "ES5",
      "url": "https://sapes5.sapdevcenter.com",
      "username": "<your-ES5-username>",
      "password": "<your-ES5-password>"
    },
    {
      "name": "ERP",
      "url": "https://saperp.example.com",
      "username": "<your-ERP-username>",
      "password": "<your-ERP-password>"
    }
  ]
}

npm run build
npm start

If you want to test the used SAP Business Technology Platform - Cloud Foundry services you need also to add the VCAP*SERVICES variable to default-env.json. I.e.:

{
  "VCAP_SERVICES": {}
}

Before you can run the following commands you need to connect to the BTP Cloud Foundry environment using:

cf login -a <CF-API-Endpoint> -o <CF-Organization> -s <CF-Space> --sso

Then you can create or update an existing HDI using:

npm run deploy:hana

This should write the needed information to .cdsrc-private.json. When you have deployed the application already to BTP Cloud Foundry you can run:

cds bind -2 bookshop-demo-db-service --profile hybrid

to reuse the existing HDI container. Then you can use:

npm run test:hana

to start the test or you run

npm run start:hana

to start the app with SAP HANA Cloud as the database.

Open these links in your browser:

• http://localhost:4004/webapp/fiori.html – Fiori Launchpad sandbox

The services:

• JobService
• JobExecutionService

show a concrete example of the Late-Cut Microservices.

To get the two instances talk to each other you need to add the following entries in default-env.json:

{
  "destinations": [
    {
      "existing": "entries"
    },
    {
      "name": "job-service",
      "url": "http://localhost:4004",
      "username": "job",
      "password": "Secret1"
    },
    {
      "name": "job-execution-service",
      "url": "http://localhost:4005",
      "username": "job-execution",
      "password": "Secret2"
    }
  ]
}

To run this example locally you can run:

run-s "deploy:sqlite:instance:**"

to deploy two separate sqlite databases. You can start the two instances

npm run watchboth

First you need to create the HDI Containers using:

run-s "deploy:hana:instance:**"

Due to the issue reported at cds deploy does not support --profile the resulting configuration isn't written to the profiles defined with --profile. So you need to add this entries manually to your .cdsrc-private.json:

{
  "requires": {
    "[hybrid-instance1]": {
      "db": {
        "binding": {
          "type": "cf",
          "apiEndpoint": "<CF-API-Endpoint>",
          "org": "<CF-Organization>",
          "space": "<CF-Space>",
          "instance": "bookshop-demo-db-instance1",
          "key": "bookshop-demo-db-instance1-key",
          "resolved": false
        },
        "kind": "hana",
        "vcap": {
          "name": "db"
        }
      }
    },
    "[hybrid-instance2]": {
      "db": {
        "binding": {
          "type": "cf",
          "apiEndpoint": "<CF-API-Endpoint>",
          "org": "<CF-Organization>",
          "space": "<CF-Space>",
          "instance": "bookshop-demo-db-instance2",
          "key": "bookshop-demo-db-instance2-key",
          "resolved": false
        },
        "kind": "hana",
        "vcap": {
          "name": "db"
        }
      }
    },

Then you can start with:

npm run start:hybridboth

Use the REST Client scripts in tests/job.http.

cf create-service xsuaa application bookshop-demo-uaa -c xs-security.json
cf create-service-key bookshop-demo-uaa bookshop-demo-uaa-key
cf create-service xsuaa application bookshop-demo-instance2-uaa -c xs-security-instance2.json
cf create-service-key bookshop-demo-instance2-uaa bookshop-demo-instance2-uaa-key

cds bind -2 bookshop-demo-uaa
cds bind -2 bookshop-demo-instance2-uaa

We're using the mbt build to create a mtar that can be deployed to the SAP CP Cloud Foundry. The cf commandline must be installed and you have to be logged on to the space you want to deploy to. The build ist started with:

npm run build:cf

then you can deploy with:

npm run deploy:cf

If you need to redirect destinations according to your configuration you can achieve this by setting the environment variable CDS_CONFIG to this value:

{
  "requires": {
    "GWSAMPLE_BASIC": {
      "credentials": {
        "destination": "S4HANA"
      }
    },
    "API_CV_ATTACHMENT_SRV": {
      "credentials": {
        "destination": "S4HANA"
      }
    }
  }
}

We're using the mbt build to create a mtar that can be deployed to the SAP HANA. The xs commandline must be installed and you have to be logged on to the space you want to deploy to. The build ist started with:

npm run build:xsa

then you can deploy with:

npm run deploy:xsa

Manuel Seeger described the needed steps in Can't authenticate against HTML-Mashup embedded SCP application in C4C. Here are the concrete steps for this application:

cf create-service xsuaa apiaccess bookshop-access
cf create-service-key bookshop-access bookshop-access-sk
cf service-key bookshop-access bookshop-access-sk

Store the returned values as Key-Value Pairs in tests/.env. I.e.:

apiurl="https://api.authentication.us10.hana.ondemand.com"

Also add a variable for appurl which represents the app you want to enable to be embedded in an iFrame. Then run the REST Client Script tests/configure-xsuaa.http.

Carlos Roggan providedes a great description in his SAP Community blogpost: How to call protected app from external app as external user with scope. For the moment we will not use a separate client app but a REST client script. Follow the next steps to get it working for this project. Start of by creating a separate xsuaa service instance by running:

cf create-service xsuaa application xsuaaforclient -c xs-security-client.json

Then create and display a service key for this xsuaa:

cf create-service-key xsuaaforclient xsuaaforclient-sk
cf service-key xsuaaforclient xsuaaforclient-sk

Store the returned values as Key-Value Pairs for clientid, clientsecret, url in tests/.env. as:

clientid="sb-xsappforclientapp!dsjdfs"
clientsecret="NbFeh8ibk2zQ="
url="https://<your-trial-account>trial.authentication.eu10.hana.ondemand.com"
srvurl="https://<your-trial-account>trial-dev-bookshop-demo-srv.cfapps.us10.hana.ondemand.com"

Then open the REST Client script tests/api-access.http in VS Code and run the script with the comment Get Access Token (Cloud Foundry). It should return a valid access*token. Now execute the requests Read Orders and Read Books. You should see a valid result.

The services of this application use authentication and authorization to restrict usage of the functions.
The scopes of the app are defined in xs-security.json. They are used in the services files srv/cat-service.cds and srv/admin-service.cds.

Please have a look at these files for the restrictions cause they can change due to the POC character of this project

If you run the application in a local environment the users you can use are defined in the field .cdsrc.
Currently in this file the following users are defined

Please have a look at this file to see the current users and roles cause they can change due to the POC character of this project