dspConduct

Task Final Finish Tables H

Task Final Finish Tables V

Use this page to:

To access this page:

  1. Click dspConduct > Design in the Navigation pane.
  2. Click the Tasks icon for a category.
  3. Click the Final Finish Tables icon for a main parent task.

Field

Description

FINISH TYPE

Displays whenever tables:

  • Are downloaded (CranPort)
  • If the Finish Type is CranPort, then a corresponding table definition must exist in Collect.
  • Use a Data Services Job that runs to download the tables (DataServices) to pull data from the source environment and add it to the target environment.

NOTE: If the Finish Type is DataServices, the Data Services Job must exist in the Data Services Data Source.

  • Use DBMoto® to keep the target table synchronized with the source table.

NOTE: If the Finish Type is DBMoto, then a corresponding table definition must exist in Collect.

PRIORITY

Displays the execution order of CranPort packages or Data Services jobs.Does not apply to DBMoto packages.

The execution order of packages is by priority of the role (specified on the Role page) to which the task is assigned, and then the order is specified by the order in which the package is added on the Task Final Finish Tables page.

DATA SERVICES JOB NAME

Displays the name of the job written in Data Services that is used to pull data from the source environment and add it to the target environment.

NOTE: This field is not available for Finish Type of CranPort or DBMoto®.

SOURCE

Displays name of the source database registered in Collect where tables are downloaded from.

NOTE: This field is not used when registering a Data Services job

TARGET

Displays name of the target database registered in Collect where table data is refreshed from the source database.

NOTE: This field is not used when registering a Data Services job.

TABLE NAME

Displays name of table downloaded from the source database when the Finish role is processed for the assigned role.

Task Final Finish Tables V

Task Final Finish Tables H

NOTE: The fields that display on this page are determined by the selected Finish Type.

Field

Description

Finish Type

Displays whenever tables:

  • Are downloaded (CranPort)

NOTE: If the Finish Type is CranPort, then a corresponding table definition must exist in Collect.

  • Use a Data Services Job that runs to download the tables (DataServices) to pull data from the source environment and add it to the target environment.

NOTE: If the Finish Type is DataServices, the Data Services Job must exist in the Data Services Data Source.

  • Use DBMoto® to keep the target table synchronized with the source table.

NOTE: If the Finish Type is DBMoto, then a corresponding table definition must exist in Collect.

Priority

Displays the execution order of CranPort packages or Data Services jobs. Does not apply to DBMoto packages.

The execution order of packages is by priority of the role (specified on the Role page) to which the task is assigned, and then the order is specified by the order in which the package is added on the Task Final Finish Tables page.

Source

Displays name of the source database registered in Collect where tables are downloaded from.

NOTE: This field is not used when registering a Data Services job.

Target

Displays name of the target database registered in Collect where table data is refreshed from the source database.

NOTE: This field is not used when registering a Data Services job.

Table Name

Displays name of table downloaded from the source database when the Finish role is processed for the assigned role and used only for a Finish Type of CranPort.

Run Rules After Download

This option determines the Collect rules to run on a table after download when a user with the Post role clicks Finish for the request on the Request Role page. Options are:

  • All – Run all of the rules: If multiple rules are registered to the table in Collect, dspConduct™ runs them on the table after download in the order the rules were added on the Collect Table (Rule) page.
  • None – Do not run any rules: Though rules are registered to the table in Collect, dspConduct™ does not run those rules on the downloaded table.
  • NoParametersOnly – Run only Collect rules that do not contain input parameters, such as an Insert rule.
  • ParametersOnly – Run Collect rules that contain input parameters, such as an Update rule.

NOTE: The rule(s) must have already been registered and activated in Collect.

NOTE: This field does not display if the finish type is Data Services or DBMoto®.

Data Services Data Source

Displays the name of the data source that stores the Data Services job.

NOTE: This field is not available for Finish Type of CranPort.

Data Services Job Name

Displays the name of the job written in Data Services that is used to pull data from the Source environment and add it to the target environment.

NOTE: This field is not available for Finish Type of CranPort.

Where Clause Builder

Click to open the Task Final Finish Where Clause page. Where Clauses should be specified for Finish Type of CranPort.

NOTE: This field does not display if the finish type is Data Services.

Global Variables

Click to open the Data Services Global Variables Setup page if the Data Services job is to run on one table only.

NOTE: This field is not available for Finish Type of CranPort.