https://community.cloudera.com/t5/Support-Questions/How-to-display-the-delta-changes-for-a-db-using-nifi/m-p/287792#M213235 <OL> <LI><A href="https://www.cloudera.com/downloads/hortonworks-sandbox/hdp.html" target="_blank" rel="noopener">Download HDP Sandbox</A></LI> <LI>MySQL database (Should already be present in the sandbox)</LI> <LI>NiFi 0.6 or later (Download and install a new version of NIFI or use Ambari to install NIFI in the sandbox)</LI> </OL> <P>Use this code:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE> insert into cdc_test values (3, 'cdc3', null, null); insert into cdc_test values (4, 'cdc3', null, null); insert into cdc_test values (5, 'cdc3', null, null); insert into cdc_test values (6, 'cdc3', null, null); insert into cdc_test values (7, 'cdc3', null, null); insert into cdc_test values (8, 'cdc3', null, null); insert into cdc_test values (9, 'cdc3', null, null); insert into cdc_test values (10, 'cdc3', null, null); insert into cdc_test values (11, 'cdc3', null, null); insert into cdc_test values (12, 'cdc3', null, null); insert into cdc_test values (13, 'cdc3', null, null); </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>I hope this helps!</P> <P>Regards,</P> <P>Lewis</P> Wed, 04 Mar 2020 21:46:23 GMT Lewis 2020-03-04T21:46:23Z