Skip to Content
avatar image
Former Member

jdbc sender


What are the things to be asked to third party when my sender is JDBC.

Apart from connection and table structure.

Please clarify on flag.

JDBC to RFC asynchronous Scenario.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 23, 2017 at 04:23 PM

    Hello Sai,

    You need to know below things,

    1) DB : SQL / ORACLE - Based on this you deploy the drivers. If already present ignore.

    2) HOST & Port : Standard JDBC port 1433 but this can be varied depending on the network configuration of the external system.

    3) DB Name :

    4) User & Password :

    Once you have the details you can reach to your admin to perform Ping / Telnet on the IP & Port to consider the connectivity test.

    With regard to Flag : This is normally Status Flag to update the records after reading.

    In Channel you have Select & Update. The flag concept is basically used to update those records which are transferred to SAP and avoid to pick in the next polling run. Basically you should request DB team to add this PI flag field in table in case if it is not present.

    Select * from Tab1 where Flag = 0

    Update Tab1 SET Flag = 1 where Flag = 0


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      1.Please clarify on database possibilities maintained by third party customer or landscapes maintained by database

      2.when to go for stored procedure?

      3.when to go for staging table?

      4.what are the possible ways to approach?