Block Properties Matching Criteria Tab

When configuring Block Properties in a Map, use the Matching Criteria tab to specify one or more fields in your source and target data to be used by TIBCO Scribe® Online for a one to one record match. For example, Delete, Update, and Update/Insert Blocks require Matching Criteria to find the record in the target data, if any, that corresponds to the current source record. If a match is found, the data in the target is updated or deleted. If no match is found, either nothing is done or a new record is created in the target depending on the Block being used.

Adding Matching Criteria

  1. Navigate to the Maps list in the Solution Edit page and select Create Integration Map from the Menu to display the Create Map dialog.
  2. Begin building your Map. When you add an Update, Update/Insert, or Delete Block, select the Block and select the Matching Criteria link in the Properties panel.
  3. From the Match Criteria tab, select Add . A matching criterion row displays.
  4. Select the blank cell under Field .
  5. Select the field to match by from the drop-down list.
  6. Under Operator, select an operation, such as equals.
  7. Select the Value field and either type in a formula or select the Formula icon to open the Formula Editor.
  8. Enter a formula, which can include fields, functions, and results from previous operations. TIBCO Scribe® Online uses this value to match fields between the source and target data for this Block. See TIBCO Scribe® Online Functions.
  9. If needed,select Add again to create another filter.

    After you select Add , the And/Or column displays. Select and or or from the drop-down list to determine how to combine match criteria. When the Map runs, the criteria is evaluated in order from top to bottom.

  10. When you are done, select Validate to make sure there are no errors.

    Note: You may not get a validation error for data type mismatches if TIBCO Scribe® Online can convert the source field to the target field data type. For example, if the source field type is a string and the target field type is a GUID, since the source field could contain a string that is a GUID, no error is generated during validation. However, if at map runtime the data in the source field cannot be matched due to a data type mismatch, you may see an error.

  11. Continue defining this Block or select OK to close the Block Properties dialog and return to the workspace.

Note: When using a formula for matching criteria, the rules are similar to those for filtering criteria. For more information, see Filtering Notes.

To delete Matching Criteria, select Delete from the Gear menu for the appropriate row.

Matching Criteria Examples

Assume that you are updating Contact addresses from one datastore into another. The criteria in the examples shown below match a Contact in the source data with a Contact in the target data.

Example 1

And/Or

Field

Operator

Value

 

CompanyName

equals

Customers.CompanyName

and

Active

equals

TRUE

or

ContactName

equals

Customers.ContactName

These settings are interpreted by TIBCO Scribe® Online as follows: 

((CompanyName=CompanyName AND Active=TRUE) OR ContactName=ContactName)

To match, one of the following must be true:

Example 2

And/Or

Field

Operator

Value

 

ContactName

equals

Customers.ContactName

or

Active

equals

TRUE

and

CompanyName

equals

Customers.CompanyName

These settings are interpreted by TIBCO Scribe® Online as follows: 

((ContactName = ContactName OR Active=TRUE) AND CompanyName = CompanyName)

To match, both of the following must be true:

Related Topics

Defining An Integration Map

Working With Blocks

UpdateWith Block

Update Block

Update/Insert Block

Delete Block