Skip to Content
0
Jul 27, 2023 at 07:40 PM

JDBC sender adapter pulling high volume of data/records from database

126 Views

Hi Experts,

We have JDBC to Proxy scenario(Database -> S4HANA) in SAP PO 7.5 single stack.

When executing full load sometimes there would be 2 - 3 Lakh records at once.

We would like to pull all 2-3 lakh records where each record should be converted to an XML message.

As mentioned in below screenshot, we have 1:1 operation mapping defined.

image.png

When executing such high volume of records, do you see any performance issues in SAP PO system?

We have SELECT Query in JDBC channel which pulls data from sender Databases system when the timestamp in Date field is no longer than 24 hours.

Could you please let me know if there would be any performace issues if we try to pull such high volume of data?

Are there any limitations/bottlenecks on SAP PO like sender JDBC adapter (or) cache issues (or) some issue when pulling such large number of records? If yes, could you please let me know what measures or steps to be taken to mitigate any such risk involved? would there be any risk like SAP PO system might crash ?

Kindly guide me to avoid any such potential risks while delaing this scenario?

Thanks

Ramu

Attachments

image.png (10.1 kB)