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.
To configure the Database Query Functionfunction, specify the following information:
...
The output from the DB Query is kept in the parameter queryResult (including any sub-parameter). The queryResult is added to the payload and is passed on to the next node function in the stream. The output is made immutable, that is, it can not be edited or changed. If you still want to use and modify an object, you can use a script node to clone the complete content of queryResult, or any sub-parameter in it.
...
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
The lookup criteria are the space where 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.
...
| 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. Minimum The minimum value is 1 and there is no upper limit to this value.
...