Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

oracle to oracle data movement using nifi

Highlighted

oracle to oracle data movement using nifi

New Contributor

hi All,

I am trying copy data from one oracle DB to another Oracle DB for analytics. for that i need to handle the CDC

i have used queryDatabaseTable ->putDatabaseRecord processor for this processes and it worked fine for full table data copy whereas while configuring for CDC(UPDATE) i am facing issue with UPDATE keys. when i configure the column name as OFFER_ID it consider as OFFERID and throws error as invalid identifier while running the process. kindly help

87595-oranifi.jpg

Don't have an account?
Coming from Hortonworks? Activate your account here