Step by step setup JDBC PostgreSQL connection in SAP BTP Integration Suite (part 1)

[HendriSitompul]

In this article I want to share how to setup JDBC connection in SAP BTP Integration Suite, Cloud foundry environment. For your note, we use PostgreSQL for our Database system (on-premise) and SAP cloud connector.

We will discuss this 3 steps:

1. Setup mapping in SAP Cloud Connector
2. Setup connection in SAP BTP Integration Suite
3. Build a simple iFlow to test our connection

Step 1. 

We will mapping virtual host to our internal system (PostgreSQL DB). Let assume we have PostgreSQL DB located in IP 7.6.5.4  and port 123.

1. Back-end-Type: Non-SAP System then click ‘Next’.

2. Protocol: TCP then click ‘Next’

3. Fill Internal Host then click ‘Next’

4. Virtual Host & port

Virtual Host: PostgreSQL-Test

Virtual Port: 123

Then click ‘Next’

5. Description

Please put description that you want

 6. Summary

Then click ‘Finish’

Let test our cloud connector connection to our PostgreSQL DB.

Click button below Action tab (red circle). If success Check Result tab will be show reachable with green color.

Reference: https://help.sap.com/docs/connectivity/sap-btp-connectivity-cf/configure-access-control-tcp?locale=e...

Link for step 2 (part 2)