Trigger a Stored Procedure through SAP Cloud Platform Integration

[celo_berger]

Hello,

We are using SAP Cloud Platform Integration to load data from multiple API endpoints into a HANA Cloud DB.

I have created a stored procedure in HANA which I'd like to be executed once my Cloud Integration iflow completes, so ideally, I'd like to add a step at the end of my iflow that will trigger the execution of the stored procedure in HANA.

Is that scenario possible and if so how?

I was reading that we should expose the stored procedure as an odata service that could be consumed by the iflow, but haven't figured out how to do that. I know how to expose tables and we're doing that left and right.

Appreciate your help.

Marcelo

[former_member657638]

Hi celoberger

Did you find a solution for this scenario? We are facing the exact same thing.

BR

Kristof

[apu_das2]

Direct access of stored procedure is not possible right now which is possible in SAP PI/PO.

As a alternate approach you can write an AMDP and creae an inbound proxy which will call this AMDP.

In CPI, you can use XI adapter to call this proxy.

[celo_berger]

Ah bummer. Thanks Apu for the feedback!