Skip to Content
0

Use procedure in flowgraph to move files

Jan 22 at 09:50 AM

90

avatar image

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é.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers