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

Change data capture from DB2 using NiFi

Solved Go to solution

Change data capture from DB2 using NiFi

Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Change data capture from DB2 using NiFi

Mentor

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.

View solution in original post

3 REPLIES 3

Re: Change data capture from DB2 using NiFi

Mentor

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.

View solution in original post

Re: Change data capture from DB2 using NiFi

Mentor

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

Did we got any fix for this ? or sti ...

New Contributor

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