Design Issue

[Former Member]

Hi All,

I need to run two stored procedures and write two files on FTP for the responses .

Do i need to use BPM here?

Thanks,

Monish

[MichalKrawczyk · Accepted solution]

Hi,

if you can do it like:

1st procedure - 1st - FTP

2nd procedure - 2nd FTP

then you don't need a BPM

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Hi Michal,

I need to write the responses of two stored procedures on same FTP. So i thought of going to BPM

BPM will be like the following

Receive

Fork -- execute both stored procedure and get the response

Send - send the response to file

Is there any better way to do this other than BPM

Thanks,

Monish

[Former Member]

Hi Monish,

When ever you post an issue you need to tell the whole process so that the solutions would be precise to your query.

Anyways if you want to call the stored procedures one after the other then you need to have bpm. If you want to call both of them with one call this also can be done. Here you can avoid bpm using this thread:

Make sure to apply the note for jdbc adapter. Once you receive the output you can do a multi mapping and write the files to the output.

Regards,

---Satish