The Database Query processor-type function Function helps the user request data from a database and enrich the data in your stream. The data present in the database can come from one or more tables.
To configure the Database Query functionFunction, specify the following information:
...
| Field | Description |
|---|---|
| Database Type | Select the type of database that you want to query the data from. The available options are:
|
| Database Name | Specify the name of the database you want to retrieve the data from. |
| Hostname or IP Address | Specify the host name hostname or the IP Address of the database |
| Port | Specify the port used by the database. When a Database Type is selected, the default port number is specified for each type of database. The default port numbers are:
|
...
SQL Select Statement
The lookup criteria is are the space where you specify the statement that you can use to query data from the selected database. For example, SELECT, AS and OR, and so on.
...
| Note | ||
|---|---|---|
| ||
A high value can result in an error due to memory outage. If so, the stream fails with the following error message in the log: However, this error is received for memory issues in general and can have other causes than a high value for the maximum number of items in the cache. |
...