Can you explain steps in the Async and Sync scenarios JDBC to RFC.

[Former Member]

Hi,

Can you explain some basic steps in the Async and Sync scenarios for sending data from JDBC to RFC.

Like,

The data is picked up from the database table through JDBC adapter.

It is passed on to SAP by calling the RFC. RFC gets executed

successfully. The status is returned by the RFC. The status needs to be

updated back into the SQL database table.

Is this a sync case or async case.

What si the diffrences in the sync and async scenarios in the above JDBC to RFC scenarios.

Soorya

[Former Member · Accepted solution]

hi check the below link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5474f19e-0701-0010-4eaa-97c4f78d...

JDBC Synchronous call using BPM

Data Types -

1) File Input

2) JDBC Req

3) JDBC Response

4) File Response of similar type of JDBC Response.. ( This you can avoid also..let it be for first time)

Message Types

4 for each data type

Message Interfaces

1) Async, Outbound, Interface, to receieve the file

2) Async, Inbound , Interface to send the file from XI

3) Async, Absract , Interface of type File message type to recieve the message in the BPM

4) Sync, Abstract Interface with Req message type as File Request, and Response Message type as a file Response

5) Sync , Inbound interface for JDBC with Input message type as a JDBC Request and Output Message type as a JDBC Response

Message Mapping:

1)Mapping between File Req to the JDBC req

2) JDBC Response to File Response

Interface mapping:

1) Sender Interface as a Sync,Abstract Interface created for the file type and target interface as Synchrnous JDBC interface.

Use corresponding mapping for Req and Resp..

note:reward points if solution found helpfull.....

regards

chandrakanth.k

[former_member472138]

Hi

Hi,

I think its best if you first understand the difference between Sync and Async. Then I believe everything will be clear for you.

A syncronous scenario is a scenario where you get a response. Take going to an ATM for example... When you insert your card and enter your pin... you get a response. You don't just insert your card enter your pin and walk away.

Your Pin is either Rejected or Accepted... it can't just stay with your card in the machine and this is similar to sync scenarios. You require a response of soughts.. if you don't get a response then there is an error.

Async is now the opposite of that. It is like if someone sends you a letter. They don't need a response to that letter in order for the initial send to be successful. You don't have to be home when the mail man delivers the letter. It just goes to your house and you will see it when you get home. An async scenario is like this... It does not need a response it simply delivers the message and that is the end of it..

I hope this makes sense... let me know if it doesn't

So ask yourself... does your scenario sound like it requires a response? Or are you simply sending a message to SAP and not sending anything back to the database

Regards

Pothana