Skip to Content
author's profile photo Former Member
Former Member

Async to Sync Scenario

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:39 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:22 AM

    Hi kiran,

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

    SWC: SAP BASIS

    Regards Mario

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2008 at 08:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.