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

Data ingestion Nifi

Data ingestion Nifi

New Contributor

Hi, I´m really new using nifi and Data ingestion. I´m trying to get data from Oracle database using Nifi and put data into Yugabyte database tables.

 

1.- Nifi get data information from ETL table
2.- Nifi put data into ETL Yugabyte table
3.- Yugabyte table puts ETL data information in Master table using trigger.

This is working good, my question is about how  can I handle the schema changes in data ingestion?, for example, if I add a new column in ETL table on oracle table how  can I manage it to make this change on yugabyte side? Current I have to stop nifi, wait to queue is clear then add the column in yugabyte ELT and Master table and finally start nifi again.