mapping 2 source structures to a single target database

[Former Member]

Hi Experts, My scenario is a Proxy to JDBC in which I need to send data from 2 source structures to 1 target table.

Source structures : Target:

ABC XYZ

row1 InsertStatement

Item1 DBTable

-

---

Action

-

---

(Fields) Table

acess

DEF -

---

row2 -

---

item2 -

---

-

---

-

---

(Fields)

-

---

(Fields)

Please let me know how to map the 2 source nodes to the target access node to transfer data from the source tables to target database.

Regards,

Krishna

[former_member200962]

You should make use of BPM to collect the two source structures.

One of the BPM examples mentioned in IR --> SAP BASIS ---> SystemPatterns can be referred for this purpose.

Once the messages are collected, perform a 2:1 mapping (two Proxies as source message and one JDBC message as target).

If you want the mapping logic then please provide a proper format of both your Source and Target messages and the expected mapping, so that someone from SDN can help you out.

The target structure provided is a bit confusing.

Are you going to receive two different proxy messages (i.e. two different calls) or just one Proxy call and there you will have two different nodes within the same message??? ...... me confused

Regards,

Abhishek.

Edited by: abhishek salvi on Sep 25, 2009 11:51 AM

[Former Member]

please ignore this post because I undestood you question wrong