on 05-23-2017 1:10 PM
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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.