Demo Video
Apache NiFi can be used to connect to (almost) any system, process data and put it into (almost) any (other) system.
In this video, I show specifically how to connect to a relational database, in this case MySQL and walk you through the most basic options you have.
Enjoy and don’t forget to ask questions or give me feedback!
Configuration
Here are the screenshots of the NiFi components used for reference:
- QueryDatabaseTableRecord
- MySQL Connection Pool
This is the simple database schema I used for the MySQL example table:
CREATE DATABASE company;
CREATE TABLE people(id int, name varchar(20));
INSERT INTO people (id, name) VALUES (1,'stefan');
Version Information
This demo was recorded on November 9, 2019 using the recently published version of Apache NiFi 1.10.
Datahovel 