ECC remote call to Hana Platform Edition server

[Former Member]

I have a standard ECC server and another DB server that has Hana, but no ABAP App server layer. Is it possible to remote call a stored procedure that resides on the Hana DB from the ECC server via a program/function module/etc and pass/receive parameters back to the ECC calling program? If so, how?

[Former Member]

ECC is Netweaver 7.40

[thomas_jung]

The HANA without ABAP App Server can expose the Stored Procedure as a REST service (or XSODATA) using Extended Application Services (XS). Your ABAP system can then consume it as it would any HTTP(s) based service.

[Former Member]

Thank you Thomas,

I was able to access the data with the EXEC SQL. commands both via Select statements and Execute Procedure statements. I am looking into your suggestions.

[thomas_jung]

Yes secondary database connection would be another choice (although more tightly coupled).

[Former Member]

Thomas,

I've been able to select data and execute stored procedures via the DB connection. I did run into an issue where I want to pass an internal table from ABAP server to the Hana server, but have not found a way to do that yet. Essentially what I'm trying to do is this, I receive a table of order numbers and want to pass that to the stored procedure so I can essentially do a select "for all entries" on VBFA for the list of orders. I've been looking into the XSODATA and I haven't seen any examples were someone is passing a table of data via DBC or ODATA. Is this possible? Is there another approach you would recommend?

Thanks

[thomas_jung]

OData $filter parameter accepts multiple values and ranges.

[Former Member]

The solution I cam up with was using the native SQL within ABAP BY using the "CONNECTION <DB2>" described in Thomas Jung's blog: https://blogs.sap.com/2012/04/11/test-16/

This blog describes exactly what I was trying to accomplish. Use a generic hana DB without ABAP stack as a secondary DB.