Skip to Content
0

jdbc sender

May 23, 2017 at 12:10 PM

63

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Hari Joshyam May 23, 2017 at 04:23 PM
0

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!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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?

0