Skip to Content
Technical Articles
Author's profile photo Dhanasupriya Sidagam

SAP Cloud Application Programming Model – Demo6

Hello All

Here is my blog post on how to connect SAP Cloud Application Programming model application to SQLite Database using SAP Business Application Studio IDE.

Please read and suggest your inputs to my earlier blogs on SAP CAPM:

In this post, i have created the SAP CAPM application following the steps from blog:

Once the project is created, check the output by running the command cds watch in terminal.

Follow the below steps to connect our SAP CAPM application to SQLite Database.

Run the command cds deploy –to sqlite:studentreport.db from terminal.

This adds studentreport.db to our project structure.

Also check the added db details in package.json file.

Open File > Settings > Open Preferences:

Search for Sqltools and click on settings.json:

Add this object to connections in settings.json file.

 "sqltools.connections": [
            "name" : "SQLite",
            "dialect": "SQLite",
            "database": "/home/user/projects/studentreport/studentreport.db"

Check the connections in SQLTools.

Expand the connected Database and check for the data records.

We can insert, check the query details and play around the feasible SQL operations.

Please use comment box..

Thank you!! 🙂


BR//Dhanasupriya Sidagam

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo vasundhara lella
      vasundhara lella

      How to get Cloud HANA database to the local system?

      Author's profile photo Dhanasupriya Sidagam
      Dhanasupriya Sidagam
      Blog Post Author

      Will do a post on it..

      Author's profile photo Praveen Thimma Reddy
      Praveen Thimma Reddy

      Dhanasupriya Sidagam

      When I try to click on connect, SAP Application studio tells me "You need to install "sqlite3@4.1.1" to connect to sqlite - bookshop." but when I click on Install Now, then I get below mentioned error.

      Failed to install dependencies for SQLite: Request DependencyInstaller/install failed with message: > sqlite3@4.1.1 install /tmp/vscode-unpacked/sqltools-0.21.8.vsix/extension/node_modules/sqlite3 > node-pre-gyp install --fallback-to-build sh: 1: node-pre-gyp: not found npm ERR! code ELIFECYCLE npm ERR! syscall spawn npm ERR! file sh npm ERR! errno ENOENT npm ERR! sqlite3@4.1.1 install: node-pre-gyp install --fallback-to-build npm ERR! spawn ENOENT npm ERR! npm ERR! Failed at the sqlite3@4.1.1 install 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/2020-09-03T13_06_08_382Z-debug.log

      Author's profile photo Suresh Babu Muthusamy
      Suresh Babu Muthusamy

      I used Npm install sqlite3 and it worked good.

      My question is that, is it possible to deploy this into cf with just the sqlite db or do i need hana db for this?