Skip to Content
Jul 23 at 10:51 AM

Unable to connect to PostgreSQL from SAP BAS

140 Views Last edit Jul 23 at 01:49 PM 3 rev

Hi there,

I have got a PostgresSQL database instance on customer's SAP BTP account (productive account, not trial). I need to access the tables from one of the clients available in SAP Business Application Studio (SQL tools/Database explorer). Unfortunately, keep getting the timeout error, hence I am not sure whether I'm doing that correctly:

Steps that I performed:

1. Successfully opened ssh tunnel between BAS and cloud foundry: cf ssh -L 63306:HOST-NAME:5432 appname

2. Used SQLTools extension to create the connection, however it gets timed out when testing it or trying to connect. Unfortunately, logs don't say anything useful, but still attached them herein.

Question: Which credentials should I be using - one coming from VCAP_SERVICES or EXTERNAL-ACCESS-KEY as they differ (I used both to test)

3. Used database explorer with the same settings. Result -> timeout expired

Any help will be very much appreciated.



sql-tools-shot.jpg (81.6 kB)
sallite-logs.txt (3.2 kB)