I have to validate value of some attribute of flowfile against MSSQl database.
Attribute Keys are Key_project and Project_Name and Table name is CreateProject with column as Projectkeys(it will have all the values of Key_project) and Name(contain the ProjectName).
I have to check the values of attributes from upstream processor whether they are present in database or not.
I have used LookupAttribute processor along with SimpledatabaseLookup service, but no success.
Could someone help me how to configure SimpledatabaseLookup service along with examples.
Could you please look at this issue.