IDOC ->JDBC ->RNIF SCENARIO

[Former Member]

Hi Experts,

Currently i am working on invoice idoc to JDBC(synchronous) to rnif. could you please help me the steps. depending on the bill to or soldto or plant i have to get the 14 fields from sql server and send it to the RNIF adapter. could you please send me the steps for this scenario. using BPM.

Advanced Thanks

Regards

Sundher

[moorthy]

Hi,

In BPM: without mapping lookup , but with Sync JDBC call

1) Receive Step to receive the Idoc message

2) Call the JDBC synchronously

3). Map the Response to RNIF Receiver Message

4) Send the Message to RNIF

You can make the Sync. Mapping i,e Mapping between Idoc message to JDBC call and JDBC Response to RNIF outside the BPM..

Check out this blog-/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

btw, what is the volume of data? based on that, you can decide to choose, mapping lookup or Sync JDBC call with BPM

Rgds,

Moorthy

[prabhu_s2]

<i><b>depending on the bill to or soldto or plant i have to get the 14 fields from sql server and send it to the RNIF adapter</b></i>

to fill the fields with reference to billto/soldto/plant from SQL SERVER u might take the advantage of DB lookup.

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