Yes, I wrote on article for doing CDC with NiFi for a MySQL database:
NiFi doesn't currently support MS SQL, but it appears there is a NiFi contributor who has it in the works:
Not sure if the solutions uses transactional logs or not.
Hi Alim , thanks for this very wonderful post on using Nifi as CDC. Is there a provision in Nifi to use something similar for Oracle Database ?