From the course: Data Management with Apache NiFi

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Run the dataflow to insert data into PostgreSQL

Run the dataflow to insert data into PostgreSQL - Apache NiFi Tutorial

From the course: Data Management with Apache NiFi

Start my 1-month free trial Buy for my team

Run the dataflow to insert data into PostgreSQL

“

Now that our Dataflow is completely connected and configured, let's get ready to execute this flow. But first, let's make sure the data is available. Remember that previously, when the flow read the data in, it also deleted the file. So I'm going to paste this file once again in the Datasets folder that my flow reads. So here is my CarAdd01.csv pasted into the Datasets folder that my flow is now going to read. Select the GetFile processor and click on the Play button and GetFile will now run. As soon as GetFile reads the file, it'll also delete the file from the datasets folder and you can see that the folder off to the right is empty. The file has been deleted. The queue has one flow file. Let's right-click, go to List Queue and let's view the contents of this flow file. You can click on the little icon And this will allow you to view the flow file contents within the browser. Notice on line 13, we have an NA in a numeric column. That's the NA that resulted in an error when we tried…

Contents