JDBC---RFC will Support Sync?????????

[Former Member]

Hi All,

Wil JDBC--RFC Senario supports for Sync Comunication with out using BPM???

Regards

Vamsi

[Former Member]

JDBC--RFC Will not be possible in sync , why because it dont have the nature of sync,

For this we require BPM

RFC--JDBC will be possible in sync woth out BPM

[former_member537867]

Hi Vamsi,

It can also be acheived with out BPM also & It all depends on what action u r trying to perform on JDBC adapter .In case if the response of RFC should be mapped to the Response JDBC strcuture would contain the Update Action as shown in this link,http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

The response mapping will be from the response of the the RFC to the JDBC and then the rest of the configuration will continue to be same.The QOS of your Sender JDBC adapter will be EO, You need to change it top BE and then the response that comes back you need to route it to the correct Receiver Adapter.Provide the name of your Receiver JDBC adapter in the Module.

Plz do refer rthe following links:

Regards,

Vinod.

[former_member537867]

Hi Vamshi,

For JDBC (Sender/Receiver )Scenario we have to Install the JDBC Drivers on XI Server.

Use those Driver name and Connection in JDBC Adapter to connect to the Database.

For RFC Sender Adapter we have to create the Program ID in SAP R/3 side.

For RFC Receiver no need of any Extra settings.

step by step RFC to JDBC scenario

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

Tips and Tutorial for Sender JDBC Adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Also you can look at this scenario --> File to JDBC:-

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

SENDER RFC

Registered server program name which is maintained in the ABAP should be called in the program ID.

for more information follow this links

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

/people/shabarish.vijayakumar/blog/2008/01/08/troubleshooting--rfc-and-soap-scenarios-updated-on-20042009

Type 3 ABAP Connection :

ex 1) If we want to execute any function module from one SAP system in another , we need type 3.

We define an RFC destination say ECC6CLNT100 with required parameters.

and to test it go to SE37, select any common sap function module and when you execute that it will ask

for RFC destination. you provide this destination and the function module will be executed in the target

system.

ex2) when you create a partner profile, you need to create a port and for creating a port, we need to

specify an RFC destination. here also we use type 3.

Type H.

ex1) when we need to send xml messages from an SAP system to any other system, we need this.

For example when we send messages using proxy from SAP system to the integration engine of XI, we

need type H.

Type T.

ex1) To we make an RFC call from R/3 to XI , we use sender RFC adapter in XI.

In R/3 system we need to create an RFC destination of type T.

Different types of RFC are :-

Asynchronous RFC - aRFC

Synchronous RFC - sRFC

Transactional RFC - tRFC

Queue RFC - qRFC

Parallel RFC - pRFC

Chk this link also:

Link :http://help.sap.com/saphelp_nw04/helpdata/en/6f/1bd5b6a85b11d6b28500508b5d5211/content.htm

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1685 [original link is broken] [original link is broken] [original link is broken]

Please go through the following links.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step JDBC Receiver Adapter -- Synchronous Select – Step by Step

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter Sender JDBC adapter

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

FILE- RFC-FILE Synchronous (Using BPM)

/people/shabarish.vijayakumar/blog/2008/01/08/troubleshooting--rfc-and-soap-scenarios-updated-on-20042009 Trouble Shooting RFC and SOAP Scenario

Regards,

Vinod.

[Former Member]

Hi Vinod,

thanks for your quick participation.

But i just asked a simple Q.( JDBC---RFC will Support Sync?????????)

Please give me related Ans, that will help me a lot in understanding the concept plzzzzzzzz

Regards

Vamsi

[Former Member]

Hi,

No JDBC Sender Adapter is by nature Asynchronous (i.e. Select statement and the update staement in Communication channel), you have to create the Async/Sync bridge to communicate with RFC.

If your RFC is also workign as Async way, i.e. no response then you can use JDBC to RFC without BPM.

Thanks

Swarup

[Former Member]

Hi Swarup,

So in this JDBC--RFC case if we need Response to JDBC means, we shld use BPM??

Will RFC----JDBC can have the Sync Scenario???

If Yes means, How the JDBC will respond back with Response to RFC???

Can you please alloborate it

Regards

Vamsi

[Former Member]

hi for

How the JDBC will respond back with Response to RFC???

check the below blog

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

regards

chandra