Skip to Content
Technical Articles

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:

https://blogs.sap.com/2020/05/01/sap-cloud-application-programming-model-demo1/

https://blogs.sap.com/2020/05/03/sap-cloud-application-programming-model-demo2/

https://blogs.sap.com/2020/05/10/sap-cloud-application-programming-model-demo3/

https://blogs.sap.com/2020/05/16/sap-cloud-application-programming-model-demo4/

https://blogs.sap.com/2020/06/07/sap-cloud-application-programming-model-demo5/

In this post, i have created the SAP CAPM application following the steps from blog: https://blogs.sap.com/2020/05/03/sap-cloud-application-programming-model-demo2/

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",
	    "driver":"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!! 🙂

#EnhanceLearning

BR//Dhanasupriya Sidagam

2 Comments
You must be Logged on to comment or reply to a post.