From the course: Data Management with Apache NiFi
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Add GetFile and PutDatabase processors - Apache NiFi Tutorial
From the course: Data Management with Apache NiFi
Add GetFile and PutDatabase processors
- [Instructor] We'll set up a NiFi flow to read from our local file system, and we'll have it read from the datasets folder. If you look at this datasets folder that I have under my tools directory, you can see there's exactly one file in here to start off with, car_ad_01.csv. Let's take a look at the contents of this file, and you can see that it contains a bunch of information about cars that were advertised on some kind of site. We have the make and model of the car and a bunch of other details. These are the records that we are going to store into our PostgreSQL database. Now, let's head over to the NiFi user and use a processor to read in data from our local file system. This is going to be the GetFile processor. GetFile is exactly like PutFile except that it reads files from the local file system. GetFile requires the read filesystem and write filesystem permissions because as soon as it reads a file from the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Set up a PostgreSQL table3m 11s
-
(Locked)
Add GetFile and PutDatabase processors3m 23s
-
(Locked)
Configuring the CSVReader controller service3m 46s
-
(Locked)
Configuring the DBConnectionPool controller service4m 26s
-
(Locked)
Running and encountering dataflow errors2m 47s
-
(Locked)
Configuring the ReplaceText processor2m 58s
-
(Locked)
Running a dataflow to insert data into PostgreSQL2m 35s
-
(Locked)
Configuring the Run schedule3m 14s
-
(Locked)
Configuring task concurrency2m 58s
-
(Locked)
Configure processors to execute SQL queries4m 25s
-
-
-
-
-