@AbhishekSingh ,   The CaptureChangeMySQL processor acts as a MySQL replication slave. It requires the REPLICATION_SLAVE privilege in MySQL.   Following the steps in the documentation and create a separate user to use in your processor.   Cheers, André     Cheers, André ... View more

@AbhishekSingh  1. @araujo response is 100% correct. 2. Just to add to @araujo respsonse here...  NiFi-Registry has nothing to do with controlling what user can and can't do on the NiFi canvas.  It simply allows users if it is installed to version control process groups.  Even once a NiFi process group has been version controlled, authorized users in NiFi can still make changes to dataflows (even those that re version controlled).  One they do make a change to a version controlled Process Group, that process group will indicate that a local change has been made and the authorized user will have the option to commit that local change as a new version of the dataflow.  Controlling what users can do with dataflows is handled via authorization policies which NiFi handled very granularly.  Authenticated users can be restricted to only specific Process Groups. Your NiFi admin user  can setup NiFi authorization for other user per Process Group if they want by selecting the Process Group and clicking on the "key" icon in the "operate panel" on the left side of the NiFi canvas.   If you found any of the responses provided assisted with your query, please take a moment to login and click on "Accept as Solution" below each of those posts. Thank you, Matt ... View more

@cnelson2  Are you specifying the database to use in your DBCP connection pool service?  -> yes I solve this issue. I have given Catalog Name : destinationDBName and Make empty schema Name value in putdatabase  record processor. Now I am able to perform insert , update and delete action source to destination 'user' table. Thanks,     ... View more