Showing results forย 
Search instead forย 
Did you mean:ย 
A New Home in the New Year for SAP Community!

Using Sqlite with Application Studio

Galactic 1
Galactic 1
0 Kudos

Hello, I am on the learning journey "Develop Applications Running on SAP BTP Using SAP HANA Cloud". Using the Application studio with Sqlite to start with and have imported the data sets given. Everything seems to be working alright (npm install, cds build and deploy ...) but when running the application and switching to the web preview no data are shown but only the first ID-column of the data sets and all other data are "null". Could the problem be related to the Sqlite version 3 or earlier? Help much appreciated ๐Ÿ™‚.


Hi @Markus77
I informed the subject matter experts they will look into this.

Kind regards


Answers (2)

Answers (2)

Galactic 1
Galactic 1

Thanks to Ancutas description, it's now working ๐Ÿ™‚ - thank you very much!

I changed the package.json as follows and ran npm install, cds build and cds deploy.

cds watch does the magic in the background.


After marking the relevant data-columns, the tables are reproduced in the fiori preview:





Hi  ,It should, this is not related to the Sqlite version. In your package.json you should have: "devDependencies": { "sqlite3": "^5.0.2" }, where ^ - means taking the latest version of sqlite. The steps for testing it locally are:

1. npm install or npm update

2. cds build

3. cds deploy

4. cds watch:

5. Open the localhost, go to Fiori preview:

6: If you can't see the fields, please navigate to Settings and add all the columns you want to see.


Hope this helps, if not please let me know.

Best regards,


Screenshot 2023-09-05 at 12.35.51.png

Screenshot 2023-09-05 at 12.32.50.png

Screenshot 2023-09-05 at 12.37.26.png


Galactic 1
Hi Ancuta, thank you very much! I will try and give you feed-back.