I am trying to insert data from Apache NIFI to Mongo DB. Is there any way to Know the Query Execution time, Time taken to insert in to Mongo DB from NIFI? I am using put Mongo Processor. ... View more

I am using NIFI on a local machine- Version 1.16 I am adding the data to Mysql DB from NIFI,There is no problem till this step,  I am able to successfully put the data in to the local mysql. But in the attributes sections in the queue after execute sql, i am not able to see the Execution time, or any of the Writes attribute mentioned in the document (https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.16.0/org.apache.nifi.processors.standard.ExecuteSQL/index.html) ( I am able to see only one attribute i.e  executesql.row.count, It is also being displayed as zero even though the query is success)   I Need to know the time it took for a query to get processed from NIFI.     ... View more

I have tried to connect local NIFI to Local mysql, I have been getting an error on the processor "cannot create poolableconnectionfactory communications link failure nifi". JDBC Url and Driver are correct. i assume there may be an error while connecting with Mysql.   And also i have tried to Connect local NIFI in mac with local Mysql, i am facing an error while i enable the DBCP connection pool the error is mentioned in the image.   Thank you ... View more