Skip to Content

Use procedure in flowgraph to move files

Hello Community,

I'm creating a flowgraph to load data from CSV files into our HANA database. After the file has been loaded I want to move it to a directory indicating it has been succefully processed.

I've created a remote source using the file adapter and created a virtual procedure 'FILE_EXEC' on the supplied 'EXEC' procedure that comes with de SDI File Adapter.

When I call the stored procedure from a SQL Editor (i.e. in HANA Studio) this works fine.

I now would like to call this procedure from within my flowgraph and use the column values from my input (Data Source) to supply the right paramter values to the procedure.

However, when I try to connect my Data Source (or any other node in my flowgraph) as input to the procedure node, I cannot see any column names to use as input parameters :

I'd like some advice on what to do to make this work (if possible of course).

Kind regards,

René.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers