validation of Attributes against database

[#1]

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.

thanks!

[#2]

@MattWho 

Could you please look at this issue.

thanks!