Hi, I am a newbie in NiFI and i have a use case i am currently working and i need your kind help. USE CASE: 1. Invoke an endpoint using InvokeHttp 2. collect response using HandleHttpResponse 3. publish the response to any monitoring platform like Grafana.   I was able to accomplished 1 & 2. But i couldn't find any help on how to publish response to Grafana. I would be glad if you can kindly put me through. Thank you for assistance. ... View more

I am a newbie in NIFI, Please, i need help. I am updating DB using NIFI. I have two(2) DB servers. One of the DB is a backup in case the first DB failed. So, i connected the second DB(DB2) to the "failure" leg of the first (DB1). ISSUE: Upon failure of DB1, DB2 would start processing files, but the problem is the file would go to DB1( which has already failed) before going to DB2 & and this is taking much time. My flow is timebound because i should be able to update the DB as fast as possible. How can i stop DB1 after failure & reroute flow to DB2 automatically. At the moment i am doing it manually and sometimes DB1 goes down in the middle of the night while i am still sleeping. Thank you for your kind help. Attached is a depiction of my flow    ... View more

Hi, I am still a beginner in using NIFI. I would like to query a database & pull record on a daily basis. And each day record would be converted to CSV and write to a directory. I have checked this method: https://community.cloudera.com/t5/Support-Questions/Fetch-records-from-a-database-incrementally-based-on-time/td-p/175653 But i would like to know if there is any other simpler way of doing it. Thank you so much. ... View more

Hello, I am still a newbie in NiFi.  I Json flowfile that i want to persist in a database using ConvertJsontoSql & PutSql. I have no problem if the names of keys in Json flowfile match with the columns name in the database. But if the keys names are different from column names whilst referring to same thing. For example: Flowfile attribute:  surname Database column: lastname I have no access to alter database. And i have tried JoltTransform which didn't work. Please, how do i map json keys to columns names , even if the key names change it would still point to the same column in the database. Thank you.     ... View more