cancel
Showing results for 
Search instead for 
Did you mean: 

Scenario

Former Member
0 Kudos

Hi...All,

Is it posible to do the JDBC-RFC Synchronous (JDBC-RFC-JDBC) Scenario with out using BPM ?

if posible pls let me know the processing steps..

Thanks in advance,

Pasi.

Edited by: pasi s on Jun 19, 2008 9:28 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

As far as I know you will not be able update the database back based on RFC response in a synchronous way though you have option of selecting BE in sender JDBC adapter.

This is sentence from SAP training material...

"In the case of a JDBC sender, the database table is queried via a SELECT statement. The message is by definition asynchronous hence the QoS should be set as EO or EOIO. "

The only option i can think of is JDBC Sender(async)->BPM->RFC(synch)->response mapping to JDBC receiver structure->JDBC receiver to update the table.

Also check these threads...

You can't use the JDBC sender adapter as Synchronous way, try to Choose the Quality of service : "Best effort" in your sender communication channel to create synchronous flow. You will get an error that this mode (best effort) is not allowed

You have to go for BPM,

Thanks

Swarup

Edited by: Swarup Sawant on Jun 19, 2008 9:45 AM

Answers (4)

Answers (4)

Former Member
0 Kudos
Former Member
0 Kudos

hi,

For JDBC (Sender/Receiver )Scenario we have to Install the JDBC Drivers on XI Server.

Use those Driver name and Connection in JDBC Adapter to connect to the Database.

For RFC Sender Adapter we have to create the Program ID in SAP R/3 side.

For RFC Receiver no need of any Extra settings.

jdbc-rfc scenario

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

Tips and Tutorial for Sender JDBC Adapter

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

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Also you can look at this scenario File to JDBC:-

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

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

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

SENDER RFC

Registered server program name which is maintained in the ABAP should be called in the program ID.

for more information follow this links

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

/people/shabarish.vijayakumar/blog/2008/01/08/troubleshooting--rfc-and-soap-scenarios-updated-on-20042009

Check these threads, they contain solution to your scenario.

Link :http://help.sap.com/saphelp_nw04/helpdata/en/6f/1bd5b6a85b11d6b28500508b5d5211/content.htm

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1685 [original link is broken] [original link is broken] [original link is broken]

Please go through the following links.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step JDBC Receiver Adapter -- Synchronous Select Step by Step

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

Tips and Tutorial for Sender JDBC Adapter

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

For JDBC, use this weblog

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

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

JDBC to XI to RFC

Thanks,

Vijaya

Former Member
0 Kudos

hI,

These links are useful to you..

JDBC Sender/Receiver adapter

/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

Thanks

Vikranth

former_member859847
Active Contributor
0 Kudos

Hi,

you can configure jdbc- rfc with out BPM,

when bothe message interfaces are sysnchronous.

if you are planning jdbc as asynchronous.

please use sync-asysnc bridge.

you want example scenario, go through

SAP Basis-> http://sap.com/xi/XI/System/Patterns->;

BpmPatternSyncAsyncBridge

warm regards

mahesh.