Matcher Activity

Matcher has two primary functions.

Its main purpose is to take Instream result files and bring match data into the Transaction Insight database, then match those data records to existing Transmissions. This establishes key database links that can be used in the Transaction Insight user interface.

The secondary use of the Matcher component is to perform scheduled (Timer driven) purges of the Match data. This is a regular maintenance task which is independent of the regular matching behavior.

Note: Parameters entered into BusinessWorks will be passed directly along to the Matcher executable installed with Transaction Insight.

General

The General tab contains the following fields:

Field Literal Value/Module Property/Process Property? Description
Name No (Required) The name to be displayed as the label for the activity in the process.
TI Binaries Directory string (Required) Location of TIMatcher.jar.
Matcher INI File string Path and filename of matcher.ini file that specifies the other command line parameters.
Match Window integer Specifes how many days back the matcher should look for data that matches this file. Default is 30 days.

Description

The Description tab is used to provide a short description for the activity.

Advanced

The Advanced tab contains the following fields.

Input Item Datatype Description
Purge Match Data boolean Should old matching criteria be purged?

Checked = yes

Unchecked = no

Purge Batch Size integer Number of rows to delete from a table before committing.

Default is 0, which deletes all rows in one transaction.

Encrypt INI string Encrypts database information by modifying the ini file. ini specifes the location of your ini file.

Example: C:\example\Importer.ini

Input

The Input tab contains the following fields.

Input Item Datatype Description
DatabaseConnectString string Connection string for the Transaction Insight database:

Example (Oracle)

jdbc:oracle:thin:username/password@dbserver:port:instance

Example (SqlServer)

jdbc:sqlserver://dbserver:port;databaseName=dbname;user=myuser;password=mypass;

ConnectionAttempts integer

Number of times Matcher will attempt to connect to a database before timing out. Minimum value is 1, with no upper limit. Default is 3.

InstreamFile string Path and filename of TIBCO Foresight Instream detail results file.

Example: -r "C:\files\My835.dtl"

LogfileLocation string

Path and filename to the log file.

LogLevel integer Logging level:

0 = Errors only

1 = Warnings and Errors

2 = Info, Warnings and Errors

Output

The Output tab contains the following fields.
Output Item Datatype Description
ReturnCode string The Matcher return code.

Refer to Error Codes.

Fault

The Fault tab lists errors that might occur when you use this activity.

Error Schema Element Datatype Description
msg string Error message description.
msgCode string The error code.