question Re: Attribute validation against MSSQL database in Support Questions

Attribute validation against MSSQL database

midee — Wed, 04 Aug 2021 10:27:46 GMT

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!

Re: Attribute validation against MSSQL database

DennisJaheruddi — Wed, 04 Aug 2021 12:59:34 GMT

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.

Re: Attribute validation against MSSQL database

VidyaSargur — Mon, 09 Aug 2021 05:25:28 GMT

@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

Re: Attribute validation against MSSQL database

midee — Tue, 10 Aug 2021 07:45:58 GMT

@DennisJaheruddi ,

Thanks for your reply and will implement your suggestion.

thanks!

Deepak

Re: Attribute validation against MSSQL database

VidyaSargur — Thu, 19 Aug 2021 10:06:47 GMT

@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?