How to call External Stored Procedure from HANA SQLScripts?

[Former Member]

Hi All,

Is there a way to call/execute an external stored procedure (SQL based stored procedure) in HANA SQLScripts.

I have the connection details to connect to SQL server (dbconnection and dbname).

Please help.

Thanks,

Vijay

[SergioG_TX · Accepted solution]

I concur with Rich.. however, an alternative would be if  the external stored proc is bound to a web service, etc... then from HANA you could have an XS service using outbound connectivity to call that external service which will call the stored proc.

[Former Member · Accepted solution]

Hi Sergio,

Thanks for the answer.

Do you have any reference document or link available for the solution you provided.

Regards,

Vijay

[SergioG_TX · Accepted solution]

hi Vijay,

please reference Wenjun's post in regards to making outbound connectivity calls:  

http://scn.sap.com/community/developer-center/hana/blog/2014/08/25/use-outbound-connectivity-to-sear...

on the external system, you will need to be consuming a web service or something similar that will call your stored proc, consume other data,  etc

[RichHeilman]

No, this is not supported from SQLScript. You would do this type of thing at the higher application level.

Cheers,

Rich Heilman