Async to Sync Scenario

[Former Member]

Hi Experts,

I am doing async JDBC to sync webservice scenario.

I did create async interface for JDBC and sync interface for webservice.

my scenario is i just want to see the response from webservice in XI for trouble shoot, i dont need to send the response message to database.

can anyone tell me how can we do it without using BPM (async to sync bridge).

Kind Regards,

kiran

[Former Member · Accepted solution]

Hi Kiran,

You don't need BPM for implementing your scenario. It can be implemented with BPM.

Flow of Data will .

1. Create JDBC Adapter for source system.

2. JDBC Adapter will poll table in the database. Whenever data is updated or inserted, Data will be picked up.

3. Data goes into XI system.

4. Mapping is done between JDBC data and Request data of Webservice. as well as between Webservice response and JDBC target data type.

5. Webservice will be invoked using SOAP Receiver Adapter.

6. Webservice will send response and this will be captured by receiver adapter.

7. Imp. Webservice data should be declared as inbound synchronous.

Blog : /people/shabarish.vijayakumar/blog/2006/03/28/rfc--xi--webservice--a-complete-walkthrough-part-2

Try This.

Ranjeet Singh.

Edited by: Ranjeet Singh on Jan 29, 2008 9:40 AM

[Former Member]

Hi kiran,

May be u can do one thing.

create jdbc<->XI<->Webservice synchronous scenario....

Sender JDBC can't be synchronous in reality...still u can try it since u r just doing it for testing purpose....

u will get an error...in moni... but... u can see the response from webservice in moni....

regards

biplab

[prateek]

Create a dummy receiver, e.g. a file receiver. After receiving the data from jdbc sender, make a soap lookup. The response of SOAP lookup is enough for ur scenario.

For SOAP lookup

/people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

Regards,

Prateek

[Former Member]

Hi kiran,

you will find a sample for the BRIDGe delivered by SAP in your interface repository.

SWC: SAP BASIS

Regards Mario

[Former Member]

Hi Mario,

If i create asnc interface for jdbc and sync interface for webservice if i map both interface and do all the design and config.

can i able to see the response message in XI??

I must use BPM for this????

Can we achive without BPM????

Kind Regards,

Praveen.

[Former Member]

Hi Kiran,

I don't think it is required to go for any BPM.

Look, you need to map the response of Webservice (as its synchronous) in interface mapping and mapping interface. without this the whole flow will not be completed.

If just you want to check use Webservice as asynchornous inbound in message interface. this will fail the interface but at least you would be able to see the Webservice responce in SXMB_MONI.

You need to create dummy interface as posted in above post.

i.e follow below steps,

Do all the necessary steps in IR and ID for JDBC to Webservice interface.

then,

1. create a data type, message type and message interface(aynchornous inbound)

2. Create message mapping with response message of WebService.

3. in interface mapping use this file message type for response of web service.

4. configure file adapter as receiver.

5. create necessary receiver determination, interface determination and sender and receiver agreements for file.

this will be enough to test it.

Thanks

Swarup

[Former Member]

Hi

<<<<3. in interface mapping use this file message type for response of web service

I have created file interface and mapping for websevice response and file structure.

In Interface mapping what is the source interface must i put.

is it synchrounous Webservice Interface????

???????----

---

>file Interface

Kind Regards,

Kiran

[Former Member]

Hi,

here you need to put the response message of WebService.

If you are using the wsdl as external defination then create response message interface and import the external defination. This will provide you to use either request or response there you have to select response message.

So Wsdl response -

---

> File receiver

Thanks

Swarup

Edited by: Swarup Sawant on Jan 29, 2008 1:27 PM

[Former Member]

Hi Swarup,

I did like this.

Data Types: JDBC_DT,File_DT

Message Types: JDBC_MT,File_MT

Message Interfaces:

JDBC_OUT_MI(outbound,async),

File_MI(inbound,async),

WS_IN_MI(inbound,sync,input=WS_req,output=WS_resp)

WS_resp_MI(outbound,async,WS_resp),

Message Mappings:

JDBC_WS_req_MM

(JDBC_OUT(JDBC_MT)------->WS_IN_MI(WS_req) ).

