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

[HendriSitompul]

Part 1

Part 2

We are in the step 3 now. Let’s develop a simple iFlow to test our setup/configuration

1. We have Start Timer that we will be set every 5 minutes.
2. Content modifier with label “Query”
3. Request Reply
4. Then End event

a. Start Timer

b. Content modifier with label “Query”

We will put our query In this content modifier.  Here we will try to query a little bit data from our table in PostgreSQL. This is the query statement that we used:

               “select  ponumber from sap_ibob.ics_inbound_po_sap limit 5.”

We will be take 5 records only to avoid performance issue. Because we are just only to make sure our connectivity working fine.

c. Request Reply

We define our connection to our PostgreSQL system.

Put our JDBC data source in JDBC Data Source Alias: PostgreTest Save, then deploy the iFlow. Then change the log level to : Trace. This is the reason why we put 5 minutes in scheduler. So, we have time to change the log level info and we will be know the response from our DB system.

After the iFlow run, we can check from monitoring dashboard (Monitor --> Integrations And APIs --> Monitor Message Monitoring).

Choose the correct iFlow then go to logs then press Trace

We will check what the response from our DB system. Just click the last step ‘End event’ then Message Content (below picture).

Then click ‘Payload’

We can see there are some data coming to our SAP BTP Integration Suite. We can download the payload to see the detail data clearly.