Manage query transform templates

In the navigation pane, select Integration Designer > Manage Templates.

Specify this information:

Task type

Select QueryTransform as the task type.

Templates

Select a template from the list.

To copy the selected template, click Copy and specify a template name.
To delete the selected template, click Delete.
To create a new template, click New and specify a template name.

Resource type

By default, the resource type is set to Entity. This resource type performs query tasks from a database.

Multiple results

Select to enable your query to return multiple records.

Is Polling

Select to enable polling support. If selected, the query continually performs the task until specified conditions occur.

Polling Timeout

Specify a polling timeout in milliseconds. The default timeout is 6000 milliseconds.

Integration Type

By default, the integration type is set to BODArea. This integration type performs a BOD/XML type operation.

Specify entity information:

Entity Alias

Select an entity alias from the list.

You can add entity aliases in the Database Entities module.

See Identifying supported database tables.

Note: Entity aliases depend on the selected connection string.

Entity

Select an entity from the list.

Note: The list of entities are based on the specified connection string and entity alias.

Based on the selected integration type, specify this information:

Entity integration type:

Entity Alias

Select an entity alias from the list.
You can add entity aliases in the Database Entities module.
See Identifying supported database tables.
Note: Entity aliases depend on the selected connection string.

Entity

Select an entity from the list.

Transaction Type

Select a transaction type from the list.

If Exist

Select skip or update from the list.
Note: This field is available only if you select Insert as the transaction type.
BOD integration type:
BOD Type
Select any of these BOD types from the list:
- Acquire from XML Parameter
  This BOD type obtains the BOD/XML value from the xml parameter within the flow.
- Acquire from File
  This BOD type obtains the BOD/XML value from a file.
  Note: This is applicable for Work unit type FileUnit.
- Dump to XML Parameter
  This BOD type saves the BOD/XML value to the xml parameter within the flow.
- Dump to File
  This BOD type saves the BOD/XML value to a file.
  Note: This is applicable for Work unit type FileUnit.
Integrate From

Specify a path where the values are acquired.
Note: This field is available only if you select Acquire from XML Parameter or Acquire from File as the BOD type.

Integrate To

Specify a path where the values are dumped.
Note: This field is available only if you select Dump to XML Parameter or Dump to File as the BOD type.

Folder

Specify a folder path where the XML files are located. Click the ellipsis button to browse for a folder.
Note: This field is available only if you select Dump to File as the BOD type.

Prefix

Specify a prefix to be used for the file names of the XML files.
Note: This field is available only if you select Dump to File as the BOD type.

Null Parameter Skip

If selected, parameters that contain null values will be skipped during the processing of the integration task.

This check box is automatically selected if the task type is QueryTransform.
BODArea integration type:
Entity Alias

Select an entity alias from the list.
You can add entity aliases in the Database Entities module.
See Identifying supported database tables.
Note: Entity aliases depend on the selected connection string.

Entity

Select an entity from the list.

BOD Type
Select any of these BOD types from the list:
- Acquire from XML Parameter
  This BOD type obtains the BOD/XML value from the xml parameter within the flow.
- Acquire from File
  This BOD type obtains the BOD/XML value from a file.
  Note: This is applicable for Work unit type FileUnit.
- Dump to XML Parameter
  This BOD type saves the BOD/XML value to the xml parameter within the flow.
- Dump to File
  This BOD type saves the BOD/XML value to a file.
  Note: This is applicable for Work unit type FileUnit.
Integrate From

Specify a path where the values are acquired.
Note: This field is available only if you select Acquire from XML Parameter or Acquire from File as the BOD type.

Integrate To

Specify a path where the values are dumped.
Note: This field is available only if you select Dump to XML Parameter or Dump to File as the BOD type.

Folder

Specify a folder path where the XML files are located. Click the ellipsis button to browse for a folder.
Note: This field is available only if you select Dump to File as the BOD type.

Prefix

Specify a prefix to be used for the file names of the XML files.
Note: This field is available only if you select Dump to File as the BOD type.

Null Parameter Skip

If selected, parameters that contain null values will be skipped during the processing of the integration task.

This check box is automatically selected if the task type is QueryTransform.
M3WS integration type:

Program

Select a program from the list.
Note: The list contains the available and supported MI programs. To add an MI program, specify an MI program name and click Add.

Transaction

Select a transaction from the list.
Note: The list contains all available transactions for the selected MI program.

On the Parameters tab, specify this information or update the existing parameters:

Name: Specify a parameter name.
Field Name: Specify a field name.
Note: This field is available only if you select M3WS as the integration type.
Column Name: Select a column name from the list.
Default Value: Specify a default value.

On the Conditions table, specify this information or update the existing conditions:

Field Name: Specify a field name.
Condition Type: Select a condition type from the list.
Condition Value: Specify a condition value.

Click Save.

Note: To see the integration flows that uses the selected integration template, click the Where Used tab.