Introduction
This document explains how to connect a local SAP CAP (Cloud Application Programming Model) application to a PostgreSQL database running on SAP BTP (PostgreSQL – Hyperscaler Option).
Before proceeding, the following prerequisites are assumed to be fulfilled:
- A PostgreSQL (Hyperscaler Option) service instance has already been created on SAP BTP.
- A Service Instance Key has been generated for this PostgreSQL instance.
- The developer has access to the instance key credentials in JSON format (including database name, host, port, user, password, and SSL certificate).
The screenshot below illustrates: