Skip to Content
0
Former Member
Dec 10, 2009 at 12:20 PM

JDBC to mutiple receivers scenario

21 Views

Hi experts,

I have the following scenario.

Source

Database1

Target

1. SAP R/3

2. Database2

3. Database3

Data from a database needs to be picked and sent across to three receivers by splitting the data

Assume we have 20 fields retrieved from source. 10 fields would be sent across one SAP R/3 and the other ten fields to both the target databases.

Failure in one of the target system needs to have a roll back in other target systems where data was committed.

Do we need to use BPM for the message split?

Please do provide your valuable inputs

Regards,

Kalyan