Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 24, 2010 at 05:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 24, 2010 at 07:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded