Local Workflow Engine
The local run configuration runs workflows on your local environment.
Make this workflow transactional
If you enable this there will always be just one connection used per database. At the end of the workflow there will be a commit or rollback (in case of error) on all named connections at the same time. Note that child pipelines and workflows are also automatically run as a transaction. Also be aware that while you can commit and rollback across multiple databases that this still means that you can have a successful commit on one database and a failure on another. This is not a two-phase-commit system.