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

[Former Member]

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

[rodrigoalejandro_pertierr]

hi

as i can understando you, you will receive mani IO and you must execute one IO in the receiver SP? if so, you can solve this usssing a ccBPM where you will have to create a mapping(0.N) where the source and the target structure will be the same, the diferrence will be in the occurrance of the target structure which will have to be 0.N (Tab signature in Message Mapping). then back to the ccBPM define a block with the property ForEach. this will loop any times accord with the number of IO that you receive from the sender. as a result you will execute one SP for each IO.

so, you ccBPM will be

RS>TS>BLOCK(Multiline container and single container of source structure)>TS->SS

RS:Receive Step

TS:Trans. Step

SS:Send Step

Also the container will be:

source--> type Abs

source_multiline --> type Abs

target -->type Abs

Thanks

Rodrigo P.

Edited by: Rodrigo Alejandro Pertierra on Jun 24, 2010 4:54 PM

[Former Member]

I didnt understand your question properly for uploading just one record in Receiver JDBC.

But if you want to pick up records just once a day from JDBC sender, you can do "Adapter Scheduling" in PI and only once in a day it will get automatically activated and pick up data.

On Sender side itself you can write Stored procedure to do whatever logic you are suggesting to do in BPM to improve performance.

Hope this is helpful.

If not then please explain it little more clearly so everyone can respond to your question.

Thanks,

Hetal