Skip to main content
The database transformer can be used to interact with databases via an pre- or inline configured connection. By using the transformer it is possible to directly interact with a database to either retrieve or store data. All queries can be executed from generating tables to removing records. However this can be limited based on the rights of the used account to connect to the database.

​
Fields

​
Database client

The connection configuration that is needed to connect to the database. This can be inline created or a pre-configured one.

​
Destination

A path in the context data where the result of the query will be placed.

​
Query type

At the moment only raw query is available. This means that the query needs to be a native SQL type query.

​
Query

The SQL statement that will be sent to the configured client. It supports placeholders so data from the context data can be inserted into the query. The types of queries that can be executed depend on the authorization level of the user that is configured in the client. Be careful with users that have full database control as it opens the possibility to run potential database damaging queries like structure changes or data loss.

​
Logging

Activates the logging of the executed queries.

​
Sample data

Input data 
{
  "identifier": 1234
}
Destination: result Query: SELECT * FROM products WHERE identifier="&{identifier}" Result 
{
  "identifier": 1234,
  "result": [
    {
      "identifier": 1234,
      "productName": "T-Shirt",
      "sku": "tshirt",
      "weight": "1",
      "updatedAt": "2025-01-07 11:30:00"
    }
  ]
}