The Attunity Enscribe data source driver supports one-phase commit transactions. It can participate in a distributed transaction if it is the only one-phase commit data source being updated in the transaction, when the covertAllToDistributed and useCommitConfirmTable environment properties are set to true.

The Enscribe and SQL/MP data sources and the Pathway adapter share the same transaction which automatically provides consistency between Enscribe and SQL/MP. As a result, you cannot start the new transaction for SQL/MP when one is open for Enscribe.

Note: TMF is required when updating audited files.