Support Questions
Find answers, ask questions, and share your expertise

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

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

 
2 REPLIES 2

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.

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

Expert Contributor

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 ?