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:
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.
Under Exchange, expand SQL and right-click the name of the pattern you
want to import.
Select Import in DQ
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.
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.
A progress information bar is displayed. The pattern is listed under the DQ Repository tree view.folder in theThe 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.