Can apache nifi detect database table record change and how?

0
votes

I'm really new to apache-nifi, I'm not sure this can be achieved in the nifi processor or not?

Say I have a table called "USArrests":

Before update

The first record of "Murder" is 15.5.

enter image description here

After update

The first record of "Murder" changed to 13.2.

enter image description here

How can this change be detected by setting the processor if possible?

enter image description here

1
sql-serverapache-nifi

1 Answers

0
votes

Solved with the following:

Remove binlog_do_db from my.cnf.

Not able to explain why. Will update answer when I know (if someone does, please explain).