Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
 
2 REPLIES 2

avatar
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.

avatar
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 ?