Transaction Database Insertion Processor
The Transaction Database Insertion Processor inserts the transaction contents into a database table and sets transaction attributes to generated keys values.
Processor (Adapter) Configuration Drop-Down List
Select the Transaction Database Insertion from the drop-down and click on Add Processor.
Click on Add Processor
Basic Transaction Database Insertion Processor Configuration Options
The Basic tab allows you to set:
- Username – username for JDBC connection
- Password – password for JDBC connection
- Driver – driver for JDBC connection
- URL – URL for JDBC connection
- Query – query for JDBC connection
- Use ‘Output’ – collects inserted IDs by OUTPUT SQL operator. This may be necessary if the GUID column is used as ID (key). If this option is checked, it is expected that insert Query will have OUTPUT Inserted.{ColName} Operator. NOTE: Applicable only for Microsoft SQL Server!
- Parameters – the parameters for JDBC query
- Data Column Type – specifies the encoding type of data. Options are ASCII Stream, Binary Stream, BLOB, or CLOB.
Transaction Database Insertion Processor Basic Configuration Options
Conditional Execution Transaction Database Insertion Processor Configuration Options
On the Conditional Execution tab, you can set additional Processor execution conditions. The transaction data-dependent condition may be specified here as an enhanced expression. If this expression returns anything other than TRUE (ignore case) – this processor will be skipped. No additional configuration for this Processor is required.
Transaction Database Insertion Processor Conditional Execution Configuration Options