Execute HANA SDI Flowgraph from ABAP code

[former_member231709]

How we can execute HANA SDI Flowgraph from ABAP code? Is there any way?

[ssurampally · Accepted solution]

You can use ABAP managed Datsbase Procedure(AMDP) to do this. Using AMDP class and method implementation you can call a Stored procedure in HANA Database. So you can keep your SQL of START TASK Flowgraph in a SQL procedure and implement that in AMDP.

[former_member231709 · Accepted solution]

Currently I'm execute stored procedure(for ex.: Hana_SP) with class cl_sql_statement:

DATA(lo_stmt) = NEW cl_sql_statement( ). <br>lo_stmt->execute_procedure(  proc_name = 'Hana_SP' ).

[jeffrey_kresse]

I wish I could give a nice code block for you, but alas I'm not an ABAP guy.

If the program can somehow execute HANA SQL, then you can use START TASK statement to handle starting it. Alternately, you can use the REST API to execute a specific task.

Best,

Jeff

[former_member486160]

Here is the link.

https://help.sap.com/viewer/bd4ae8b11fd749cabb248aff53837eb8/2.0_SPS00/en-US/8364d33595ca4e98be25b0e...

We have used these IM rest api and these are working fine. Please let me know if you face any issue.

[former_member486160]

You can use sdi rest api to trigger it from ABAP layer.

[former_member231709]

Hi! Could you please give an example for this approach?