Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC/select/async statement to JDBC/stored procedure/sync call

Hi

We have JDBC/select/async statement to JDBC/stored procedure/sync call i.e sender and receiver are JDBC.

PI has to pick all the the records of single internal order number at a time from sender system and upload to receiver JDBc,

gets the response and routes to sender/insert statement.

This should run only once per day.

We will have multiple Internal orders daily, each order consisting of 10 to 20 records but only one IO related records has

to upload to Receiver/JDBC

What are the options available ?

We have thought of following options

1. SQL query is already to pick, but we have to pick records at one time daily. example: morning,evening or midnight.

At that time it can pick multiple times but it should not pick through out day

2. Is there any option in BPM so that we can group IO's at a time and upload ? If so what are the steps need to use

Any additonal receive step need to be used to pick the records from the table.

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question