Table of contents
- General description
- The different parts of the Database Transformer
General description
This Database Transformer can be used to interact with databases via a pre-configured or inline-configured connection. By using this 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.
The different parts of the Database Transformer
-
Database client (required)
This specifies the connection configuration that is needed to access the database. This can be created inline or as a pre-configured one. -
Destination (required)
This defines the path within the context data where the result of the query will be placed. -
Query type (required)
Currently, only the RAW query type is available. This means that it needs to be a native SQL type query. -
Query
This required with the RAW query type. The SQL statement that will be sent to the configured client. This field supports placeholders, so data from the context data can be inserted into the query. The types of queries that can be executed depends on the authorization level of the user who is configured in the client. Use caution with users that have full database control, as it is possible for them to run potential database damaging queries that could result in structure changes or data loss. -
Logging
This activates the logging of the executed queries.
