cancel
Showing results for 
Search instead for 
Did you mean: 

transfer from rdbms to RFC using XI

Former Member
0 Kudos

Hi Does any one have step by step document of how to transfer from rdbms to RFC using XI . Kindly help me

Accepted Solutions (1)

Accepted Solutions (1)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Amit,

this scenario that you are trying is possible ( JDBC - XI - RFC).

1. You will have to create a Sender JDBC adapter. Check the link below for configuring a JDBC sender adapter.

An important point to note are 2 fields, <b>QUERY</b> this will contain the <b>select query</b>. Next will be the <b>UPDATE</b>.this will contain the UPDATE statement after the rows are selected from your database.

The reason an update statement has to be given is, as the JDBC adapter will continually poll over your database, the rows read in one polling interval should not be read again.

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

2. Next, you will have to configure a receiver RFC adapter. This can be done following this link,

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

The rest of the configuration are like anyother XI scenario.

Hope this helps,

Regards,

Bhavesh

Former Member
0 Kudos

thanks bhavesh ,

i believe that you need to use BPM since rfc call will be sync call and call from jdbc would be async

shld i uses bridge pattern . is there any check to find out if the rfc and jdbc adapters are installed sucessfully . i am reading the links that you mentioned but if you some one has done it and has a step by step doc it would be extremely useful

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Amit,

<i>//is there any check to find out if the rfc and jdbc adapters are installed sucessfully</i>

One way would be to go to Run Time Workbench> Adapter Monitoring> and check if the JDBC and RFC adapters are listed there.

// believe that you need to use BPM since rfc call will be sync call and call from jdbc would be async

I think you would have to go for a BPM in this case and also, the synch asynch pattern will have to be used.

For a blog on how to use Synch / Asybnch Bridge, I would suggest this link,

/people/sriram.vasudevan3/blog/2005/01/11/demonstrating-use-of-synchronous-asynchronous-bridge-to-integrate-synchronous-and-asynchronous-systems-using-ccbpm-in-sap-xi

For blog on how RFC is to be used in a BPM,

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

https://weblogs.sdn.sap.com/pub/wlg/1403 [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

I guess you will have to combine all this info and use it in a single BPM.

For more info on Synch/ Asynch Bridge and how to create a BPM ,

http://help.sap.com/saphelp_nw04/helpdata/en/62/dcef46dae42142911c8f14ca7a7c39/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ae/fd773f12f14a18e10000000a114084/content.htm

All this info will help you,

Regards,

Bhavesh

Former Member
0 Kudos

//is there any check to find out if the rfc and jdbc adapters are installed sucessfully

One way would be to go to Run Time Workbench> Adapter Monitoring> and check if the JDBC and RFC adapters are listed there

curently i am not able to see the JDBC and RFC adapters under adapter monitoring . do we need to activate and the service and the channel and if yes how to do that . we are on sp 15 stack

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Amit,

If this is the first time that you are trying the BPM, I would suggest that you try a simple scenario , get a hang of BPM and then move on to the advanced scenarios that you are trying.

This is a good blog for starters on BPM,

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

Also, this info on theorotical info on BPM can also help you understand how to use BPM better,

http://help.sap.com/saphelp_nw04/helpdata/en/78/62373f58502e48e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/62/dcef46dae42142911c8f14ca7a7c39/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/de/766840bf0cbf49e10000000a1550b0/content.htm

Hope this helps,

regards,

bhavesh

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Amit,

Can you check in thsi path again,

Runtime Workbech > Component Monitoring> Componenents with status (all) -->Adapter Engine --> Adapter Monitoring

Here, you will find all your adapters.

Regards,

Bhavesh

Former Member
0 Kudos

here we can only see JPR adapater . is there any thing we are missing or some next steps to be done for it. basis guy has completed the post installation and patches upto sp 15

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Amit,

I am not sure as to what the problem is, but I would suggest that you go through this blog of Michal and check if it has answers to your problems,

/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions

Regards,

Bhavesh

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Amit,

On second thoughts, have you tried any normal file scenario?? Has your file been picked up?? If yes, then it means that your file adapter is up and running and has been installed.

I think, you might have not selected ALL when trying to display you adapters. Also, when you reach your adapter engine, you can select SHOW ONLY INSTALLED AND STARTED ADAPTERS and if this will display all the required adapters.

Regards,

Bhavesh

Answers (1)

Answers (1)

former_member187339
Active Contributor
0 Kudos

Hi,

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

Regards

Suraj