TDM Task Overview

Data provisioning and entity reservation are implemented by creating and executing TDM tasks.

A TDM task is created in the TDM Portal. It holds a list of instructions and settings that define the task action (type) and subset of processed entities, the source and target environments and additional information. For example, create a task to copy 5 customers with small and medium business plans from Production into the UAT1 target environment.

The actual data provisioning and/or entity reservation is performed by the task execution, where each task can be executed multiple times.

Task Actions (types)

The following task actions are supported by TDM:

  • Extract - extracts the selected entities and/or Reference tables from the selected source environment. The data can be saved in Fabric for a later use.
  • Generate - generates synthetic entities. The entities can be saved in Fabric for a later use.
  • Load - provisions the selected entities and/or Reference tables to the selected target environment.
  • Delete - deletes the selected entities from the target environment.
  • Reserve - reserves the selected entities in the target environment.

A TDM task can have a combination of multiple task actions.

The following table describes the valid combinations of task actions in a TDM task:

Combination

Description

Extract

  • Extracts the data from the source environment into the TDM warehouse.

Extract + Load

  • Refreshes all data from the source and provisions (loads) the data to the target environment.

Extract + Load + Reserve

  • Extracts the data from the source environment.
  • Provisions (loads) the data to the target environment and marks the entities as reserved.

Extract + Load + Delete

  • Extracts the data from the source environment.
  • Deletes and reprovisions (reloads) the data to the target environment.

Extract + Load + Delete + Reserve

  • Extracts the data from the source environment.
  • Deletes and reprovisions (reloads) it to the target environment.
  • Marks the entities as reserved.

Generate

  • Generate synthetic entities

Generate + Load

  • Generates synthetic entities.
  • Provisions (loads) the generated entities to the target environment.

Generate + Load + Reserve

  • Generates synthetic entities.
  • Provisions (loads) the generated entities to the target environment.
  • Marks the entities as reserved.

Load

  • Gets the data from the TDM warehouse and provisions it to the target environment.

Load + Reserve

  • Gets the data from the TDM warehouse and provisions it to the target environment.
  • Marks the provisioned entities as reserved.

Load + Delete

  • Gets the data from the TDM warehouse.
  • Deletes and reprovisions (reloads) it to the target environment.

Load + Delete + Reserve

  • Gets the data from the TDM warehouse.
  • Deletes and reprovisions (reloads) it to the target environment.
  • Marks the entities as reserved.

Delete

  • Deletes (cleans) the entities from the target environment.

Reserve

  • Reserves entities in the target environment.

Who Can Create a Task?

  • Admin users.
  • Environment owners can create a TDM task for their environment.
  • Testers who can create a TDM task for the environments they are attached to by a TDM Environment Permission Set:
    • Source environment, testers must be attached to the source environment by a permission set with Read access.
    • Target environment, testers must be attached to the target environment by a permission set with Write access.

TDM Tasks List Window

The TDM Task List displays, by default, the list of all Active tasks in the TDM. It displays the following settings on each task. These settings can also be used to filter the displayed tasks:

  • Task ID
  • Task Title - task name
  • Task's source and target environments
  • BE name
  • Task Action - Extract, Generate, Load, Delete or Reserve
  • Task's Operation mode. Additional information about the task when multiple task actions are set in the task. For example: Delete and load entity.
  • Reserve Ind - indicates if the task reserves the entities.
  • Data Versioning - true/false
  • Data Type - Entities and/or Reference
  • Selection Method - selection criteria for entities
  • Number of processed entities
  • General parameters such as created by user and update date.

The following screenshot shows an example of the TDM Task List.

tasks list

  1. Click Show/Hide Columns to open a popup window, which displays the list of available fields for each task.

  2. To display additional fields, click the fields.

  3. To remove a field from the display, click the field:

    show hide columms

  4. To find a field, populate the Search bar in order to filter the tasks by the searched value.

The TDM Portal displays a list of icons next to each task record:

How Do I Create or Edit a Task?

  1. Click New Task in the right corner of the Tasks List window.
  2. To open a selected task, click the Task Title (task name) of the task.
  3. Click the Back of Next buttons to move between the tabs.
  4. Click Finish in the last tab to create the task. Once the task has been edited, a new version with a new task_id is created. The old version is saved in the TDM DB for tracking purposes and its status is set to Inactive.

Task Tabs

Mandatory Tabs

1. General

Main task's information:

  • Task title (name)
  • Task action (s)
  • Business Entity
  • Environment(s)

2. Additional Execution Parameters

This tab defines various execution parameters such as Data Type (Entities and/or Reference tables), Data Versioning, Reservation Period, etc… The list of parameters depends on the selected task actions and the user's permissions.

3. Requested Entities

Entities' selection method. The Requested Entities tab is opened if the task processes entities.

4. Task Scheduling

Execution by request or Scheduled Execution.

Optional Tabs

Task Variables

Set the value of variables on the task level.

Reference

Select reference table(s) if the task includes reference tables.

Previous

