step by step jdbc-rfc

[Former Member]

Hi,

Can anybody provide me the links to step by step JDBC TO RFC scenario.. I had tried searching in SDN , not able to find a step by step document.

Thanks in advance,

PI

[Former Member]

Hi Friends,

Thanks for your valuble inputs. But I am looking for end to end single scenario...any ways thanks again for your time

Thanks,

PI

[former_member200962]

The way a channel configuration happens (JDBC, RFC), remains the same in all the scenarios (JDBC > IDOC, JDBC> FILE, SOAP --> RFC, PROXY --> RFC). If you have a JDBC --> RFC, it should not be an issue configuring the channels/ scenario....the only logic that needs to be applied is in mapping....and nobody in SDN can guess it for you!

creating a DT, MT, OB MI for JDBC-end; importing the RFC, maintaining a RFC destination are some of the common steps need to be followed while creating JDBC--> RFC scenario.

While testing make sure that your DB has updated data in the table so that is can be pulled from the table by your JDBC channel and passed to the RFC

Regards,

Abhishek.

[Former Member]

HI,

Please do following steps ;

1) First u have to install JDBC Drivers(Ojdbc14.jar) for Oracle database or SQL Database needs SQL Drivers(Sqljdbc.jar) as for u r Database.

2) In Mapping u have to follow rule.

resultset>

<row>

Filed1,

Field2

</row>

<row>

Filed3,

Field4

</row>

</resultset>

3) IN JDBC sender Adapter u have to give following parameters

JDBC DRIVER: oracle.jdbc.driver.OracleDriver (For Oracle database) or com.microsoft.sqlserver.jdbc.SQLServerDriver (For Sql Databse)

CONNECTION: jdbc:oracle:thin:@IP Address:port:Hostname (For Oracle datbase) or

jdbc:sqlserver://IP Address;Database= Hostname; (For SQL database)

4) For RFC Reciever adaper u have to fill SAP R/3 Server details.

These Links also Use full for u......

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

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

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

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/file-rfc-file%28without+bpm%29&;

Thanks

Ravi

[Former Member]

HI,

For sender JDBC...go through..

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

For receiver RFC...go through...

http://help.sap.com/saphelp_nw04/helpdata/en/c8/e80440a832e369e10000000a155106/content.htm

Regds,

Pinangshuk.

[Former Member]

For JDBC scenario, you probably need to deploy vendor specific driver:

follow the document below:

How to Install and configure external drivers for JDBC JMS (Deploy)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

This wiki tell you how to configure JDBC sender:

JDBC 2 JDBC

https://wiki.sdn.sap.com/wiki/display/XI/Step-by-Step+Guides

You can also search how to configure RFC receiver, it is straight forward

Regards.

Liang