Support Questions
Find answers, ask questions, and share your expertise

validation of Attributes against database

Explorer

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!

1 REPLY 1

Explorer

@MattWho 

Could you please look at this issue.

thanks!