August 17, 2023

tStewardshipTaskDelete – Docs for ESB 5.x

tStewardshipTaskDelete

tStewardshipTaskDelete_icon32_white.png

Warning

This component is available in the Palette of Talend Studio
but you will only be able to use it on the condition that you have subscribed to the
relevant Talend Platform product.

tStewardshipTaskDelete properties

Component family

Talend MDM

 

Function

tStewardshipTaskDelete deletes data sets stored
in the stewardship console database in the form of tasks, either matching certain
search criteria or without any search criteria.

Note

In order to better understand the purpose of this component, consult the
Talend Data Stewardship Console User Guide.

Purpose

This component helps streamline processes by removing tasks that are no longer
used or relevant.

 Basic settings

Host

Server IP address of the stewardship console database.

 

Port

The listening port number of the database server.

 

User name and Password

Type in the authentication information to the MDM server.

To enter the password, click the […] button next to the
password field, and then in the pop-up dialog box enter the password between double quotes
and click OK to save the settings.

Delete by ID

Select this check box if you want to delete a task by providing its ID.

Input field of task ID

From the drop-down list, select the task ID that corresponds to the Task ID field. The choices available correspond to the
column names provided by the input component used.

Specify task ID

Optionally, you can enter directly the ID value of a task you want to delete. In
this case, select this check box to enter the task ID manually between double
quotes, in the Task ID field.

 

Type

Select the type of the tasks you want to delete:

Resolution: data resolution tasks represent the
results of the data matching processes done on data across heterogeneous
sources.

Data: data integrity tasks are the results of
the data integrity processes done on data.

For further information on task types and task management, see Talend Data Stewardship Console User Guide.

 

Owner

If required, type in the name of the task owner. This will filter the tasks
according to the task owner.

 

Tag

If required, type in the name of the tag category associated with the tasks you
want to delete.

For further information, see Talend Data Stewardship Console User
Guide
.

 

Start Date/End Date

If required, set a task creation date range within which you want to delete the
tasks. Use the following format: yyyy-mm-dd hh:mm:ss.

 

Status

If required, select from the list the task status you want to use to filter the
retrieved tasks.

 

Delete when Star ranking is equal to or less than

If required, select the number of stars, 0 through 5, assigned to the tasks as a
numerical rating to highlight importance. This will delete tasks up to a certain
level of importance only.

 

Limit

If required, set the maximum number of tasks to be deleted. If Limit = 0, this
means there is no limit to the number of tasks deleted.

Advanced settings

tStatCatcher Statistics

Select this check box to gather the processing metadata at the Job level as well
as at each component level.

Global Variables

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

DELETED_TASK_NUMBER: the number of deleted tasks. This is
an After variable and it returns an integer.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space
to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio
User Guide.

Log4j

The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User
Guide
.

For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html.

Scenario: Deleting tasks from the Data Stewardship Console

This scenario describes a multi-component Job that deletes data sets stored in the Data
Stewardship Console database in the form of tasks, if these tasks match certain criteria. The
first part of the scenario creates some sample data and data stewardship tasks, and the second
part deletes tasks which are not used.

use_case_tstewardshiptaskdelete.png

Creating sample stewardship tasks

The first part of this scenario creates the sample data and data stewardship
tasks.

  1. Drop a tFixedFlowInput component from the Palette onto the workspace, and rename it SampleData.

  2. In the Component view of tFixedFlowInput component called SampleData, click the Edit schema button.
    In the schema that opens, create the columns shown below and set the appropriate Type for each column.

    tstewardshiptaskdelete-sampledata_schema.png
  3. Select Use Inline Table and enter some data in each
    of the columns, as in the example below.

    tstewardshiptaskdelete-inlinetable_data.png
  4. Drop a tStewardshipTaskOutput component onto the
    workspace, and rename it CreateStewardshipTasks.

    The tStewardshipTaskOutput component creates tasks in
    the Talend Data Stewardship Console database and lists these tasks in the
    Talend Data Stewardship Console.

  5. Connect the tFixedFlowInput component called
    SampleData to the tStewardshipTaskOutput component called CreateStewardshipTasks using a Row Main
    link.

  6. In the Component view of tStewardshipTaskOutput component called CreateStewardshipTasks, in the Basic
    settings
    tab, provide the connection information (Host, Port, User
    name
    and Password) for the Data Stewardship
    Console to which you want to connect, and the information about the tasks you want to
    create, as shown in the following example.

    tstewardshiptaskdelete-createstewardshiptasks.png
  7. Run your Job and then open the Data Stewardship Console to check that your tasks have
    been created.

Deleting unused tasks

The second part of this scenario lets you delete those tasks which are no longer
used.

  1. Drop a tStewardshipTaskInput component from the
    Palette onto the workspace. Connect the tFixedFlowInput component called SampleData to the tStewardshipTaskInput
    component using an OnSubjobOk trigger.

  2. In the tStewardshipTaskInput_1 component, in the
    Basic settings tab, provide the connection information
    (Host, Port, User name and Password) for the
    Data Stewardship Console to which you want to connect, and information about the tasks you
    want to use as input (Owner, Tag, Start Date and End Date).

    For this scenario, make sure you specify the Tag as
    tag1.

    tstewardshiptaskdelete-input1_settings.png
  3. Drop a tLogRow component from the Palette onto the workspace. Connect the tStewardshipTaskInput_1 component to the new tLogRow component using a Row Main
    link.

    The tLogRow component is used to monitor data
    processed.

  4. Drop a tStewardshipTaskDelete component from the
    Palette onto the workspace. Connect the tStewardshipTaskDelete component to the tStewardshipTaskInput_1 component using an OnSubjobOk trigger.

    The tStewardshipTaskDelete component helps streamline
    processes by removing tasks that are no longer used or relevant when they match certain
    criteria.

  5. In the tStewardshipTaskDelete component, in the
    Basic settings tab, provide the connection information
    (Host, Port, User name and Password) for the
    Data Stewardship Console to which you want to connect.

  6. In the Task Configuration area of the Basic settings tab of the tStewardshipTaskDelete component, enter the criteria to use when deciding
    which tasks to delete. An example is shown in the image below.

    tstewardshiptaskdelete-task_configuration.png
  7. Drop a tJava component from the Palette onto the workspace. Connect the tStewardshipTaskDelete component to the tJava component using an OnSubjOk
    trigger.

    The tJava component makes it possible to extend the
    functionalities of a Talend Job through
    using Java commands. In this case, it shows you which tasks are deleted.

  8. In the Basic settings tab of the tJava component, enter the following code:

  9. Press F6 to run your Job and refresh or reopen the
    Data Stewardship Console to check that your tasks have been deleted.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x