Two source systems and one target system

[Former Member]

Hi Experts,

I want to read the data from SAP system and DATABASE system and send it as one file structure to target system as file.

Can anyone please advise how we can achive this.

Kind Regards,

Kiran.

[prateek · Accepted solution]

Use BPM. have a look at the collect patterns provided by BPM.

U may search the related blogs on sdn.

There could be a workaround.

Take data from SAP. During the mapping step, perform a JDBC lookup. Then send the data to file. This will avoid BPM

Regards,

Prateek

Message was edited by:

Prateek Raj Srivastava

[Former Member · Accepted solution]

Hi Prateek,

Thanks for your quick reply, can you please explain me more clear about during mapping step perform jdbc lookup.

Kind regards,

Kiran

[Former Member · Accepted solution]

Go for BPM with Multimapping.

Outbound interface for SAP.

Outbound Interface for Database.

Inbound interface for File.

Abstract Interface for SAP

-

---

''----

---

for Database.

AI for File.

do the multimapping between the Abstract interfaces...

disgin BPM

there should be a

Fork (with 2 receive steps..i.e SAP and Database.) then transformataion step. then send step

sequence...

<b>FOrk(2 Receive steps)--

---

Transformation-----Send</b>

Thanks

Farooq.

<b>

Rewards points if u find it useful.</b>

[Former Member · Accepted solution]

if u want to do JDBC lookup in Message Mapping then use this blogs:

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Thanks

Farooq.

[prateek]

First of all u ll b getting the data into XI from SAP in one of the following ways

1. Proxy 2. Idoc 3. RFC

Then dusing the message mapping step, perform JDBC Lookup

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Then forward the message to the file system.

Regards,

Prateek

[Former Member]

Hi,

folow this link in configuration builder.

SAP BASIS->SAP BASIS 6.40->http://sap.com/xi/XI/System/Patterns->Mapping Object->Message Mapping->BpmPatternCollectMergeMultiIf

Regards,

Akshay Jamgaonkar.

[Former Member]

Hi Kiran,

you have to use BPM and a multi-mapping.

In your IR is a sample under SWC SAP_BASIS.

Regards Mario