S02E3 Connect CAP Project to SAP BTP Postgresql DB | VS Code PostgreSQL DB backing service connect

S02E3 Connect CAP Project to SAP BTP Postgresql DB | VS Code PostgreSQL DB backing service connect

In this Tutorial YouTube video, we are guided through the process of connecting a CAP (Cloud Application Programming) project to a PostgreSQL database within the SAP Business Technology Platform (BTP). The tutorial, focused on using Visual Studio Code, demonstrates the seamless integration with a PostgreSQL database backing service.

The video offers a step-by-step walkthrough on establishing a connection between the CAP project and the SAP BTP PostgreSQL database. You will learn how to leverage Visual Studio Code to configure and optimize the connection, ensuring efficient data interaction.

This tutorial is an invaluable resource for developers and SAP professionals looking to enhance their skills in connecting CAP projects to databases within the SAP BTP environment. By providing practical insights and demonstrations, the video empowers viewers to successfully establish and manage connections, facilitating effective database operations within their CAP projects.

Call us on [phone]

You can download the ppt of this session from below

CAP (Cloud Application Programming),
SAP BTP (Business Technology Platform),
PostgreSQL Database,
Visual Studio Code,
Database Connection,
Backing Service,
SAP Cloud Platform,
Integration Tutorial,
VS Code Configuration,
Database Operations,
SAP Development,
Cloud Application Development,
Connectivity,
Application Programming Interface (API),
SAP Fiori App,
Development Best Practices,
Data Integration,
Cloud Services,
Tutorial Walkthrough,
Development Environment Setup,

[EdoardoGrasso-rbkq]

Hi Anubhav,
I think that a step is missing, because in the end when the logs of the cds watch show up, you can see: "connect to db > sqlite { database: 'memory:' }". So it is still using a temporary local database. Indeed, I tried this method on my application but the dataset that it accesses is not the one on the cloud even though I binded the postgresql service, and whenever I do any CRUD operation and then I restart the application the changes I made are gone.
I've been trying to figure out a solution for this issue for quite a lot of time but every tutorial I found on the topic focuses on linking a LOCAL postgresql database, and not a CLOUD one, and this is so annoying. If you or someone else can provide a solution I'd be very grateful 🙏

[ShubhamKumar-uii]

Hi Anubhav,

When trying to bind my application to CF and running cds bind command after creating the service key, its giving me this error .
"Error: Unknown CDS service name for service "postgres-cap-postgres". Please specify as argument for "cds bind"."

Please help me out to sort this issue.

Thanks.