Webservice to JDBC BPM scenario

[Former Member]

Hi Experts,

I have created the below objects for the Webservice to JDBC BPM scenario.

Data Type

1. DT_SOAPRequest

2. DT_SOAPResponse

3. DT_JDBCRequest

4. DT_JDBCResponse

MessageType

1. MT_SOAPRequest

2. MT_SOAPResponse

3. MT_JDBCRequest

4. MT_JDBCResponse

Message Interface

1. MIIS_JDBC_In - Inbound Synch(With JDBCRequest(Input message) and JDBCResponse(Output message)

2. MIOS_SOAP_Out - - Outbound Synch(With SOAPRequest(Input message) and SOAPResponse(Output message)

3. SOAPRequest_ABS - Abstract Asynch for SOAP Request

4. SOAPResponse_ABS - Abstract Asynch for SOAP Response

5. JDBCRequest_ABS - Abstract Asynch for JDBC Request

6. JDBCResponse_ABS - Abstract Asynch for JDBC Response

Is the object are correct?

Already raised the same below request..but still confused with BPM flow

Please help me out..

Thanks in Advance

Sara

[Former Member · Accepted solution]

> Hi Experts,

>

> I have created the below objects for the Webservice

> to JDBC BPM scenario.

>

> Data Type

> 1. DT_SOAPRequest

> 2. DT_SOAPResponse

> 3. DT_JDBCRequest

> 4. DT_JDBCResponse

>

> MessageType

> 1. MT_SOAPRequest

> 2. MT_SOAPResponse

> 3. MT_JDBCRequest

> <b>4. MT_JDBCResponse_response</b>

[Former Member · Accepted solution]

DT_SOAP_Request

DT_SOAP_Response

DT_JDBC_Request

DT_JDBC_Response

MT_SOAP_Request

MT_SOAP_Response

MT_JDBC_Request

MT_JDBC_Response_response

MI_OS_SOAP_ReqResp

MI_IS_JDBC_ReqResp

MI_AS_SOAP_ReqResp

MI_AA_SOAP_Request

MI_AA_SOAP_Resp

Interface Mapping between:

MI_OS_SOAP_ReqResp and MI_IS_JDBC_ReqResp (to avoind transformation in BPM)

<b>BPM</b>

Receive(open sych/Aynch bridge)-----Send(Synch)-Send(close bridge)

Receive = MI_AA_SOAP_Request

Sych Send = (MI_AA_SOAP_Request , MI_AA_SOAP_Resp)

Send = MI_AA_SOAP_Resp

Thanks

Farooq.

[Former Member · Accepted solution]

SOrry the interface mapping is between :

Interface Mapping between:

MI_AS_SOAP_ReqResp and MI_IS_JDBC_ReqResp (to avoind transformation in BPM)

Thanks

Farooq.

[Former Member · Accepted solution]

The same scenario I have done without BPM. It works fine. So, there is no problem with datatype and messagetype.

Could you please guide me for the BPM steps. (Receive, send steps with configuration elements)

Regards

Sara

Message was edited by:

Sara D

[Former Member · Accepted solution]

2 Message Mapping programmes :

MM_Request (MT_SOAP_Req and MT_JDBC_Req)

MM_Response (MT_JDBC_Response_response and MT_SOAP_Resp)

Interface Mapping: (same as mentioned above):

in Request tab put MM_Request

in Response tab put MM_Response

Thanks

Farooq.

[Former Member]

hi SARA,

your interfaces will be eight:

SOAP outbound asynchronus

SOAP inbound asynchronus

SOAP abstract asynchronus (request)

SOAP abstract asynchronus (response)

JDBC abstract asynchronus (request)

JBBC abstract asynchronus (response)

SOAP abstract synchronus (request response)

JDBC abstract synchronus (request response)

message mapping:

1)SOAP abstract asynchronus (request) and JDBC abstract asynchronus (request)

2)JBBC abstract asynchronus (response) and SOAP abstract asynchronus (response)

