on 10-27-2008 3:52 PM
Hi,
I've got the following scenario and I don't know if it's possible to complete all the integration without using BPM. If you think that BPM is necessary please tell me your solution please.
A user click a button in a web application or something similar and that starts a synchronous process between JDBC and RFC (BAPI).
The click must "activate" a petition to JDBC adapter and that adapter reads a table and then send the data to a BAPI in R/3. The BAPI receives the data and do an update and then send a return confirmation code to the JDBC adapter.
So I have a JDBC <-> RFC synchronous scenario but I think I have 2 problems, JDBC can't be used under petition, and JDBC can't use synchronous communication...
Thanks for your help
i think you are trying to do a synchronous communication with your database with R/3 and update some tables inside R/3.
If this is right...here are the approaches.
Since the trigger is
A user click a button in a web application or something similar
.
Option 1:
Use BPM
1.Receive the message in using a reciecve step.
2.Do a synchronous send step (use a receiver JDBC) to poll the data from your data base.
3.Do a synchronous send step (use PROXY/RFC) to update the R/3 tables
4.Do a asynchrous send step to update the DB tables uisng receiver JDBC adapter.
Option 2:
With put BPM.
If you want do the design without BPM, first check the Database versions--- webservice is supported or not.
since your trigger is
A user click a button in a web application or something similar
.
If its supprorted you can update a flag and start the polling of the DB tables uisng sender JBDC adapters...
and do the design JDBC==Proxy (sync scenario).
hope this helps you..
Sunl.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Sunil and Varun for your interesting approaches,
I've found a very interesting thread that I think it can solve my problem and I want to share it with you.
First I've got to study a little how does it works but it looks that I can use file/JMS/JDBC adapters synchronous with that solution
Hi Marshall,
After my analysis on your requirement, it seems the best solution thats coming to my mind is to use a BPM. Please find the total design below
1. Use sync-async bridge in BPM. BPM will have two sync send steps. One for JDBC and one for RFC. You'll use JDBC adapter in receiver mode.
2. Expose this interface as a web service and use it in your application.
Please do letme know if you need more clarifications
Thanks
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.