Skip to Content
0

ECC remote call to Hana Platform Edition server

May 30, 2017 at 08:18 PM

163

avatar image
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?

10 |10000 characters needed characters left characters exceeded
Former Member

ECC is Netweaver 7.40

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Thomas Jung
May 31, 2017 at 03:56 PM
1

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.

Show 5 Share
10 |10000 characters needed characters left characters exceeded
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.

0

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

0
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

0

OData $filter parameter accepts multiple values and ranges.

0
Former Member

The solution I cam up with was using the native SQL within ABAP BY using the "CONNECTION " 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.

0