Community
Application Development and Automation Blog Posts
Learn and share on deeper, cross technology development topics such as integration and connectivity, automation, cloud extensibility, developing at scale, and security.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

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

HendriSitompul
Explorer
‎2024 Sep 06 7:03 AM
3,537

Part 1

Now we will setup JDBC connection to our virtual host that we already defined before. Go to Monitor in your SAP BTP Integration Suite --> Integrations and APIs --> Manage Security tab --> JDBC Material.

HendriSitompul_0-1725407117564.png

1. Click ‘Add’ to adding JDBC data resource.

HendriSitompul_1-1725407144107.png

2. Let fill the parameters

 

HendriSitompul_2-1725407144107.png

Name: PosgreTest

Description: Connection to PosgreSQL

User: admin_db

Password: [fill with your own db pwd]

JDBC URL: jdbc:postgresql://postgresql-test:123/sales

Location ID: JKT (please fill this with your cloud connector location ID)

HendriSitompul_3-1725407144111.png

Then we click ‘Deploy’

 For JDBC URL  format you can ask your DB engineer or follow SAP documentation. Don’t confuse! The format should be different with Ms. SQL.

Reference: https://help.sap.com/docs/cloud-integration/sap-cloud-integration/jdbc-for-postgres-on-premise?local...

Link for step 3 (part 3)