jdbc-rfc synchronous

[Former Member]

Hi...Experts,

we are going to handle JDBC-RFC Synchronous scenario, how can we proceed, what are the settings are to be required and if u have any example sceanrios pls share with me, it would be very helpfull for me..

thanks in advance,

Jain

[Former Member]

Resolved

[Former Member]

hI Jain,

Check these threads, they contain solution to your scenario.

Configuring JDBC sender

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Configuring JDBC Receiver

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Please Reward points if it helps

Thnaks

Vikrnath

[former_member537867]

Hi Jain,

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,

thank u for ur immediate response, do u have any jdbc-rfc synchronous exp scenario pls send it to me, it would be helpful ..

Jain

[Former Member]

HI,

There is no direct scenario available for JDBC to RFC,

But you can refer above links to solve your purpose.

I have the snap-shot of one of my previous development of JDBC to RFC, let me see if I could share it somewhere at common place and then can share the link here.

Thanks

Swarup