on 01-27-2011 5:26 PM
Hello,
I have a scenario where i need to send the data from SAP to two different Databases.
In this what would be the best solution between RFC to JDBC and Proxies to JDBC.
Which type can i prefer if I
1) Have the response from databases to SAP?
2) No response from the database to SAP?
Appreciate for your answer.
Thanks
Lax
Hi Madduri,
Even I had to develop RFC to JDBC scenario. Our SAP system version was 4.7C
Earlier my requirement was to send a response back (Synchronus) to SAP saying how many records were updated in the tables.
The interface worked well till the development and quality system. however in Production system the interface started giving performane problems.
The sender RFC adapter gave lot of problems in production. Many times the Data sent from SAP system didnt even reach the PI box. We reported this error to SAP, however even they were not able to provide a solution.
Then we decide to go for Asynchronous RFC to JDBC scenarios. Even Asynchronous interface gave same error in production.
We couldnt use proxies as our SAP system version was 4.7C and there was no scope of SAP system being upgraded to 6.2 or higher. So in the end we had to scrap the interface.
Just wanted to share above information with you.
So best option for you would to use proxies if your SAP system verison is >= 6.2. Synchronous or Asynchronous will totally depend on business requirement.
Regards,
Deepak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lax,
>what would be the best solution between RFC to JDBC and Proxies to JDBC.
It depends
- if you identified a performance issue (bulk data for example or frequently execution): no way than proxy
- if you look to your budget and the RFC function module is allready in place: Take RFC
- if you need to develop the SAP call and there is no performance issue: proxy is a little bit better than RFC (more modern, outside-in approach, more stabil, better source monitoring (MONI), reuse in case of ERP exchange)
Regards,
Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
I feel, It is easist way to follow RFC to JDBC and getting the response from database to SAP.
Thanks,
Sateesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lax,
Proxy communication is better than RFC/BAPI communication when performance is concerned.
RFC/BAPI has its own overhead of function call.
Proxies communicate with the XI server by means of native SOAP calls over HTTP .RFC does not, so you have to convert from SOAP to RFC calls and vice versa. So XML conversion is required.
ABAP Proxies uses Webservice and Http Protocols. Proxies is used for both Sync and Async.
The biggest advantage of the proxy is that it always by passes the Adapter Engine and will directly interact with the application system and Integration engine - so it will and should give us a better performance.
Regards,
Pinangshuk.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Proxy to JDBC is good practice.
As performance & monitoring in Proxies is much better than RFC Communications. Also, if your PI receiver system is down / not working, Proxies will wait for its start & will send the data automatically from queue.
But in the case of RFC, you will push data again.
use Proxy to JDBC & refer the below link for development of Outbound Proxies :
/people/sandeep.kaushik/blog/2010/07/15/abap-proxy-complete-developments-on-sap-pi-sap-abap-systems
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sender side again based on the business requirement.
Proxies are better in perfomance and they support synchronous too. So PROXY TO JDBC synchronous.
>> 1) Have the response from databases to SAP?
If you need response use synchronous, again based on your requirement. Above suggestion would take care synchronous.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.