TDM Task Overview

Data provisioning and entity reservation are implemented by creating and executing TDM tasks.

A TDM task is created in the TDM Portal. It holds a list of instructions and settings that define the task action (type) and subset of processed entities, the source and target environments and additional information. For example, create a task to copy 5 customers with small and medium business plans from Production into the UAT1 target environment.

The actual data provisioning and/or entity reservation is performed by the task execution, where each task can be executed multiple times.

Task Actions (types)

The following task actions are supported by TDM:

  • Extract - extracts the selected entities and/or Reference tables from the selected source environment. The data can be saved in Fabric for a later use.
  • Generate - generates synthetic entities. The entities can be saved in Fabric for a later use.
  • Load - provisions the selected entities and/or Reference tables to the selected target environment.
  • Delete - deletes the selected entities from the target environment.
  • Reserve - reserves the selected entities in the target environment.

A TDM task can have a combination of multiple task actions.

The following table describes the valid combinations of task actions in a TDM task:

Combination

Description

Extract

  • Extracts the data from the source environment into the TDM warehouse.

Extract + Load

  • Refreshes all data from the source and provisions (loads) the data to the target environment.

Extract + Load + Reserve

  • Extracts the data from the source environment.
  • Provisions (loads) the data to the target environment and marks the entities as reserved.

Extract + Load + Delete

  • Extracts the data from the source environment.
  • Deletes and reprovisions (reloads) the data to the target environment.

Extract + Load + Delete + Reserve

  • Extracts the data from the source environment.
  • Deletes and reprovisions (reloads) it to the target environment.
  • Marks the entities as reserved.

Generate

  • Generate synthetic entities

Generate + Load

  • Generates synthetic entities.
  • Provisions (loads) the generated entities to the target environment.

Generate + Load + Reserve

  • Generates synthetic entities.
  • Provisions (loads) the generated entities to the target environment.
  • Marks the entities as reserved.

Load

  • Gets the data from the TDM warehouse and provisions it to the target environment.

Load + Reserve

  • Gets the data from the TDM warehouse and provisions it to the target environment.
  • Marks the provisioned entities as reserved.

Load + Delete

  • Gets the data from the TDM warehouse.
  • Deletes and reprovisions (reloads) it to the target environment.

Load + Delete + Reserve

  • Gets the data from the TDM warehouse.
  • Deletes and reprovisions (reloads) it to the target environment.
  • Marks the entities as reserved.

Delete

  • Deletes (cleans) the entities from the target environment.

Reserve

  • Reserves entities in the target environment.

Who Can Create a Task?

  • Admin users.
  • Environment owners can create a TDM task for their environment.
  • Testers who can create a TDM task for the environments they are attached to by a TDM Environment Permission Set:
    • Source environment, testers must be attached to the source environment by a permission set with Read access.
    • Target environment, testers must be attached to the target environment by a permission set with Write access.

TDM Tasks List Window

The TDM Task List displays, by default, the list of all Active tasks in the TDM. It displays the following settings on each task. These settings can also be used to filter the displayed tasks:

  • Task ID
  • Task Title - task name
  • Task's source and target environments
  • BE name
  • Task Action - Extract, Generate, Load, Delete or Reserve
  • Task's Operation mode. Additional information about the task when multiple task actions are set in the task. For example: Delete and load entity.
  • Reserve Ind - indicates if the task reserves the entities.
  • Data Versioning - true/false
  • Data Type - Entities and/or Reference
  • Selection Method - selection criteria for entities
  • Number of processed entities
  • General parameters such as created by user and update date.

The following screenshot shows an example of the TDM Task List.

tasks list

  1. Click Show/Hide Columns to open a popup window, which displays the list of available fields for each task.

  2. To display additional fields, click the fields.

  3. To remove a field from the display, click the field:

    show hide columms

  4. To find a field, populate the Search bar in order to filter the tasks by the searched value.

The TDM Portal displays a list of icons next to each task record:

How Do I Create or Edit a Task?

  1. Click New Task in the right corner of the Tasks List window.
  2. To open a selected task, click the Task Title (task name) of the task.
  3. Click the Back of Next buttons to move between the tabs.
  4. Click Finish in the last tab to create the task. Once the task has been edited, a new version with a new task_id is created. The old version is saved in the TDM DB for tracking purposes and its status is set to Inactive.

Task Tabs

Mandatory Tabs

1. General

Main task's information:

  • Task title (name)
  • Task action (s)
  • Business Entity
  • Environment(s)

2. Additional Execution Parameters

This tab defines various execution parameters such as Data Type (Entities and/or Reference tables), Data Versioning, Reservation Period, etc… The list of parameters depends on the selected task actions and the user's permissions.

3. Requested Entities

Entities' selection method. The Requested Entities tab is opened if the task processes entities.

4. Task Scheduling

Execution by request or Scheduled Execution.

Optional Tabs

Task Variables

Set the value of variables on the task level.

Reference

Select reference table(s) if the task includes reference tables.

Previous