Relational Database Activities
Use the RDB group to run SQL against a relational database from a workflow. The activities share a Connection resource and cover reading, writing, and removing rows.
Available activities
| Activity | Purpose |
|---|---|
| Connection | Stores the host, port, database, credentials, and database type |
| Query | Runs a SQL query and returns the resulting rows |
| Upsert | Inserts or updates rows |
| Delete | Removes rows |
Configure a database operation
- Add a Connection resource and select the database type.
- Enter the host, port, database name, and credentials.
- Add Query, Upsert, or Delete to the workflow and select the connection.
- Choose the schema and table, then write the SQL statement.
- Map the statement's inputs and the returned rows.
Recommended practices
- Parameterise statements through the Input mapping rather than concatenating values into SQL.
- Store credentials in the Connection resource; do not place them in workflow mappings.
- Set a batch size on Query and Upsert when working with large result sets.
- Test against a non-production database before promoting the workflow.