Support Questions

Find answers, ask questions, and share your expertise

CaptureChangeMysql processor help with deletes

avatar
Expert Contributor

Hi Team,

 

I am desperately looking for a helping hand here.

My flow will infuse/replicate data from different small databases into a single big database. I am using changecapturemysql processor to capture changes in small databases and putdatabase record to put into destination big database.

The table structure is same for all databases. but in order to differentiate in the big database there will be an additional column. 

Example: (let me take only a simple and single table in all databases)

in sources, city_name is the PK. in destination,  city_name and db_name  both will form the PK.

 

DB1.city table

city_name

New york

Mumbai

 

DB2.city table

city_name

Paris

New york

 

 

Destination DB

city table

city_name    db_name

New york.     DB1

Mumbai        DB1

Paris             DB2

New york.     DB2

 

I am able to capture the Inserts and Updates and put them in destination database. but when I delete a record in source, nothing is happening in the destination database. There is no error also.

How can I achieve that when i delete a record in any source DB, it needs to delete that particular record in destination DB. How to make nifi identify the record properly to delete. I also wonder how Nifi able to identify the record that need to be updated but not the record that need to be deleted. Please help.

0 REPLIES 0