JDBC to mutiple receivers scenario

[Former Member]

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

[prateek · Accepted solution]

Its better to go for BPM based approach with sequntial sent step to ensure that the database commt happens in an order. Then there won't be any problems with rollback of already committed data.

Regards,

Prateek

[rajasekhar_reddy14]

>

> 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

Without using BPM only we can split the messages,we can send to SAP R/3 and Data Base Systems.search in SDN to find Multi mapping without BPM blog.

> 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.

But here your required BPM,Better to use BPM for all cases for spliting and error handling also.

Regards,

Raj

[Former Member]

Can anyoone provide a reference to similar scenario?

Regards,

Kalyan

[rajasekhar_reddy14]

Hi,

refer below link, it explained how to use multi mapping without BPM,splititng messages tou can refer below blog.

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3414700)ID1116324750DB20088192357965272992End...

Regards,

Raj

[Former Member]

Hi Kalyan,

Are you using JDBC adapter to extarct the data from SAP tables.....

[Former Member]

Refer the blogs :

[http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1351995150DB21079808086783775154End?blog=/pub/wlg/2748]

[http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1351995150DB21079808086783775154End?blog=/pub/wlg/2927]