Interface Mapping: JDBC_WS_req_IM(source=JDBC_OUT_MI,target=WS_IN_MI)

Can you please tell me for reponse mapping and interface mapping and sender agrrement for response.

Kind Regards,

Kiran

Edited by: Kiran Kumar on Jan 29, 2008 2:22 PM

[Former Member]

Hi

Please go through below steps now

I have added the comments with same in bold font

Data Types: JDBC_DT,File_DT

Message Types: JDBC_MT,File_MT

Message Interfaces:

JDBC_OUT_MI(outbound,async),This should be Sync given MT_File as respo

File_MI(inbound,async), Dont use this

WS_IN_MI(inbound,sync,input=WS_req,output=WS_resp)

WS_resp_MI(outbound,async,WS_resp), -----No need of this

Message Mappings:

JDBC_WS_req_MM

(JDBC_OUT(JDBC_MT)------->WS_IN_MI(WS_req) ).

*Here WS_IN_MM msg. mapping should be used insted of*

*WS_IN_MI i.e message interface*

*WS_File_Res_MM*

(WS_Res(Source -- Ws_res) ---> File_MT)

Interface Mapping: JDBC_WS_req_IM(source=JDBC_OUT_MI,target=WS_IN_MI)

In IM you need to use the above one only

Here you have two tabs as Request & Response, Request will be normal as

it is JDBC_MT to WS_Req with proper mapping

*In Response use File_MT <--- Ws_RES with appropriate mapping *

For ID configuration refer below sample scenario,

It is File1 to RFC to File2- Just in your scenario it is JDBC>WS--->File2

So refer and do necessary changes

From SP 19 on XI 3.0 and SP 10 on PI 7.0, a File - RFC - File ( Asynch - Synch ) scenario can be done without a BPM.

Steps:

Integration Repository

The Integration Repository will be similar to any Synchronous Scenario ( say HTTP - RFC ) . 1 Outbound Synch message Interface and 1 Inbound Synch Message Interface.

Integration Directory

This is where a few differences lie, so let me take some time.

1. The Receiver Determination , Interface Determination will be the same as in HTTP - RFC synch scenario. Create the Sender File Adapter, Receiver RFC Adapter and Receiver File Adapter.

2. Sender Agreement will be for the Sender File Adapter. Sender Agreement uses the Synch Outbound Message Interface.

3. Receiver Agreement will be for the Receiver RFC adapter. Receievr Agreement will use the RFC as thge Inbound Message Interface.

4. We need to add a few modules in the Sender File Adapter.

Go to the Modules Tab of the Sender File Adater, and add the following modules in the same sequence,

Number - ModuleName - Type - ModuleKey

code1- AF_Modules/RequestResponseBean - Local Enterprise Bean - 1

2- CallSapAdapter-Local Enterprise Bean - 2

3-AF_Modules/ResponseOnewayBean-3[/code]

Parameters

ModuleKey - ParameterName - ParameterValue

code1 - passThrough - true

3-receiverChannel - Receiver File Adapter Name

3-receiverService - Receiver Business Service/ System[/code]

With this configuration, you can now handle the requirement without a BPM

This feature been already blogged for JMS Adapters in these blogs ,

Sync/Async communication in JMS adapter without BPM (SP19)

/people/venkataramanan.parameswaran/blog/2007/01/18/syncasync-communication-in-jms-adapter-without-bpm-sp19

Async/Sync Communication using JMS adapter without BPM (SP 19)

/people/sudheer.babu2/blog/2007/01/18/asyncsync-communication-using-jms-adapter-without-bpm-sp-19

Dynamic Configuration is also possible,and this as well as many other options are discussed in the How To guide - "How To Realize a sync-async and async-sync

bridge within the Adapter Framework" available on the Service Market Place.

For info on the Modules used here, look into these links,

Request Response Bean

http://help.sap.com/saphelp_nw04/helpdata/en/45/20c210c20a0732e10000000a155369/content.htm

Response Oneway Bean

http://help.sap.com/saphelp_nw04/helpdata/en/45/20cc5dc2180733e10000000a155369/content.htm

Hope this info helps,

Thanks

Swarup