nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From obaidul karim <>
Subject JDBC External Table File Target
Date Sat, 23 Jan 2016 05:04:03 GMT

I developing a nifi processor for netezza.
As per by experience the best way to load data to netezza is using netezza
JDBC external table.

I want to run below command to load a file within NiFi processor.

insert into MYTABLE
select * FROM EXTERNAL '<local file system filename>'
USING (<JDBC Options>) ;

My question is which file to usefor <local file system filename>  ?
- Is it the flow files ? If yes then how can I get full path of a flowfile ?
- or can I directly load the file in a spool directory ?

Thanks for your help in advance.


View raw message