Please check this old post on how to connect to mysql I assume its similar to oracle: https://community.cloudera.com/t5/Support-Questions/how-to-configure-and-connect-mysql-with-nifi-and-perform/td-p/109478   ... View more

I apologize for that, I hope someone else step in and help you with better solution. May I just know why it did not help? ... View more

I thought we discussed this here: https://community.cloudera.com/t5/Support-Questions/How-to-load-json-record-to-postgres-as-json-datatype/m-p/345779#M234644   ... View more

This is not efficient and will use a lot of heap depending on how big the list and the json array. Can you explain more what are you trying to do  and why you want to create different variable for each json flowfile? Maybe there is a better way. ... View more

Hi, The string you are getting is not a valid json, so you need to use ExecuteScript Processor to parse the string and convert into array and then convert the array into json array. You can convert this string into array by removing curly brackets and then do split(',') then you can convert the array into json using something like: https://www.javaguides.net/2019/07/convert-set-to-json-array-using-jackson.html Pass the converted Json Array as new flowfile from the ExecuteScript Processor. Lets assume that your json array looks like this:   ["1","1","1","3465689","B4:E6:2D:34:E1:D9"...]   Then you use Json Jolt Processor and pass the following Jolt Spec:   [  {    "operation": "shift",       "spec": {              "*": {                    "@0": "Value-&0"                  }               }        } ]   which will give the new flowfile as follows:   { "Value-0" : "1", "Value-1" : "1", "Value-2" : "1", "Value-3" : "3465689", "Value-4" : "B4:E6:2D:34:E1:D9" ... }   Hope that helps. If it does please accept solution. Thanks Samer ... View more

Hi, Which system did you install Nifi on ? If windows try to click any Java job running in the background and restart nifi. ... View more

By the way what is inside the users.xml file? ... View more

Sure, I hope they can help. By the have you seen my comments above about defining the nodes in the auotherizers.xml with the following format (case sensitive):   CN=masternode, OU=NIFI CN=workernode02, OU=NIFI CN=workernode03, OU=NIFI   ... View more

Just to be on the safe side, can you define the nodes in the authorizers.xml as follows. Keep in mind when you define something in the nifi config files its is case sensitive.   CN=masternode, OU=NIFI CN=workernode02, OU=NIFI CN=workernode03, OU=NIFI ... View more

@MattWho,@araujo , can you guys help? ... View more