How to set up the studio - 6.2

Talend Data Management Platform Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Management Platform
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Before being able to use regular expressions on analyzed columns in a database, you must first declare the created regular expression function, RegExMatch in this example, in the specified database via the Profiling perspective of the studio. To do that:

  1. In the DQ Repository tree view, expand Libraries > Indicators.

  2. Expand System Indicators > Pattern Matching.

  3. Double-click Regular Expression Matching, or right-click it and select Open from the contextual menu.

    The corresponding view displays the indicator metadata and its definition.

    You need now to add to the list of databases the database for which you want to define a query template. This query template will compute the regular expression matching.

  4. Click the [+] button at the bottom of the Indicator Definition view to add a field for the new template.

  5. In the new field, click the arrow and select the database for which you want to define the template, Microsoft SQL Server.

  6. Copy the indicator definition of any of the other databases.

  7. Click the Edit... button next to the new field.

    The [Edit expression] dialog box is displayed.

  8. Paste the indicator definition (template) in the Expression box and then modify the text after WHEN in order to adapt the template to the selected database.

  9. Click OK to proceed to the next step. The new template is displayed in the field.

  10. Click the save icon on top of the editor to save your changes.

For more detailed information on how to declare a regular expression function in the studio, see How to define a query template for a specific database and How to declare a User-Defined Function in a specific database.