Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Can Nifi be used for CDC from sql server by reading the transnational logs ?

Highlighted

Can Nifi be used for CDC from sql server by reading the transnational logs ?

New Contributor
 
1 REPLY 1

Re: Can Nifi be used for CDC from sql server by reading the transnational logs ?

Guru

Hi @Deb


Yes, I wrote on article for doing CDC with NiFi for a MySQL database:

https://community.hortonworks.com/articles/113941/change-data-capture-cdc-with-apache-nifi-version-1...


NiFi doesn't currently support MS SQL, but it appears there is a NiFi contributor who has it in the works:

https://github.com/apache/nifi/pull/2231

Not sure if the solutions uses transactional logs or not.