Skip to Content
avatar image
Former Member

mapping 2 source structures to a single target database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 25, 2009 at 06:17 AM

    please ignore this post because I undestood you question wrong

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 25, 2009 at 06:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded