on 06-19-2008 8:28 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
CHECK THIS LINKS:
/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
reward points if useful *
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.