Description:

SQLLookupService provides a lookup service based on given lookup table key and incoming flow files. Each record from the flow file compares with the lookup key and returns the lookup column value for the matched record.

Tags:

sql, lookup, key, value, table, record

Properties:

Name	Default Values	Allowable Values	Description
Database connection service			The Controller Service that is used to obtain a connection to the database in which the lookup table is available.
Table Name			The name of the table to be used for lookup Supports Expression Language: true
Lookup Value Column			Column to be returned from lookup table for which the key and record matches. Supports Expression Language: true
Lookup Key Column			Column to be used as lookup key. Supports Expression Language: true