Multiple Jdbc to Multiple rfc

[Former Member]

Hello,

i have a problem whit my new complext PI interface.

I need read some tables in SQL Server (whit a relation each others), and i need send the data on RFC function modules for each table.

But i cannot create different interfaces...

I need read the tables on same time and delete the content....

How can i do it? using BPM? using only one Comunication Channel?

Have you suggestions or example?

Thanks in advance

Alex

[rajasekhar_reddy14]

Hi ,

To select Data from multiple tables use Join query to select data from many table,in your case there is a realtion between all tables,so better to using only instead of BPM.

cheers,

Raj

[Former Member]

Hi Alessandro Pederiva

write a stored procedure for this for example: sp_multical

and inside your mapping call EXECUTE sp_multical

inside your Stored procedure you can wtite the complex logic to read and update multiple table

for more on SP you may follow this thread

http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

hope this may help you

thanks

sandeep

[Former Member]

Hi!

You could achieve this e.g. with a BPM. Have a look at the BPM loop patterns delivered by SAP.

A brief description (examples and use cases) can be found here:

http://help.sap.com/saphelp_nwpi71/helpdata/en/de/766840bf0cbf49e10000000a1550b0/content.htm

Regards,

Volker

[Former Member]

i know what is it as BPM but i'm not sure it's a good solution.

how can i lunch on same time 5 JDBC adapter??? and group all data in same interface?