IDOC to JDBC (different databases)

[Former Member]

Hello,

i need send an idoc to database. The database can be different, (two adapter JDBC), i know the JDCB adapter in a field of IDOC. The questions is How can i do this?

thank you

[Former Member]

Thank you Chirag,

The table structure is the same

[Former Member]

in that case use conditional receiver - I assume table name and structure is same for both the DB.

chirag

[Former Member]

Hello,

thanks you,

i have think using the receiver determination with condition for resolved my problem, i think this is possible and it doesn't necessary two mapping,...

[Former Member]

Hi,

Question to u -

1. Is the table structure in both the data base are same?

If table are different then in that case u have to create multi mapping scenario becuase in message mapping has table name and the respective execution step.

if it is same then u can use conditional receiver.

chirag.

Edited by: Chirag Gohil on Jul 8, 2010 2:10 PM

[Former Member]

Hi,

Your design will be as follows:

IR:

1) 1 outbound interface, 2 inbound interfaces

2) 2 message mappings - idoc to jdbc1 & idoc to jdbc2

3) 2 interface mapping

ID:

1) 1 receiver determination

2) conditional interface determination as the idoc field contaisn the decision data

3) 2 receiver agreements.

Regards,

Pragati

[former_member200962]

The database can be different, (two adapter JDBC)

Yours will be a 1:2 mapping ...... with two message/ service interfaces in the target side.

i know the JDCB adapter in a field of IDOC

Do you mean to say that in an IDOC field you will come to know if you have to send the data to one DB or to other (or both) DB?

Ensure that you set the min occurence of the target interfaces to 0

Regards,

Abhishek.