Attribute validation against MSSQL database

[#1]

I have to implement one scenario using Nifi flow.

1. There is one attribute from upstream processor like 

   KeyValue : KGPYT

2. I have to find whether KeyValue is unique in the system or not , by validation from Database.

   If it is not found in the database, the flowfile should be proceed to success and 

  if the value is present in database, it should be proceed to failure.

Please suggest me how to proceed in this case.

thanks!

[#2 · Accepted solution]

I think you are probably looking for the LookupAttribute processor. (Or possibly the LookupRecord processor).

It should allow you to look up the value somewhere (e.g. in a database) and afterwards you can route on the outcome. Either directly based on matched/unmatched or if it is more complicated (e.g. the depending on what you actually found) perhaps using something like RouteOnAttribute.

[#3]

@midee, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  I

[#4]

@DennisJaheruddi ,

Thanks for your reply and will implement your suggestion.

thanks!

Deepak

[#5]

@midee, were you able to implement the suggestions? Has the reply helped resolve your issue? If so, can you please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future?