RFC to JDBC scenario

[Former Member]

Hi Experts,

For a customer I need to create an RFC->JDBC connection via XI; the RFC on a productive SAP system nees to send data to XI and from XI an SQL has to update a table in an external SQL-database. In the past I have done XI-assignments but as it has been some time ago I just can not get it straight how to handle this requirementagain... is there a "how-to" somewhere with respect to this scenario? Or can somebody help me on the way? I'ld appreciate it!

Thanks for the help.

William.

[agasthuri_doss · Accepted solution]

Hey,

Import the RFC - Function module, Declare the data type for JDBC - receiver end, The below link will help

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

Deploy the Driver for SQL - Database , Mentioned in Provider.xml file, Check the connection for JDBC & RFC.

Cheers

Agasthuri

[Former Member]

Hi William,

YOu can see this step by step guide for the whole end to end process:

https://wiki.sdn.sap.com/wiki/display/XI/step%2bby%2bstep%2bRFC%2bto%2bJDBC%2bscenario

Regards,

---Satish

[GabrielSagaya]

For JDBC Drivers configuration.

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60237e74-ef19-2b10-5a9b-b35cc6a28e83&overrid...

For Configuring sender RFC adapter

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

For Configuring Receiver JDBC adapter

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

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

[Former Member]

Hi William,

You may not get the exact scenario help. But you can use this blog and get the data into PI using RFC Adapter:

http://www.riyaz.net/blog/understanding-the-rfc-adapter/

Once you have your data in PI you can use this blog and do the mapping and send data to your external table:

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

Regards,

---Satish