Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

Get which of create, update or delete statements triggered Querydatabasetable in nifi

avatar
Explorer
In my project I am synchronizing neo4j data with mysql by using nifi to connect to kafka and neo4j plugin Streams to bring the data from kafka to neo4j. Inside nifi I have this structure
Querydatabasetable -> UpdateAttribute -> PublishKafkaRecord

It triggers on any change and gets updated data, but to be able to optimize my neo4j code I need to know the type of query triggered in sql (insert, update, delete). It seems that I can't get it with Querydatabasetable processor, so which processor I should use for that purpose?

1 ACCEPTED SOLUTION

avatar
Frequent Visitor

I have not done that myself but CaptureChangeMySQL sounds like the processor to give you that info. 
This web page discusses how one person used that processor for tracking CDC changes from MySQL
https://nikhil-suthar-bigdata.medium.com/cdc-with-apache-nifi-65020c748ff5

View solution in original post

1 REPLY 1

avatar
Frequent Visitor

I have not done that myself but CaptureChangeMySQL sounds like the processor to give you that info. 
This web page discusses how one person used that processor for tracking CDC changes from MySQL
https://nikhil-suthar-bigdata.medium.com/cdc-with-apache-nifi-65020c748ff5