Skip to main content
Version: 4.52.0

DB Query

The Database Query component allows you to make SQL-Queries. The component makes a connection to the specified SQL-like server using its configuration.

Supported databases are:

  • MySQL
  • MSSQL
  • OracleDB (has been tested with OracleDB 23, support for older version might be limited)
note

Postgres is activated but not further implemented or validated. Feel free to try it out. Also, note that it might require third-party libraries.

Configuration

Usage with OracleDB

Inputs | Outputs


DB Query
Input
Output
Finished Output
Error
00 0 (ilwuv41)

The incoming message isn't used unless the query uses a variable from this object. The incoming message can be empty if you don't need any variables.

Example:
//query in config:

SELECT * FROM documents WHERE kind="{{kind}}"

//incoming message:
{
kind: "CONTAINER"
}