https://community.cloudera.com/t5/Support-Questions/Need-help-on-how-to-make-listSFTP-processor-properties/m-p/227827#M189687 <P>Hi Folks,</P><P><STRONG>My Requirement:</STRONG> SFTP connection setup. </P><P>Partners send files to us via SFTP. we need to fetch those files and put into respecting folder for further processing.</P><P>we are planning to use nifi technology for this sftp setup. Please help to make this happen. </P><P>We are thinking below process to implement.</P><P>First will use the ListSFTP processor for list all the files and followed by fetchSFTP processor for fetch all the files which are authorized.</P><P><STRONG>Need help on, below points.</STRONG></P><P><STRONG>1)</STRONG> ListSFTP supports listing of the supplied directory (Remote Path) and supplied "Hostname" using the 'Username" and 'Password" / "Private Key Passphrase".</P><P>The password can change at a regular interval (depending on organization policy) or the Hostname or the Remote Path can change based on some other requirement.</P><P>in the above case how to set the ListSFTP properties based on the attributes.. like point 2. </P><P>( for these attributes, we are planning to prepare the csv file which will have Remorepath ,hostname, usename, and password ,and other attributes...)</P><P><STRONG>2)</STRONG> How to read the csv file and make all make all the attributes as variables...to use in down stream flow.</P><P><STRONG>3)</STRONG> How to route the files into target directories ( if we have sub folders based on partner..how to copy that perticular partner files into other folders.).</P><P>Thanks in Advance.</P><P>Thanks,<BR />Rangareddy Y</P> Tue, 26 Jun 2018 20:40:27 GMT rangareddyy 2018-06-26T20:40:27Z