on 07-10-2015 12:58 PM
Hello All,
I have got requirement from my customer and he asked me do POC on PI.
They might have chance to use direct connection between webfocus and oracledatabase.but that is little costly and need to pay licence cost. so they plans to use PI in middle.
Scenario flow:
1) Intial request comes from Webfocus to PI( on demand request)
2) PI gets retrieve data from Oracle database key as a initial request.
3) PI sends back data to Webfocus.
challenges:
1) how PI connects to Webfocus ? either use SOAP (or) REST- please clarify me on this? FYi webfocus have their own adapters to connect SAP.
2) Oracle database may thousands datasets for one request. But webfocus wants data back to within seconds for ex: max 4 to 5 seconds, how I achieve on performance?
Please suggest your views.
Thank you.
Sateesh
HI Sateesh,
Basically you need to configure SOAP to JDBC Synchronous scenario for this requirement.
Here is a link: SAPTechnical.COM - Implementation of SOAP to JDBC Synchronous scenario
Through JDBC you may also call Stored procedure for connecting to multiple datasets in oracle DB.
Hope this helps.
Let me know if you need further details.
Many Thanks,
Anurag
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.