Created 08-15-2019 03:46 PM
Brand new NiFi user here. I created a process group and have the QueryDatabaseTable → PutFile processors linked. I funnel the output for failures and successes from the PutFile processor. I'm getting data passed through without issue, however, it is not writing the output file to my C:\users\<username>\nifi_output on my local machine. I have changed the configuration of the PutFile to try \\<machine-name>\C$\users\<username>\nifi_output for the output file and that hasn't worked either. I haven't received any errors. Like I said, I'm a newbie, so I don't know where to look any further. Thanks!
Created 08-23-2019 08:25 AM
Thanks to all for your insights. What I ended up doing was installing NiFi locally on my machine, still connected to my database server on the network. I had to mess with the DB Connection Pool a bit to get the correct combination of Database Connection URL and userid and password, but I got it to write successfully to my hard drive locally. Fortunately, I had a limit of 45 files set for the directory in my PutFile processor because I got 45 flowfiles in a heartbeat. So, if you're testing this out, MAKE SURE YOU LIMIT YOUR NUMBER OF FILES before you attempt to run your processes!!!
Created 08-19-2019 12:42 AM
If you run NiFi in an Docker Container you can link the path in docker-compose file.
Otherwise you can try to share your folder to network, then it should be like smb://machine-name/nifi_output
Created 08-19-2019 12:44 PM
More info: NiFi installed on VM, not connected to internet. copy of oracle test db on vm as well. should I use NiFi scripts to point to local drive? I need admin account to grant access to drive.
Created 08-23-2019 08:25 AM
Thanks to all for your insights. What I ended up doing was installing NiFi locally on my machine, still connected to my database server on the network. I had to mess with the DB Connection Pool a bit to get the correct combination of Database Connection URL and userid and password, but I got it to write successfully to my hard drive locally. Fortunately, I had a limit of 45 files set for the directory in my PutFile processor because I got 45 flowfiles in a heartbeat. So, if you're testing this out, MAKE SURE YOU LIMIT YOUR NUMBER OF FILES before you attempt to run your processes!!!
Created 08-19-2019 08:34 PM
Little bit away from your question but this solution may work, If you create a FTP server on your local machine folder, and open your ip using public ip, then you can connect to your local folder from anywhere in the cloud or some other remote machine. For this, you have to switch PutFTP instead of PutFile.