on 03-26-2014 7:09 AM
Hi All,
Could anyone tell me the various feasible options to retrieve data from Oracle using SAP pi ,
one way is using JDBC adapter,need your help on the other feasible options.
Your help will be highly appreciated .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We can fetch data from databases through webservices. (I cant say in all cases).
But Yes I agree from BEL that JDBC calls are the best way to do this.
Hi- As above suggested it's good to go with standard JDBC adapter..
However if you don't want PI to connect to the database, then i'm sure you can generate the files using stored procedures which can later be processed by PI using File adapter..
But, why? this is the correct and safest way, mate.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.