In my case to prevent appending duplicate data I firstly send flowfile to DELETE in SQL and then to INSERT So firstly Nifi deletes all rows in SQL table which are matched with rows in my flowfile and then inserts all rows from flowfile    ... View more

I am using Nifi Registry installed on Windows Server and Windows 10 It works good from WSL (Ubuntu, Debian) on Windows 10. Or on Windows Server 2016 I used cygwin (there is no WSL on this server version) 1) I added in .bash_profile in WSL or cygwin commands to export path of Java and start Nifi Registry on boot For example for cygwin:     export JAVA_HOME=/cygdrive/c/'Program Files'/Java/jdk1.8.0_261 export PATH=$JAVA_HOME/bin:$PATH /cygdrive/d/nifi-registry-0.7.0/bin/nifi-registry.sh start     (cygwin use the same java folder as windows system) 2) And than saved a .vbs script to run cygwin on Windows boot:     Set ws = CreateObject("Wscript.Shell") ws.run "c:\cygwin64\cygwin.bat", vbhide     3) And put this script to autorun folder in Windows: win + R -> shell:startup So now after Windows boot cygwin starting on background with Nifi Registry on board   I also tried to find the way how to run cygwin with nssm but it was unsuccessfully ... View more