PI issue

[ramu_g4]

Hi Experts,

I have a question regarding SQL DB to S4HANA Integration using JDBC to Proxy scenario in SAP PO/PI .. Here, the Databricks DB guys have shared a very lengthy SQL statement but it is not compatible with SAP PO. should we ask DB guys to build stored procedure on their side?

Is it possible to call stored procedure using JDBC sender adapter from PO?

Thanks

Ramu

[Ryan-Crosby]

Yes, a stored procedure is possible using the JDBC adapter and I would press the DB folks for that because unless you are an expert on that data there's no reason for that query to be owned by the middleware folks handling the PI/PO platform.