Change data capture from DB2 using NiFi

[#1]

We've some mainframe with DB/2 and we need to bring every new record written inside DB/2 to Hadoop (Hive ORC table) in the fastest way possible. Is Nifi capable of doing such a thing?

[#2 · Accepted solution]

The current approach is to use sqoop incremental job, nifi has no support for CDC. You can also look at Attunity Replicate or GoldenGate for CDC.

[#3]

Nifi just added QueryDatabaseTable for simple change capture https://cwiki.apache.org/confluence/display/NIFI/Release+Notes

[#4]

Did we got any fix for this ? or still NIFI does'nt support CDC from DB2 ?