From the course: Data Management with Apache NiFi

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Configuring the DBConnectionPool controller service

Configuring the DBConnectionPool controller service - Apache NiFi Tutorial

From the course: Data Management with Apache NiFi

Start my 1-month free trial Buy for my team

Configuring the DBConnectionPool controller service

“

- [Instructor] We still haven't finished configuring our PutDatabaseRecord processor. Now in order to be able to write to a database, this processor needs access to the JDBC JAR file, and it's available here at jdbcpostgresql.org/download. This is the binary JAR file that the processor will use to connect to our PostgreSQL database. Go ahead and download the JAR file for Java 8. This will work for any version of Java that you use as long as it's Java 8 and above. I'm going to create a new folder called JDBC under my tools directory, and I'm going to copy over this Postgresql.jar over to the JDBC folder. This is just so that the JAR file is in a known location. Now let's go back to configuring PutDatabaseRecord and notice that we have a database type specification here. If you hover over this, this is where you specify the kind of database you connect to, which in our case is PostgreSQL. So instead of having generic here,…

Contents