JDBC Adapter Multiple Receivers

[Former Member]

Hi,

We have the following scenario

SAP ECC->ABAP Proxy->SAP XI->JDBC Receiver

We are sending one payload to SAP XI. What we require is to be able to route this message to several databases at different IP address. The actual receivers will be based on the condition of an x-path.

Does anybody have any ideas as to the solution for this.

Thanks

Martin

[Former Member]

Hi,

Please go through this blog for the same.

/people/shabarish.vijayakumar/blog/2005/08/03/xpath-to-show-the-path-multiple-receivers

Regards,

Sudheer.

[Former Member]

Hi Sudheer,

I have already seen this blog. For our interface, the 'Service' will be the same for the recievers.

Thanks

Martin

[Former Member]

Hi,

AFAIK, you will have to create one CC for every database that you are trying to connect as this field cannot be given dynamically.

SO u will have to send the data using ABAP Proxy and route the data in the Reciever adapter based on ur condition in the receiver determination.

Regards

Vijaya

[former_member187339]

Hi,

>>What we require is to be able to route this message to several databases at different IP address. The actual receivers will be based on the condition of an x-path.

Handle this in either Interface Determination or Receiver Determination

>>What we require is to be able to route this message to several databases at different IP address.

Create a DB receiver adapter for each Database. So you will have a corresponding Receiver Agreement too.

Regards

Suraj

[Former Member]

Hi Suraj,

Can we specify the list of JDBC receivers that the message should be routed to.

Thanks

Martin

[Former Member]

Hi,

You can make use of enhanced receiver determination if the recievers are mutually exclusive.

PRiyanka

[former_member187339]

Hi,

>>Can we specify the list of JDBC receivers that the message should be routed to.

If you are making each of the receivers as different system/service the you can route the message in <b>receiver determination.</b>

Else if you are planning to create one system/service and different interfaces for each of the JDBC DB, then you can route your messages in <b>interface determination</b>.

Regards

Suraj

[Former Member]

To add with Suraj, ref the blog https://weblogs.sdn.sap.com/pub/wlg/2973. [original link is broken] [original link is broken] [original link is broken] [original link is broken] WHere the service is same with multiple interfaces.. You need to have different interface determination on for each inbound interface. Eaah inbound interface will correspond to a single database...

If you need more help on this let me know. We faced a similar problem and solved it as specifed in the blog above..

Regards,

Jai Shankar.

Message was edited by: Jai Shankar