interface mapping:

SOAP abstract synchronus (request response) and JDBC abstract synchronus (request response)

hope this will help

regards

HONEY

[Former Member]

Could you please guide me for the BPM steps. (Receive, send steps with configuration elements)

Regards

Sara

[Former Member]

Hi Sara:

Container variable : You have to create 3 variables...

1. Name : ReceiveMessage

Category : Abstract

Type : MI_AA_SOAP_Req

2. Name : SendSynch

Category : Abstract

Type : MI_AS_SOAP_ReqResp

3. Name : Send

Category : Abstract

Type : MI_AA_SOAP_Resp

*************************************************

BPM Steps:

1. Create Receive Step :

In properties :

Message = MI_AA_SOAP_Req

Mode = Open S/A Bridge

Synchronous INterface = MI_AS_SOAP_ReqResp

2. Create Send Step

In propereties :

Mode = Synchronous

Synch Interface = MI_AS_SOAP_ReqResp

Req Message = MI_AA_SOAP_Req

Resp Message = MI_AA_SOAP_Resp

3. Again create Send step

In propereties :

Mode = Close S/A Bridge

Message = MI_AA_SOAP_Resp

Opened by = Receive

I almost provide you each step to create BPM:)

Try and let me us now if you find any difficulty.

Thanks

Farooq.

[Former Member]

hi SARA,

in BPM there will be 3 steps mainly.

start

1)<b> Receiver</b> it will be multiline container ( SOAP request).

2) <b>Sender make it synchronus</b> (right click on sender then make it synchronus), here you give input and output messages, no need of corelation.

3<b>) Sender</b> asynchronus this will be SOAP response.

stop

all abstract interfaces will use.

if any problem ,plz ask me again

regards

HONEY.

[Former Member]

Hi Farooq,

I couldn't create the below container variable.

Name : SendSynch

Category : Abstract

Type : MI_AS_SOAP_ReqResp

TheSOAPRequeestResponse Abstract synch message interface I couldn't get it in the lookup..

Regards

Sara

[Former Member]

hi SARA,

in Sender Synchronus step do as follows:

Create Send Step

In propereties :

Mode = Synchronous

<b>Synch Interface = MI_AS_JDBC_ReqResp(this will be JDBC reqres)</b>

Req Message = MI_AA_SOAP_Req

Resp Message = MI_AA_SOAP_Resp

<b>after this whole integration processs you can test this process with help of F7.</b>

hope this will help

regards

HONEY

[Former Member]

Go to Message Interface> Click on this interface> and chek weather u made it synchronous and abstract or not??

Thanks

Farooq

[former_member192892]

HI Sara,

When u r doing a JDBC Sync scenario, the response message type name is dependant on the request messagetype name

ie, if request is

MT_JDBCRequest

--->Statement1

response should be

MT_JDBCRequest_response

-

---

>Statement1_response

-

---

>row

Other than that,

Message Interface

1. MIIS_JDBC_In - Inbound Synch(With JDBCRequest(Input message) and JDBCResponse(Output message)

2. MIOS_SOAP_Out - - Outbound Synch(With SOAPRequest(Input message) and SOAPResponse(Output message)

3. SOAPRequest_ABS - Abstract Asynch for SOAP Request

4. SOAPResponse_ABS - Abstract Asynch for SOAP Response

5. JDBCRequest_ABS - Abstract Asynch for JDBC Request

6. JDBCResponse_ABS - Abstract Asynch for JDBC Response

7. JDBCAbsSync---Abstract sync for JDBC o/b from bpm

[Former Member]

hi SARA,

you have request and reponse so go for synchronus call, why are you trying asynchronus, message mapping will be two but interface mapping will be one.In BPM you can go with synchronus call too.

I have tried FIle to RFC to FIle through BPM with synchronus cal, your scenario is like this only.

hope this will help, for more clearification ask again.

regards

HONEy