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 |