on 05-30-2017 9:18 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.