Want help in rfc to jdbc connection

[Former Member]

Hi PI gurus

I have a requirement in PI that i have to integrate SAP with pacer system .pacer is having oracle database.

in SAP side iam using RFC in pacer side i have to use JDBC adapter.i have to update the data in pacer tables.this should be asynchronous messaging. Please guide me with proper blogs . i want to get step by step process. Points immedietly rewarded.

Thanks and Regards

Veena

[Former Member · Accepted solution]

hi,

Already u got the answer,iam sending some more links on JDBC for ur reference,

JDBC ADAPTER

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

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

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

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

JDBC RECEIVER ADAPTER

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

Phani

[Former Member]

HI,

This weblog answer your question

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

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

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

1. Create a RFC in the R/3 system

2. Configure the SM59 and Sender Communication channle as given in the Michal's blog. Also test if it is succesful.

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

3. Import the RFC in XI

4. Do the mapping to the target strucutre

5. Configure the JDBC receiver adapter

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

6. You can trigger the RFC from R/3 sytem by using

Async Call

CALL Function "RFC Name" IN BACKGROUND TASK destination <sm59 destination>

COMMIT WORK.

Sync Call

CALL Function "RFC Name" destination <sm59 destination>

Thanks

Swarup

Edited by: Swarup Sawant on Jan 26, 2008 9:25 AM

[Former Member]

Hi

Thanks for the reply.Iam giving marks. Really a good help for me.

[Former Member]

i have given very heplful marks points to you tell me whether it has come bcos i dint get ant save option after selecting the very helpful answer radio button

[Former Member]

Hi,

Thanks for your confirmation and I am very happy to hear that the details I had provided make help to you

I got the points for it. Even you can also click on my name in your post and check if the points get allocated or not.

Thanks

Swarup