Comparing PostgreSQL iPaaS Connector and webMethods JDBC Adapter Transaction Handling in Workato

Hi Team, I'm currently working on a migration/POC involving PostgreSQL iPaaS connector in Workato and evaluating transaction handling compared to webMethods JDBC Adapter. In webMethods, we have transaction options such as: No Transaction Local Transaction XA Transaction We're using the PostgreSQL connector in Workato to perform database operations (Insert, Update, Upsert, Custom SQL), and I'm trying to understand if there is any equivalent support for: Local transaction management Commit/Rollback control Transaction monitoring Distributed/XA-style transactions Specifically, has anyone implemented a scenario where multiple database operations need to be rolled back on failure, similar to webMethods Local Transaction behavior? If you've worked on a similar use case, could you please share: The approach used Whether transaction control was handled in Workato or at the database layer (stored procedures/custom SQL) Any limitations encountered with PostgreSQL connectors Thanks in advance!