Similar to the lookup table, this mapping maps the value of a field in an external datasource (typically a sql database). To do the enrichment, a connection string, username, password and query need to be defined.
Attribute | Required | Description |
|---|
from | Y | Defines the field name before mapping. |
to | Y | Defines the field name after mapping. |
precedence | N | Defines the precedence used when mapping. |
| Function type | Y | Defines the function type of the mapping. Needs to be "Enrichment/lookup functions" |
Function | Y | Defines the type of mapping. Needs to be "lookup values in an external datasource". |
connection string | Y | Defines the connection string to the database. |
| user | N | Defines the username used to connect to the database. |
| password | N | Defines the password used to connect to the database. |
query | Y | Defines the query to execute. |
The wildcard in the query will be replaced with the "from" field value.
In the following example a customer name is searched by id. The customer id value is replaced in the query to extract the customer name from the database.
