Log out?

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.

Select the Processor Configuration tab and click on Add Processor.

processor-transaction-database-insertion-01-13-16-r2

Select the Transaction Database Insertion Processor from the drop down.

Select the Basic tab.

Here, the user should enter the credentials, URL and Query for JDBC connection then choose the driver:

processor-transaction-database-insertion-04-13-16-r2

The Use ‘Output’ checkbox is used to collect inserted IDs by OUTPUT SQL operator. This may be necessary if GUID column is used as ID (key). If checked – it is expected that insert Query will have OUTPUT Inserted.{ColName} Operator.

NOTE: Applicable only for Microsoft SQL Server!

The Parameters field allows the user to set the parameters for JDBC query.

The Data Column Type specifies the encoding type of data: it could be ASCII Stream, Binary Stream, BLOB or CLOB.

In the Conditional Execution tab, you can set additional processor execution conditions. The Transaction data dependent condition may be specified here as 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.

This is a unique website which will require a more modern browser to work! Please upgrade today!

Thanks!

Our editors are notified.

Close