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 
Pingback: Big Data and Stream Processing 101 – Part 4: How to Do a Simple Key-Value Enrichment in Apache NiFi – Datahovel
Hii stefan,can you pls make a video on how to connect 2 tables from MySQL in NiFi.
I am working on ELK stack and for that i want to connect mysql database to ELK. I am using nifi to connect them.
Please assist.
LikeLike