Managing data containers - 6.3

Talend MDM Platform Studio User Guide

EnrichVersion
6.3
EnrichProdName
Talend MDM Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

An authorized user can also import/export, copy/paste and delete created data containers from Talend Studio.

Note

It is also possible to import and share MDM complete projects or only a data model or part of the data model from the community web page, Talend Exchange. For further information, see Projects/objects on Talend Exchange.

How to browse a data container

Using Talend Studio, you can easily search and locate data records "attached" to the corresponding business entities in the MDM Hub.

More than one search option is available to specify the search criteria and to narrow down your search for the data records you want to view. You can:

  • use a time-based filter (from/to dates),

  • select a business entity in which to search data records,

  • type in the unique key for the business entity you want to search for,

  • type in a search keyword.

Prerequisite(s): You have already connected to the MDM server in Talend Studio. A data container exists and is populated with data records.

To browse a data container:

  1. In the MDM Repository tree view, expand the Data Container node.

  2. Double-click the data container you want to browse.

    The data container editor opens with a master data container view.

    Note

    If the data container is configured with the staging storage, a staging data container view will also be available.

    The following steps describe how to browse a master data container.

    The steps for browsing a staging data container are similar to those for browsing a master data container, except that the Use Full Text Search check box is grayed in the staging data container view.

    You can set one or several search criteria to narrow your search on the returned data records. Note that, if you are using a SQL database, you cannot combine a full-text query with other search criteria.

  3. Click the From arrow to display a calendar where you can select a start date for the data records created in the selected data container.

  4. Click the To arrow to display a calendar where you can select an end date for the data records created in the selected data container.

    Note

    It is possible to click the browse button directly after setting the time range to base your search only on one criterion. Otherwise, you can use one or more of the other search criteria to narrow down your search on the returned data records.

  5. From the Entity list, select a business entity from the list to search data records only in the selected business entity.

  6. In the Keys field, enter the unique key for the entity you want to search.

  7. In the Keywords field, enter a search keyword to include only matching values in the returned data records.

  8. If you want the record list to show the task identification, select the Show Task ID check box.

    Some of the data records in the MDM Hub are the result of merging /resolving different information coming from heterogeneous sources. Resolving such information is done through Talend Data Stewardship Console and then the master data record is written in the hub using some MDM components in a Talend Job. For further information, see the Talend Data Stewardship Console User Guide.

    For further information about editing the task identification, see Editing a task identification from the data container.

  9. Click the icon.

    The lower part of the editor lists all data records that match the search criteria along with their creation dates, the business entities they are created in and their unique keys.

  10. Double-click a given record to open up a dialog box that displays the data record details.

    You can also click the Source tab at the top of the dialog box to view the data record in its XML format or modify the data record.

    After updating the data record, if needed, select the Fire a change event (update report) and triggers check box so that the modified record will be written into the UpdateReport and eligible Triggers will be executed directly.

    After selecting the Fire a change event (update report) and triggers check box, if required, select the Enable verification by before processes check box to enable the verification of the modified record by the Before Saving processes. For more information about Process types, see Process types.

How to export data containers

From Talend Studio you can export one or multiple data containers in order to exchange them between two different MDM Servers or Repositories.

The steps to export one or multiple data containers are similar to those for any other data object in the MDM Repository tree view. For detailed information on how to export data containers, see How to export data models.

You can also export data containers using the command mExportDataContainer from the CommandLine. For more information on how to use this command, see the help provided in the CommandLine.

For more information about the CommandLine, see the appendix on CommandLine in the Talend Administration Center User Guide.

How to import data containers

From Talend Studio you can import data containers created on other MDM servers, on the same MDM server, or in different MDM Repositories in the current MDM Repository.

The steps to import one or multiple data containers are similar to those for any other data object in the MDM Repository tree view. For detailed information on how to import data containers, see How to import data models.

You can also import data containers using the command mImportDataContainer from the CommandLine. For more information on how to use this command, see the help provided in the CommandLine.

For more information about the CommandLine, see the appendix on CommandLine in the Talend Administration Center User Guide.

How to copy/paste a data container

To avoid creating one or multiple data containers from scratch, you can copy an existing one and then paste it within the Data Container node in the MDM Repository tree view.

Prerequisite(s): You have already connected to the MDM server in Talend Studio. At least one data container exists.

To copy/paste a data container, do the following:

  1. In the MDM Repository tree view, expand the Data Container node.

  2. Right-click the container you want to copy and select Copy from the contextual menu.

  3. Right-click the Data Container node and select Paste from the contextual menu.

    A dialog box opens prompting you to enter a name for the new container.

  4. Enter a name for the new data container, and click OK to validate the changes and close the dialog box.

The new data container is listed under the Data Container node in the MDM Repository tree view.

How to duplicate a data container

To avoid creating one or multiple data containers from scratch, you can duplicate an existing one in the MDM Repository tree view.

Prerequisite(s): You have already connected to the MDM server in Talend Studio. At least one data container exists.

To duplicate a data container, do the following:

  1. In the MDM Repository tree view, expand the Data Container node.

  2. Right-click the container you want to duplicate and select Duplicate from the contextual menu.

    A dialog box opens prompting you to enter a name for the new container.

  3. Enter a name for the new data container and click OK to validate the changes and close the dialog box.

The new data container is listed under the Data Container node in the MDM Repository tree view.

How to remove a data container

You can remove a data container from the Data Container node and send it to the recycle bin if needed.

Prerequisite(s): You have already connected to the MDM server in Talend Studio. At least one data container exists.

  1. In the MDM Repository tree view, expand the Data Container node.

  2. Right-click the data container and select Remove from Repository from the contextual menu.

    A confirmation dialog box opens prompting you to confirm the operation or to cancel it.

  3. Click OK.

The data container is removed from the Data Container node and placed into the Recycle bin node.

Once in the recycle bin, you can delete the data container permanently or restore it.