Load more than 2.5 lakh records from Database in SAP PO

[ramu_g4]

Hi Experts,

We are working on JDBC -> Proxy scenario (where DB is sender and S4HANA is receiver).

We have a bit complex SQL statement defined on JDBC channel on SAP PO 7.5 system.

The requirement is to poll more 2.5 lakh records at a time from JDBC adapter once in a day.

I have requested Database team on below options:-

1.Introduce a flag field to pick 20k records at a time and update that flag field. So next time we pick next set of records.

2. Stored procedure to handle the logic on their side and we simply call stored procedure from JDBC sender channel.

But sender DB team is not ready/agreed to implement either of the above options available.

Could you please recommend the best possible solution to implement a stable interface in our SAP PO?

Thanks

Ramu