XSJS and HANA procedure synchronous use

[Former Member]

Hi All,

I have a requirement where I need to call a third party Stored Procedure (SQL Server based)  in HANA and use the result set in a HANA Procedure.

I am able to consume the Stored Procedure as OData  via XS web request and the output is put in a DB table.

Currently the XSJS and HANA procedure are working asynchronously.

But I need to use this XSJS within the HANA procedure when it is called by a report in ABAP so that both the XSJS and HANA procedure is triggered synchronously.

Please suggest.

Thanks,

Vijay

[Michał]

Hi Vijay,

it looks like you should be able to consume the stored procedure as a virtual table with respective oData adapter within your HANA procedure, as follows SAP HANA Academy - Smart Data Integration : OData Adapters.

Best,

Michal