jdbc-rfc scenario

[Former Member]

Hi..All,

i am planing to do jdbc- rfc scenario (both sides Synchronous) , if any body is having sample sceanarios for jdbc-rfc synchronous pls send it to me ...

**for helpful answers i will assign points**

regards,

Pasi.

[Former Member · Accepted solution]

Hi,

Refer

Tips and Tutorial for Sender JDBC Adapter

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

For JDBC, use this weblog

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

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

JDBC to XI to RFC

Thanks

Swarup

[Former Member]

Hi,

This weblog answer your question

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

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Thanks

Vikranth

[former_member556603]

Hi Pasi,

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.

jdbc-rfc scenario

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/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

Check these threads, they contain solution to your scenario.

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

Hope this info is useful to you..

Thanks,

Satya Kumar