You can create an inbound routing rule for a Database connector by using Server Administrator > RuleSets. A database connector must be set up before you can create any rules for it.
Note: You can create custom database connector rules by using a rule template, for example, Route to Connector or by duplicating other database rules that may exist in the Default folder and modifying the criteria and actions as needed.
To create an inbound routing rule for a Database connector
The following general instructions can be used to assist you with creating custom database connector rules. You will need to specify the criteria, actions, and other properties needed to fulfill your specific workflow requirements.
- Inside the Server Administrator, expand RuleSets.
- Right-click User. The Properties shortcut menu appears.
- Select New > Route to Connector. The Criteria dialog box appears.
- Select a destination type, for example, Provider Key from the Destination Type drop-down list.
- Specify the criteria in the Matches box.
-
Select Next. The Deliver dialog box appears.
-
Select a connector, for example, Database on the Server from the Connector drop-down list
-
Specify your format and other delivery parameters.
-
Select Next. A default rule name appears in the Rule Name box.
- Rename the rule (optional) or use the default rule name.
- Select Finish. The rule appears in the User RuleSet folder.
Customizing a rule's criteria and actions
You can use the default settings or modify as needed.
-
Select the Database connector rule in the User RuleSet folder details pane. The Rule Properties dialog box appears.
-
Select the Criteria tab.
-
Modify the criteria in the Criteria Expression box if necessary.
-
Use the Insert button to insert additional system or user-defined job properties.
-
Select OK.
-
Select the Actions tab.
-
Select the action you want to modify, for example, Deliver. The Action Properties dialog box appears.
-
Use the Deliver parameters or modify as needed.
-
Select the Job Properties tab and use the Add button to select a job property and specify a value if necessary.
-
Select OK.
-
Use the Import button to import values from an XML file. (optional)
-
Select the On Failure tab and specify If the action fails parameter by choosing the appropriate options.
-
Select OK.
-
Select the Criteria tab and choose if the action applies to all jobs or jobs matching specific criteria.
-
Use the Insert button to insert additional system or user-defined job properties if necessary.
-
Select OK.
-
Select OK on the Action Properties dialog box.
-
Select OK on the Rule Properties dialog box.
Note: Contact Technical Support if you need assistance with creating custom database connector rules.