Importing regular expressions or SQL patterns from Talend Exchange - 7.1

Talend Data Management Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Management Platform
task
Design and Development
EnrichPlatform
Talend Studio

You can import the .xmi files of regular expressions or SQL patterns from Talend Exchange into the repository of your current Talend Studio and use them to analyze columns.

You can import only versions that are compatible with the version of your current Talend Studio.

About this task

Prerequisite(s): You have selected the Profiling perspective in the studio. Your network is up and running.

The below procedure uses SQL patterns as an example. You can follow the same steps to import regular expressions.

To import SQL patterns from Talend Exchange , do the following:

Procedure

  1. In the DQ Repository tree view, expand Libraries > Exchange.
    If you have connection problems, you will not have access to any of the items under the Exchange node. A pop-up will prompt you to check your internet connection.
  2. Under Exchange, expand SQL and right-click the name of the pattern you want to import.
  3. Select Import in DQ Repository.
    You will have access only to versions that are compatible with the version of your current Talend Studio

    The Import From Talend Exchange wizard opens.

  4. Select the Overwrite existing items check box if some error and warning messages are listed in the Error and Warning area.
    This means that a pattern with the same name already exists in the current studio. The imported pattern will replace the one in Talend Studio.
  5. Click Finish.
    A progress information bar is displayed. The pattern is listed under the Patterns > SQL folder in the DQ Repository tree view.
    The patterns you import in your studio will be imported with the structure they had in the initial repository. They will be imported under the same folder or subfolder they had initially.