Defining a data model for the Arbitration campaign - Cloud

Talend Cloud Data Stewardship Examples

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Data Stewardship
Content
Data Governance > Assigning tasks
Data Governance > Managing campaigns
Data Governance > Managing data models
Data Quality and Preparation > Handling tasks

Create a data model to determine the structure of the data to be managed in the Beta candidates campaign which helps data stewards to select the appropriate candidates of a software beta testers.

Talend Cloud Data Stewardship has data model awareness which makes possible the syntactic and semantic validation of data. You can define the attributes in the data model and select their types out of a predefined standard or semantic types.

Procedure

  1. Select DATA MODELS > ADD DATA MODEL.
  2. Enter a name and a description for the new model in the Name and Description fields respectively. Optional fields are marked with * next to their names.
  3. In the Attributes section, define the columns you want to have in the data model as the following:
    1. In the IDENTIFIER field, enter the technical identifier for the first column.
    2. Enter a name and a description for the column in the corresponding fields, if needed.
      What you set in the NAME field is the name displayed in the task list. If no name is set, the technical identifier will be displayed.
    3. From the attribute type list, select the type of the column.

      Standard and semantic types are integrated in the application by default.

      • For the standard types, additional fields are displayed according to the type you select. These fields are optional and they enable you to define some constraints on the attribute you define such as defining a minimum and/or maximum length or defining a pattern against which to validate the attribute.

        To make sure the entire value matches your validation pattern, it is best practice to surround the validation pattern with ^ and $.

        Some examples:
        • [A-Z] matches A and ABC.
        • ^[A-Z]$ matches A but does not match ABC.

        For Date and Timestamp columns, you have access to a date and time picker which helps you set the date and time automatically in the right format.

      • For the semantic types, you can use the Talend Dictionary Service to manage the semantic types. However, the availability of this service depends on the license you have.
  4. Optionally, toggle the ALLOW EMPTY VALUES option to disable the upload of empty fields. This option is enabled by default.
  5. Click ADD ATTRIBUTE and repeat the above steps to create all the columns you need in the data model.

    Example

    The columns defined for the Beta Candidates campaign include information about the participants, their addresses, email addresses, occupation and the company in which they work as shown in the capture.

  6. To display email address as hyperlinks in the task list, set the semantic type for the Email column to MailTo URL.
    This enables you to click the email address directly from the task list to open a new window where you can send an email to the recipient.