Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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

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.

Mentor

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

New Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.