JDBC to IDOC using BPM

[former_member189441]

Hi Experts,

I am doing the scenario JDBC to IDOC

Note: i need a solution without stored procedures

My requirement is , in sender JDBC side

1) We need to select data from 3 tables from the DB ( I think we can do this by JOIN query specified in the channel)

2) after selecting data we need to update all 3 tables

(I think we can't do this, as we have only one update option in the sender JDBC channel). So i want to go for BPM.

Can we do like this...??

2 mappings:

--> sender JDBC o/p structure (MT-1)   to  IDOC structure(MT-2)                                         (MM-1)---->  (IM-1)
--> sender JDBC o/p structure (MT-1)  to  JDBC update structure (for 3 tables) (MT-3)                 (MM-2) ----> (IM-2)

BPM:

MT-1                    (IM-1)                                                     (IM-2)
Receive           Trnsformation             AsyncSend to R/3             Transformation             Async Send to JDBC(Receiver)
  Step                    Step1                                                   Step2

MT = Message Type; MI = Message Interface; IM = Interface mapping; MM = Message mapping

Edited by: murali krishna on Mar 9, 2010 8:24 AM

[former_member189441]

ok

[former_member206760]

u do not require a BPM..

the method that u specified is right..

mappings: 
--> sender JDBC o/p structure (MT-1)   to  IDOC structure(MT-2)                                         (MM-1)---->  (IM-1)
--> sender JDBC o/p structure (MT-1)  to  JDBC update structure (for 3 tables) (MT-3)                 (MM-2) ----> (IM-2)

just in the 2nd mapping that updates the tables the receiver service is same as the sender ..

also specify both the mappings in the interface determination...first the update mapping and then the Idoc one and click the maintain order at runtime so that Idoc is trigeered only after update mapping is done..

[former_member189441]

I am not getting you...one sender MT and 2 Receiver MT's....then will it be like one Interface mapping and we assign 2 individual mappings??

[former_member181985]

one Messagae Interface for JDBC Sender

One Message Interface for IDOC

One messge interface for JDBC reciever (Statament structure is 0... unbounded)

One message/interface mapping for IDOC receiver.

One message/interface mapping for JDBCreceiver.

Configuration:

JDBC sender --> 2 receiver(IDOC and JDBC receiver)

[former_member189441]

Hi

You mean to say through multi mapping we can do this..??

Thanks,

Murali

[former_member181985]

You can do individual mapping right

Edited by: Praveen Gujjeti on Mar 9, 2010 2:52 PM

[former_member189441]

Hi

Can u elabarate how can send to JDBC recevier..you mean to say in another scenario?? if so there should be some relationship between these 2 scenarios..How can we achieve this??

Thanks,

Murali

[former_member181985]

JDBC Sender (Payload) --> IDOC Receiver (one mapping program)

--->JDBC receiver (one mapping program, Use JDBC update receiver document format here)

[Document Formats for the Receiver JDBC Adapter|http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]

its basically a message split.

- Praveen Gujjeti.

[Former Member]

Hi,

I have gone through the link. you mean to say do we need to use JDBC sender for synchronous scenario. Can you please explain clearly how we will achive without using BMP.

Regards,

Rama

[former_member181985]

Your message call asynchronous. So, there should be no issues.

Rest is straight forward as I mentioned earlier.

[stefan_grube]

use a stored procedure for this.

create the stored procedure in your database.

create one for reading, one for updating.

[former_member189441]

HI

our client is not ready to go for Stored Procedure.

is there any way to do the same using BPM or any other method

Thanks,

Murali

[former_member181985]

You dont require a BPM for this.

Take the selected data and pass this information to IDOC receiver and JDBC again.

USE JDBC Receiver Document formats for updating.

Regards,

Praveen Gujjeti.