cancel
Showing results for 
Search instead for 
Did you mean: 

jdbc sender

former_member327037
Participant
0 Kudos

Hi,

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member229310
Active Participant
0 Kudos

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

Cheers!

former_member327037
Participant
0 Kudos

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?

Answers (0)