JDBC to RFC

[Former Member]

I have to create a Asynchronous scenario, where I need to retrieve the Material Numbers from the JDBC and need to insert them into RFC.

Any help on the above scenario. Again this an Asynchronous scenario.

[Former Member]

Hi,

As mentioned in two replies above, you could follow steps in Integration Repository and Integration Directory.

However, following weblogs could be a worthy read to resolve and troubleshoot some of the technical issues, if you face them:

For Sender JDBC Integration Repository steps as well as some finer points on JDBC adapter:

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

For JDBC sender adapter configuration:

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

For RFC at receiver end in asynchronous mode, you could follow the steps explained in above-mentioned replies.

Thanks,

Bhavish

[Former Member]

>retrieve the Material Numbers from the JDBC

> and need to insert them into RFC.

1. Import the RFC in IR.

2. Create the JDBC sender data type and Data Type Message type as per JDBC format(for sender)..in this case it should look like

3. when we import RFC in IR..Data Type, Message Type, Message Interface(in your case Inbound Asynch) not need to create.

<Message Type Name>

<row>

<coloumn1>

<coloumn2>

<coloumn3>

<coloumnN>

</row>

</Message Type Name>

4. Create the Outbound interface for JDBC...

5. Mapping between JDBC_MessageTypw and RFC

6. Interface Mapping (Outbound Asynch JDBC interface and RFC)

check ur Mapping and activate all the objects.....

Follow all the steps in ID...

RD, ID, SA and RA.

Adapter ( JDBC Sender and RFC receiver..)

Note: for retrieving data enter the valid SQL querry in the JDBC adapter...with update field = <TEST> (if u are not doing any update wile reading data.)

[justin_santhanam]

Jenni,

First create the Data type with <root> as the First node with 0..unbounded and all the fields which you are going to grab from the database. So your structure must look like..

Step 1:

<MT_MaterialMaster>

<root> 0..Unbounded

<Sub-field1/>

..

..

..

<Sub-fieldn/>

</root>

</MT_MaterialMaster>

Create the corresponding o/b interface for the above structure.

Step 2: Import RFC from your R/3 system.

Step 3: Map btw JDBC Message and RFC Message

The rest of the objects are as usual. Could you tell us wher you got stuck so that it could be easy for us to suggest.

raj.