Start Transaction

Starts a database transaction and allows all the children database activities to use the same transaction. It can use either an existing connection or create another one using the Provider Name and Connection String.

Start transaction designer

Properties#

Start transaction properties

Input#

  1. Connection The connection opened using OpenConnection activity. We can either set the connection or create another one using Provider Name and Connection String.
  2. Connection string Database connection string. As an example, for the example below the format is "Driver={PostgreSQL ODBC Driver(UNICODE)};Server=127.0.0.1;Port=5432;Database=postgres;UID=postgres;PWD=yourpassword"
  3. Provider Name The provider used to connect to the database. For instance, in the example below we use Odbc to connect to a postgres database.

General Properties#

See General Properties.

Misc#

See Misc.

Out Error#

See Out Error.

Output Properties#

  1. Out Connection The connection generated using Provider Name and Connection String, or the existing connection set through Connection property.

Example#

Please check Open database connection example.