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

oracle to oracle data movement using nifi


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