The Database Query (DB Query), a processor function, helps the user request data from a database and enrich the data in your stream. The data retrieved from the database can be from multiple tables.
...
The information required to access the external database.
| Field | Description |
|---|---|
| Database Type | This selects the database type. The supported options are:
|
| Database Name | Specify the name of the database you want to retrieve the data. |
| Hostname or IP Address | Specify the 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:
|
Authentication
The authentication information to log in to the external database.
| Field | Description |
|---|---|
| Username | Specify the username for the authentication. |
| Password | Specify the password for the authentication. |
SQL Select Statement
In this input field, you specify the statement that you can use to query data from the selected database. For example, SELECT, AS and OR, and so on.
...
Enter a suitable number for Maximum items in cache (0 = no limit). The default value is 100. There is no upper limit to this value.
| 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. |
Enter a suitable number of seconds for Items are removed from cache after. The default value is 300. The minimum value is 1 and there is no upper limit to this value.
...
| Note | |||||
|---|---|---|---|---|---|
| |||||
The Database Query function supports Variable Insertion when writing SQL statements.
|
...